Oracle数据库丢失控制文件的恢复四则(六)

2014-11-24 17:02:16 · 作者: · 浏览: 6
g file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_95_8s2qovq1_.arc'

no longer needed for this recovery

ORA-00279: change 1294577 generated at05/13/2013 14:44:27 needed for thread 1

ORA-00289: suggestion : /u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_97_8s2qow0z_.arc

ORA-00280: change 1294577 for thread 1 isin sequence #97

ORA-00278: log file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_96_8s2qovsh_.arc'

no longer needed for this recovery

ORA-00279: change 1294580 generated at05/13/2013 14:44:27 needed for thread 1

ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_98_8s2qs51d_.arc

ORA-00280: change 1294580 for thread 1 isin sequence #98

ORA-00278: log file '/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_97_8s2qow0z_.arc'

no longer needed for this recovery

ORA-00279: change 1294620 generated at05/13/2013 14:46:13 needed for thread 1

ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_99_8s2qs62m_.arc

ORA-00280: change 1294620 for thread 1 isin sequence #99

ORA-00278: log file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_98_8s2qs51d_.arc'

no longer needed for this recovery

ORA-00279: change 1294623 generated at05/13/2013 14:46:14 needed for thread 1

ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_100_%u_.arc

ORA-00280: change 1294623 for thread 1 isin sequence #100

ORA-00278: log file'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_99_8s2qs62m_.arc'

no longer needed for this recovery

ORA-00308: cannot open archived log

'/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_100_%u_.arc'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file ordirectory

Additional information: 3

[oracle@master 2013_05_13]$ ls -ltr

total 31744

-rw-r----- 1 oracle oinstall 1024 May 13 14:44 o1_mf_1_94_8s2qoqjj_.arc

-rw-r----- 1 oracle oinstall 32441344 May13 14:44 o1_mf_1_93_8s2qoprf_.arc

-rw-r----- 1 oracle oinstall 1024 May 13 14:44 o1_mf_1_96_8s2qovsh_.arc

-rw-r----- 1 oracle oinstall 3072 May 13 14:44 o1_mf_1_95_8s2qovq1_.arc

-rw-r----- 1 oracle oinstall 1024 May 13 14:44 o1_mf_1_97_8s2qow0z_.arc

-rw-r----- 1 oracle oinstall 1536 May 13 14:46 o1_mf_1_98_8s2qs51d_.arc

-rw-r----- 1 oracle oinstall 1024 May 13 14:46 o1_mf_1_99_8s2qs62m_.arc

idle> select sequence# , group# , statusfrom v$log ;

SEQUENCE# GROUP# STATUS

---------- ---------- ----------------

91 1 INACTIVE

93 3 CURRENT

92 2 INACTIVE

idle> select group#,member fromv$logfile ;

GROUP# MEMBER

------------------------------------------------------------

2 /u02/oradat/bkt/redo02.log

1 /u02/oradat/bkt/redo01.log

3 /u02/oradat/bkt/redo03.log

sys@BKT> recover database using backupcontrolfile ;

ORA-00279: change 1294623 generated at05/13/2013 14:46:14 needed for thread 1

ORA-00289: suggestion :/u02/flash_recovery_area/BKT/archivelog/2013_05_13/o1_mf_1_100_%u_.arc

ORA-00280: change 1294623 for thread 1 isin sequence #100

Specify log: {=suggested |filename | AUTO | CANCEL}

/u02/oradat/bkt/redo03.log

ORA-00310: archived log contains sequence99; sequence 100 required

ORA-00334: archived log:'/u02/oradat/bkt/redo03.log'

sys@BKT> recover database using backupcontrolfile ;

ORA-0