Full oracle recovery from backup control files

Oracle completely restores SYS @ orcl # shutdown abort from the backup control file; the ORACLE routine has been disabled. SYS @ orcl # oracle @ oracle :~ /Product/10.2/db_1/dbs> rman target/recovery Manager: Release 11.1.0.6.0-Production on Wednesday June 5 23:13:10 2013 Copyright (c) 1982,200 7, Oracle. all rights reserved. you have connected to the target database (not started) RMAN> startup nomount; oracle instance started system global region total 805875712 bytes Fixed Size 2148720 bytes Variable Size 520095376 bytes Database Buffers 276824064 bytes Redo Buffers 6807552 bytes RMAN> restore controlfile from '/opt/oracle/product/10.2 /db_1/dbs/snapcf_orcl. F'; start the restore on March 13, 152. Use the target database control file to replace the channel for restoring directory allocation: ORA_DISK_1 channel ORA_DISK_1: SID = device type = DISK channel ORA_DISK_1: copied control file copy output file name =/opt/oracle/oradata/ORCL/controlfile/o1_mf_7q9c8orh _. ctl output file name =/opt/oracle/flash_recovery_area/ORCL/controlfile/o1_mf_7q9c8pcf _. ctl completes restore in month 05-6-13 RMAN> exitSYS @ orcl # select file #, creation_change #, checkpoint_change # from v $ datafile_header; FILE # CREATION_CHANGE # CHECKPOINT _ CHANGE # ---------- ---------------- 1 7 4918372 2 1490 4918372 3 841603 4 4918372 5 14607 4918372 6 955886 4918372 7 958063 4918372 8 959259 9 4918372 10 3975193 11 4918372 FILE # CREATION_CHANGE # CHECKPOINT_CHANGE # ---------- ---------------- ------------------ 12 4400418 12 rows have been selected. SYS @ orcl # select file #, creation_change #, checkpoint_change #, last_change # from v $ datafile; FILE # CREATION_CHANGE # CHECKPOINT_CHANGE # LAST_CHANGE # ---------- ---------------------------- ------------ 1 7 4393541 2 1490 4393541 3 841603 4 4393541 5 14607 4393541 6 955886 7 4393541 8 958063 4393541 9 959259 10 10 3978313 4393541 11 4400356 4400358 FILE # CREATION _ CHANGE # CHECKPOINT_CHANGE # LAST_CHANGE # ---------- ---------------- ------------------ ------------ 12 4400418 12 rows have been selected. SYS @ orcl # YS @ orcl # alter database open; alter database open * 1st Line Error: ORA-01589: to open the database, you must use the RESETLOGS or NORESETLOGS option SYS @ orcl # alter database open resetlogs; alter database open resetlogs * 1st line with an error: ORA-01194: file 1 needs more recovery to maintain consistency ORA-01110: Data File 1: '/opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw _. dbf 'sys @ orcl # try to recover: SYS @ orcl # recover database using backup controlfileORA-00279: Change 4400440 (in 05/1 8/2013 16:04:12 generation) is required for thread 1 ORA-00289: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_18/o1_mf_1_81_8sh7pk32 _. arcORA-00280: Change 4400440 (for thread 1) specify log in sequence #81: {<RET> = suggested | filename | AUTO | CANCEL} autoORA-00279: Change 4419709 (generated at 05/18/2013 23:31:28) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_19/o1_mf_000082_8sjsowfc _. arcORA-00280: Changing 441970 9 (for thread 1) ORA-00278 in sequence #82: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_18/o1_mf_1_81_8sh7pk32 _. arc 'ORA-00279: Change 4444358 (generated at 05/19/2013 13:44:27) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_83_8snczbm2 _. arcORA-00280: Change 4444358 (for thread 1) ORA-00278 in sequence #83: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013 _ 05_19/o1_mf_000082_8sjsowfc _. arc 'ORA-00279: Change 4489193 (generated at 05/20/2013 22:15:06) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_84_8sngy53f _. arcORA-00280: Change 4489193 (for thread 1) ORA-00278 in sequence #84: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_83_8snczbm2 _. arc 'ORA-00279: Changing 4491206 (generated at 05/20/2013 23:05:40) is required for thread 1 OR A-00289: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_85_8sngyk4r _. arcORA-00280: Change 4491206 (for thread 1) ORA-00278 in sequence #85: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_84_8sngy53f _. arc 'ORA-00279: Change 4491216 (generated at 05/20/2013 23:05:53) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_86_8snh06s7 _. arc ORA-00280: Change 4491216 (for thread 1) ORA-00278 in sequence #86: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_85_8sngyk4r _. arc 'ORA-00279: Change 4491242 (generated at 05/20/2013 23:06:46) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_87_8snh0rpw _. arcORA-00280: Change 4491242 (for thread 1) ORA-00278 in sequence #87: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ ORCL/archivelog/2013_05_20/o1_mf_1_86_8snh06s7 _. arc 'ORA-00279: Change 4491256 (generated at 05/20/2013 23:07:04) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_88_8sq3wv1s _. arcORA-00280: Change 4491256 (for thread 1) ORA-00278 in sequence #88: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_87_8snh0rpw _. arc 'ORA-00279: Change 4518080 (at 05/21/2013 23: 15: 38) is required for thread 1 ORA-00289: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_89_8sq481 _. arcORA-00280: Change 4518080 (for thread 1) ORA-00278 in sequence #89: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_88_8sq3wv1s _. arc 'ORA-00279: Change 4538405 (generated at 05/21/2013 23:21:39) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_m F_000090_8sq4oryo _. arcORA-00280: Change 4538405 (for thread 1) ORA-00278 in sequence #90: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_89_8sq481 _. arc 'ORA-00279: Change 4558870 (generated at 05/21/2013 23:28:56) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_91_8sq5026m _. arcORA-00280: Change 4558870 (for thread 1) ORA-00278 in sequence #91: This recovery no longer requires the log file '/opt/oracle/ Flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_90_8sq4oryo _. arc 'ORA-00279: Change 4579214 (generated at 05/21/2013 23:34:26) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_92_8t36mf0h _. arcORA-00280: Change 4579214 (for thread 1) ORA-00278 in sequence #92: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_91_8sq5026m _. arc 'ORA-00279: Change 4591978 (Generated at 13:15:24 on 05/26/2013) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_93_8t3mjq4n _. arcORA-00280: Change 4591978 (for thread 1) ORA-00278 in sequence #93: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_92_8t36mf0h _. arc 'ORA-00279: Change 4614777 (generated at 05/26/2013 16:55:50) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archiv Elog/2013_05_27/o%mf_%94_8t6ns7c9 _. arcORA-00280: Change 4614777 (for thread 1) ORA-00278 in sequence #94: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_93_8mjq4n _. arc 'ORA-00279: Change 4652531 (generated at 05/27/2013 20:35:50) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o%mf_%95_8t6wq99o _. arcORA-00280: Change 4652531 (for thread 1) ORA-00278 in sequence #95: This recovery does not The log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o1_mf_1_94_8t6ns7c9 _. arc 'ORA-00279: Change 4672336 (generated at 05/27/2013 22:51:20) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_29/o1_mf_1_96_8td3yzv5 _. arcORA-00280: Change 4672336 (for thread 1) ORA-00278 in sequence #96: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o1_mf_1_95_8t6wq99o _. arc' OR A-00279: Change 4704486 (generated at 05/29/2013 22:25:35) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_30/o1_mf_000097_8tgq14y8 _. arcORA-00280: Change 4704486 (for thread 1) ORA-00278 in sequence #97: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_29/o1_mf_1_96_8td3yzv5 _. arc 'ORA-00279: Change 4733613 (generated at 05/30/2013 22:03:16) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recov Ery_area/ORCL/archivelog/2013_06_01/o1_mf_000098_8tmqz7h3 _. arcORA-00280: Change 4733613 (for thread 1) ORA-00278 in sequence #98: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_30/o1_mf_1_97_8tgq14y8 _. arc 'ORA-00279: Change 4764093 (generated on 06/01/2013 19:49:58) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_1_99_8tmtn5ch _. arcORA-00280: Change 4764093 (for thread 1) in sequence #99 ORA-00278: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_000098_8tmqz7h3 _. arc 'ORA-00279: Change 4786052 (generated on 06/01/2013 20:35:17) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_1_100_8tn3ndbb _. arcORA-00280: Change 4786052 (for thread 1) ORA-00278 in sequence #100: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf _ 201799_8tmtn5ch _. arc 'ORA-00279: Change 4817616 (generated on 06/01/2013 23:08:59) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_101_8tyj6hqj _. arcORA-00280: Change 4817616 (for thread 1) ORA-00278 in sequence #101: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_1_100_8tn3ndbb _. arc 'ORA-00279: Change 4862007 (generated at 09:59:40 on 06/02/2013) is a required ORA-00289 for thread 1: Build Discussion:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_102_8tyj6hs8 _. arcORA-00280: Change 4862007 (for thread 1) ORA-00278 in sequence #102: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_101_8tyj6hqj _. arc 'ORA-00279: Change 4882809 (generated on 06/02/2013 10:11:27) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_103_8tyj6sy0 _. arcORA-00 280: Change 4882809 (for thread 1) ORA-00278 in sequence #103: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_102_8tyj6hs8 _. arc 'ORA-00279: Change 4904327 (generated at 21:44:57 on 06/05/2013) ORA-00289 required for thread 1: Recommended:/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_1__8tyl1p33 _. arcORA-00280: Change 4904327 (for thread 1) ORA-00278 in sequence #104: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/OR CL/archivelog/2013_06_05/o1_mf_1_103_8tyj6sy0 _. arc 'ORA-00279: Change 4915553 (generated at 22:16:21 on 06/05/2013) ORA-00289 required for thread 1: recommended: /opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_0000105 _ % u _. arcORA-00280: Change 4915553 (for thread 1) ORA-00278 in sequence #105: This recovery no longer requires the log file '/opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_1_1__8tyl1p33 _. arc 'ORA-00308: Unable to open archive log'/opt/oracle/flash_recovery _ Area/ORCL/archivelog/2013_06_05/o1_mf_0000105 _ % u _. arc 'ora-27037: Unable to get file status Linux-x86_64 Error: 2: No such file or directoryAdditional information: 3 SYS @ orcl # View file this is the last archived log, use online logs for recovery: YS @ orcl # select * from v $ log; GROUP # THREAD # SEQUENCE # bytes members archiv status FIRST_CHANGE # FIRST_TIME ---------- ------ begin ------------------------------------------------------------------------------------------------------- ------------ 1 1 79 52428800 2 yes inactive 4346916 16-5 month-13 3 1 81 52428800 2 no current 4393541 18-5 month-13 2 1 80 52428800 2 yes inactive 4369258 18-5 month-13 complete once restore. SYS @ orcl # alter database open resetlogs; the database has been changed. SYS @ orcl #