Wednesday, April 22, 2009

add logfile to rac

alter database add logfile thread 1 group 1 ('+DATA/FRMDB/onlinelog/redo01_1.log', '+BACKUP/FRMDB/onlinelog/redo01_1.log') size 100m
alter database add logfile thread 1 group 2 ('+DATA/FRMDB/onlinelog/redo02_1.log', '+BACKUP/FRMDB/onlinelog/redo02_1.log') size 100m
alter database add logfile thread 2 group 3 ('+DATA/FRMDB/onlinelog/redo03_2.log', '+BACKUP/FRMDB/onlinelog/redo03_2.log') size 100m
alter database add logfile thread 2 group 4 ('+DATA/FRMDB/onlinelog/redo04_2.log', '+BACKUP/FRMDB/onlinelog/redo04_2.log') size 100m

alter database drop logfile group 4;
select group#,status,members from v$log;

alter system set control_files='+DATA/FRMDB/CONTROLFILE/control01.ctl','+BACKUP/FRMDB/CONTROLFILE/control02.ctl';


rmalias control02.ctl
mkalias +DATA/FRMDB/CONTROLFILE/Current.5715.684803005 control01.ctl

No comments: