-rw-r----- 1 oracle oinstall 259584 May 7 12:55 o1_mf_1_22_8rlq1j4j_.arc
-rw-r----- 1 oracle oinstall 1024 May 7 12:55 o1_mf_1_23_8rlq1tck_.arc
-rw-r----- 1 oracle oinstall 1024 May 7 13:29 o1_mf_1_23_8rls13lv_.arc
-rw-r----- 1 oracle oinstall 2048 May 7 12:56 o1_mf_1_24_8rlq3pxx_.arc
-rw-r----- 1 oracle oinstall 2048 May 7 13:29 o1_mf_1_24_8rls13lj_.arc
-rw-r----- 1 oracle oinstall 243712 May 7 13:29 o1_mf_1_25_8rls13pd_.arc
-rw-r----- 1 oracle oinstall 42203648May 8 07:01 o1_mf_1_26_8rnpoljr_.arc
-rw-r----- 1 oracle oinstall 10391552May 8 12:28 o1_mf_1_27_8ro9sxgq_.arc
-rw-r----- 1 oracle oinstall 10078720May 7 11:58 o1_mf_1_9_8rlmpf3o_.arc
idle> select * from v$logfile ;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------------------------------------- ---
1 STALE ONLINE /u02/oradat/bkt/redo01.log NO
3 STALE ONLINE /u02/oradat/bkt/redo03.log NO
2 ONLINE /u02/oradat/bkt/redo02.log NO
顺序3、1、2
sys@BKT> recover database using backupcontrolfile ;
ORA-00279: change 1266893 generated at05/09/2013 03:27:56 needed for thread 1
ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_08/o1_mf_1_28_%u_.arc
ORA-00280: change 1266893 for thread 1 isin sequence #28
Specify log: {
/u02/oradat/bkt/redo03.log
ORA-00310: archived log contains sequence27; sequence 28 required
ORA-00334: archived log:'/u02/oradat/bkt/redo03.log'
这里必须resetlogs
sys@BKT> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option fordatabase open
sys@BKT> alter database open resetlogs ;
sys@BKT> ALTER TABLESPACE TEMP ADDTEMPFILE '/u02/oradat/bkt/temp01.dbf' REUSE;
Tablespace altered.
RMAN> catalog db_recovery_file_dest ;
using target database control file insteadof recovery catalog
searching for all files in the recoveryarea