You are trying to recover your database. During the recovery process, you receive the
following error:
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1
ORA-00289: suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /
o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file ‘/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /
o1_mf_1_10_4bj6wnqm_.arc’ no longer needed for this recovery Specify log:
{<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log ‘/oracle01/flash_recovery_area/ORCL/
archivelog/2008_08_17 /o1_mf_1_11_%u_.arc’
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory
Additional information: 3
How do you respond to this error? (Choose two.)
A.
Restore the archived redo log that is missing and attempt recovery again.
B.
Recovery is complete and you can open the database.
C.
Recovery needs redo that is not available in any archived redo log. Attempt to apply an
online redo log if available.
D.
Recover the entire database and apply all archived redo logs again.
E.
Recovery is not possible because an archived redo log has been lost.
Answer is A and C because …
ORA-00308 means that you are missing the archived redo log file, which maybe due to
1. you are missing the archive redo log (Answer A above)
or
2. Attempt to apply an online redo log, (Answer C above) if we choose an incorrect online redo log file then then try another one until it works by
Specify log: {=suggested | filename | AUTO | CANCEL}
D:\ORADATA\AHEADPRD\REDO01.LOG
Log applied.
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;