Control File恢复(二)
rror in identifying control file, check alert log for more info
检查alter.log
ORA-00210:
ORA-00202: : ''+DATA/purple/controlfile/current03''
ORA-17503: ksfdopn: 2 +DATA/purple/controlfile/current03
ORA-15173: entry 'current03' does not exist in directory 'controlfile'
SQL> alter system set control_files='+DATA/purple/controlfile
/current01','+DATA/purple/controlfile/current02' scope=spfile
sid='*'; --修改control Files
/current01','+DATA/purple/controlfile/current02' scope=spfile
sid='*'; --修改control Files
System altered.
SQL> startup
SQL> shutdown immediate
ASMCMD> cp current02 current03 --拷贝好的控制文件
copying +data/purple/controlfile/current02 -> +data/purple
/controlfile/current03
/controlfile/current03
SQL>startup nomount;
SQL> alter system set control_files='+DATA/purple
/controlfile/current01','+DATA/
purple/controlfile/current02','+DATA/purple/controlfile
/current03' scope=spfile id='*'；
purple/controlfile/current02','+DATA/purple/controlfile
/current03' scope=spfile id='*'；
场景三：使用RMAN 恢复 Control Files
[sql]
RMAN> restore controlfile to '+DATA/purple/controlfile
/current04' from '+DATA/purple/controlfile/current01';
/current04' from '+DATA/purple/controlfile/current01';
Starting restore at 22-JAN-2013 11:12:29
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 instance=purple1 device type=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 22-JAN-2013 11:12:33
[sql]