一次曲折的rman控制文件恢复

一次曲折的rman控制文件恢复用rman备份一个最新的控制文件rman target / catalog rman/rman@catdbRMAN>backup current controlfile format ='/oracle/backup/backup_%U';破坏控制文件select name from v$controlfile;/dev/rctrlfile1/dev/rctrlfile2/dev/rctrlfile3用dd把控制文件都搞坏，如下：# dd if=/dev/zero of=/dev/rctrlfile1 bs=32k------没有归档当前的redo log。

SQL> shutdown abort;ORACLE instance shut down.尝试正常启动数据库SQL> startupORACLE instance started.Total System Global Area 167772160 bytesFixed Size 2094904 bytesVariable Size 100665544 bytesDatabase Buffers 58720256 bytesRedo Buffers 6291456 bytesORA-00205: error in identifying control file, check alert log for more info报错，把数据库启动到nomount状态SQL> shutdownORA-01507: database not mountedORACLE instance shut down.SQL> startup nomountORACLE instance started.Total System Global Area 167772160 bytesFixed Size 2094904 bytesVariable Size 100665544 bytesDatabase Buffers 58720256 bytesRedo Buffers 6291456 bytesSQL>连接rman，准备恢复数据库文件。

ibmchen$[/oracle]rman target / catalog rman/rman@catdbRecovery Manager: Release 10.2.0.5.0 - Production on Wed Mar 14 16:18:09 2012Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: orac (not mounted)connected to recovery catalog database检查是否打开CONTROLFILE AUTOBACKUP ONRMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'/oracle/backup/%U';CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default结果：没有打开AUTOBACKUP列出备份的控制文件RMAN> list backup of controlfile;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ---------------------------214 Full 5.30M DISK 00:00:0514-MAR-12BP Key: 216 Status: AVAILABLE Compressed: NO Tag: TAG20120314T051102Piece Name:/oracle/app/oracle/product/10.2.0/db_1/dbs/05n5que6_1_1Control File Included: Ckp SCN: 5593672 Ckp time:14-MAR-12BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ---------------------------246 Full 5.30M DISK 00:00:0414-MAR-12BP Key: 250 Status: AVAILABLE Compressed: NO Tag: TAG20120314T090504Piece Name:/oracle/app/oracle/product/10.2.0/db_1/dbs/07n5rc5h_1_1Control File Included: Ckp SCN: 5637823 Ckp time:14-MAR-12BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ---------------------------283 Full 5.30M DISK 00:00:0714-MAR-12BP Key: 287 Status: AVAILABLE Compressed: NO Tag: TAG20120314T102947Piece Name: /oracle/backup/backup_09n5rh38_1_1Control File Included: Ckp SCN: 5642424 Ckp time:14-MAR-12BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ---------------------------315 Full 5.27M DISK 00:00:0314-MAR-12BP Key: 318 Status: AVAILABLE Compressed: NO Tag: TAG20120314T132455Piece Name: /oracle/backup/control.bkpControl File Included: Ckp SCN: 5644103 Ckp time:14-MAR-12挑一个最新的备份（最新的未必好使）恢复控制文件：RMAN> restore controlfile from '/oracle/backup/control.bkp';Starting restore at 14-MAR-12allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISKchannel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:08 output filename=/dev/rctrlfile1output filename=/dev/rctrlfile2output filename=/dev/rctrlfile3Finished restore at 14-MAR-12RMAN>控制文件恢复完毕，将数据库启动到mount状态SQL> alter database mount;Database altered.SQL> alter database open;alter database open*ERROR at line 1:ORA-01589: must use RESETLOGS or NORESETLOGS option for database open提示要用resetlogs方式打开SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/dev/rsystem'数据不一致，提示需要recover databaseSQL> recover database until cancel;ORA-00283: recovery session canceled due to errorsORA-01610: recovery using the BACKUP CONTROLFILE option must be done提示需要用BACKUP CONTROLFILE方式recover databaseSQL> recover database using backup controlfile until cancel; ORA-00279: change 5646533 generated at 03/14/2012 14:02:44 needed for thread 1ORA-00289: suggestion : /oracle/arch/arch1_161_772505712.dbf ORA-00280: change 5646533 for thread 1 is in sequence #161Specify log: {<RET>=suggested | filename | AUTO | CANCEL} autoORA-00308: cannot open archived log'/oracle/arch/arch1_161_772505712.dbf'ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3ORA-00308: cannot open archived log'/oracle/arch/arch1_161_772505712.dbf'ORA-27037: unable to obtain file statusIBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01194: file 1 needs more recovery to be consistent我晕，/oracle/arch/arch1_161_772505712.dbf没有归档。