Full Oracle recovery from backup control files

SYS @ orcl # shutdown abort;
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.
 
Connected to the target database (not started)
 
RMAN> startup nomount;
 
Oracle instance started
 
The system's global region consists of 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 restore from month 6 to month 13
Use the target database control file to replace the recovery directory
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 152 device type = DISK
 
Channel ORA_DISK_1: control file copy copied
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
The restore is completed from month 6 to month 13.
 
RMAN> exit
SYS @ orcl # select file #, creation_change #, checkpoint_change # from v $ datafile_header;
 
FILE # CREATION_CHANGE # CHECKPOINT_CHANGE #
--------------------------------------------
1 7 4918372
2 1490 4918372
3 841603 4918372
4 14607 4918372
5 955886 4918372
6 958063 4918372
7 959259 4918372
8 3975193 4918372
9 3977982 4918372
10 3978313 4918372
11 4400356 4918372
 
FILE # CREATION_CHANGE # CHECKPOINT_CHANGE #
--------------------------------------------
12 4400418 4918372
 
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 4393541
4 14607 4393541
5 955886 4393541
6 958063 4393541
7 959259 4393541
8 3975193 4393541
9 3977982 4393541
10 3978313 4393541
11 4400356 4400358
 
FILE # CREATION_CHANGE # CHECKPOINT_CHANGE # LAST_CHANGE #
--------------------------------------------------------
12 4400418 4400420
 
12 rows have been selected.
 
SYS @ orcl #
YS @ orcl # alter database open;
Alter database open
*
Row 3 has an 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
*
Row 3 has an error:
ORA-01194: File 1 requires 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 controlfile
ORA-00279: Change 4400440 (generated at 05/18/2013 16:04:12) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_18/o1_mf_1_81_8sh7pk32 _.
Arc
ORA-00280: changed 4400440 (for thread 1) in sequence #81
 

Specified log: {<RET> = suggested | filename | AUTO | CANCEL}
Auto
ORA-00279: Change 4419709 (generated at 05/18/2013 23:31:28) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_19/o1_mf_1_82_8sjsowfc _.
Arc
ORA-00280: changed 4419709 (for thread 1) in sequence #82
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_18/o1_mf_1_81_8sh7pk32 _
. Arc'
 

ORA-00279: Changing 4444358 (generated at 13:44:27) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_83_8snczbm2 _.
Arc
ORA-00280: Change 4444358 (for thread 1) in sequence #83
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_19/o1_mf_1_82_8sjsowfc _
. Arc'
 

ORA-00279: Changing 4489193 (generated at 22:15:06) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_84_8sngy53f _.
Arc
ORA-00280: changed 4489193 (for thread 1) in sequence #84
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_83_8snczbm2 _
. Arc'
 

ORA-00279: Changing 4491206 (generated at 23:05:40) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_85_8sngyk4r _.
Arc
ORA-00280: changed 4491206 (for thread 1) in sequence #85
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_84_8sngy53f _
. Arc'
 

ORA-00279: Changing 4491216 (generated at 23:05:53) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_86_8snh06s7 _.
Arc
ORA-00280: Change 4491216 (for thread 1) in sequence #86
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_85_8sngyk4r _
. Arc'
 

ORA-00279: Changing 4491242 (generated at 23:06:46) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_87_8snh0rpw _.
Arc
ORA-00280: Change 4491242 (for thread 1) in sequence #87
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_86_8snh06s7 _
. Arc'
 

ORA-00279: Changing 4491256 (generated at 23:07:04) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_000088_8sq3wv1s _.
Arc
ORA-00280: Change 4491256 (for thread 1) in sequence #88
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_20/o1_mf_1_87_8snh0rpw _
. Arc'
 

ORA-00279: Change 4518080 (generated 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 _.
Arc
ORA-00280: Change 4518080 (for thread 1) in sequence #89
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_000088_8sq3wv1s _
. Arc'
 

ORA-00279: Change 4538405 (generated at 05/21/2013 23:21:39) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_90_8sq4oryo _.
Arc
ORA-00280: Change 4538405 (for thread 1) in sequence #90
ORA-00278: This recovery no longer requires log files
'/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) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_91_8sq5026m _.
Arc
ORA-00280: Change 4558870 (for thread 1) in sequence #91
ORA-00278: This recovery no longer requires log files
'/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) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_92_8t36mf0h _.
Arc
ORA-00280: Change 4579214 (for thread 1) in sequence #92
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_21/o1_mf_1_91_8sq5026m _
. Arc'
 

ORA-00279: Change 4591978 (generated at 05/26/2013 13:15:24) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_93_8t3mjq4n _.
Arc
ORA-00280: Change 4591978 (for thread 1) in sequence #93
ORA-00278: This recovery no longer requires log files
'/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) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o1_mf_1_94_8t6ns7c9 _.
Arc
ORA-00280: changed 4614777 (for thread 1) in sequence #94
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_26/o1_mf_1_93_8t3mjq4n _
. Arc'
 

ORA-00279: Change 4652531 (generated at 05/27/2013 20:35:50) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o1_mf_000095_8t6wq99o _.
Arc
ORA-00280: Change 4652531 (for thread 1) in sequence #95
ORA-00278: This recovery no longer requires log files
'/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) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_29/o1_mf_1_96_8td3yzv5 _.
Arc
ORA-00280: Change 4672336 (for thread 1) in sequence #96
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_27/o1_mf_000095_8t6wq99o _
. Arc'
 

ORA-00279: Change 4704486 (generated at 05/29/2013 22:25:35) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_30/o1_mf_000097_8tgq14y8 _.
Arc
ORA-00280: Change 4704486 (for thread 1) in sequence #97
ORA-00278: This recovery no longer requires log files
'/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) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_000098_8tmqz7h3 _.
Arc
ORA-00280: Change 4733613 (for thread 1) in sequence #98
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_05_30/o1_mf_000097_8tgq14y8 _
. Arc'
 

ORA-00279: Change 4764093 (generated at 19:49:58 on 06/01/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_000099_8tmtn5ch _.
Arc
ORA-00280: Change 4764093 (for thread 1) in sequence #99
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_000098_8tmqz7h3 _
. Arc'
 

ORA-00279: Change 4786052 (generated at 20:35:17 on 06/01/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_0000100_8tn3ndbb _
. Arc
ORA-00280: Change 4786052 (for thread 1) in sequence #100
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_1_99_8tmtn5ch _
. Arc'
 

ORA-00279: Change 4817616 (generated at 23:08:59 on 06/01/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_101_8tyj6hqj _
. Arc
ORA-00280: Change 4817616 (for thread 1) in sequence #101
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_01/o1_mf_0000100_8tn3ndbb
_. Arc'
 

ORA-00279: Changing 4862007 (generated at 09:59:40 on 06/02/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_102_8tyj6hs8 _
. Arc
ORA-00280: Change 4862007 (for thread 1) in sequence #102
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_101_8tyj6hqj
_. Arc'
 

ORA-00279: Changing 4882809 (generated at 10:11:27 on 06/02/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_103_8tyj6sy0 _
. Arc
ORA-00280: Change 4882809 (for thread 1) in sequence #103
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_102_8tyj6hs8
_. Arc'
 

ORA-00279: Changing 4904327 (generated at 21:44:57 on 06/05/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_1__8tyl1p33 _
. Arc
ORA-00280: Change 4904327 (for thread 1) in sequence #104
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_1_103_8tyj6sy0
_. Arc'
 

ORA-00279: Changing 4915553 (generated at 22:16:21 on 06/05/2013) is required for thread 1
ORA-00289: Recommended:
/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_0000105 _ % u _. arc
ORA-00280: Change 4915553 (for thread 1) in sequence #105
ORA-00278: This recovery no longer requires log files
'/Opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_05/o1_mf_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 directory
Additional information: 3
 

SYS @ orcl #
View the file. This is the last archived log. Use the online log for recovery:
YS @ orcl # select * from v $ log;
 
GROUP # THREAD # SEQUENCE # bytes members archiv status FIRST_CHANGE # FIRST_TIME
-------------------------------------------------------------------------------------------------------------------
1 1 79 52428800 2 yes inactive 4346916-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 a full recovery.
 
SYS @ orcl # alter database open resetlogs;
 
The database has been changed.
 
SYS @ orcl #