使用旧的控制文件恢复

备份控制文件alter database backup controlfileto "/bk/ctl.bk"; SQL> alter system switch logfile;alter system switch logfile*ERROR at line 1:ORA-03113: end-of-file on communication channel SQL> conn /as sysdbaConnected to an idle instance.SQL> startupOracle instance started. Total System Global Area 314572800 bytesFixed Size 1219136 bytesVariable Size 100664768 bytesDatabase Buffers 205520896 bytesRedo Buffers 7168000 bytesORA-00205: error in identifying control file, checkalert log for more info SQL> ！ /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl/bin/bash: /bk/ctl.bk: ？？？？ SQL> ！ cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl SQL> ！ cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control03.ctl SQL> ！ cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control01.ctl 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 fordatabase open在做resetlogs启数据库也会因为数据文件内部一致而中止,需要恢复 SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to beconsistentORA-01110: data file 1: "/u01/tiger/oradata/orcl2/system01.dbf" SQL> recover database;ORA-00283: recovery session canceled due to errorsORA-01610: recovery using the BACKUP CONTROLFILE option mustbe done数据库检测控制文件和数据文件的SCN的对比，发现控制文件是老的 SQL> recover database using backupcontrolfile;ORA-00279: change 458762 generated at 09/03/201214:28:45 needed for thread 1ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_2_%u_.arcORA-00280: change 458762 for thread 1 is insequence #2 Specify log: {<RET>=suggested | filename |AUTO | CANCEL}autoORA-00279: change 458780 generated at 09/03/201214:50:27 needed for thread 1ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_3_%u_.arcORA-00280: change 458780 for thread 1 is insequence #3ORA-00278: log file"/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_2_848nst62_.arc"no longerneeded for this recovery ORA-00279: change 458785 generated at 09/03/201214:50:35 needed for thread 1ORA-00289: suggestion : /u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_4_%u_.arcORA-00280: change 458785 for thread 1 is insequence #4ORA-00278: log file"/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_3_848nsvk0_.arc"no longerneeded for this recovery ORA-00279: change 458791 generated at 09/03/201214:50:42 needed for thread 1ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arcORA-00280: change 458791 for thread 1 is insequence #5ORA-00278: log file"/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_4_848nt295_.arc"no longerneeded for this recovery ORA-00308: cannot open archived log"/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arc"ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3这个文件还没归档因为是current组还没来得及切换日志（切换日志才能归档）提供redo给它一组组尝试SQL> recover database using backupcontrolfile;ORA-00279: change 458791 generated at 09/03/201214:50:42 needed for thread 1ORA-00289: suggestion : /u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arcORA-00280: change 458791 for thread 1 is insequence #5 Specify log: {<RET>=suggested | filename |AUTO | CANCEL}/u01/tiger/oradata/orcl2/redo01.logLog applied.Media recovery complete.SQL> alter database openresetlogs; Database altered. SQL>Oracle控制文件备份恢复 resetlogs方式Oracle 备份恢复：flashback闪回相关资讯 Oracle恢复

Oracle数据表被drop后的恢复（10/15/2014 10:43:07）
Oracle手工完全恢复案例（归档模式（06/30/2013 07:23:39）
Oracle控制文件新增，备份，恢复（06/22/2013 09:11:04）

Oracle基于cancel的不完全恢复（10/08/2014 19:32:05）
Oracle手工恢复案例（非归档模式）（06/30/2013 07:21:38）
Oracle手工恢复控制文件的深入解析（06/16/2013 09:12:06）

本文评论查看全部评论（0）