ocp-182

QUESTION NO: 182
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: {=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: A,C

---

您正试图恢复数据库。在恢复过程中，您会收到以下错误：
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: {=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
A.还原已丢失的归档重做日志，再次尝试恢复。
C.恢复必需的在任何归档重做日志都不能利用的重做。如果可用，尝试申请一个联机重做日志

This error will appear if an archived redo log is not available. In this case you need sequence 11. First you
would try to restore archived redo log sequence 11. If log sequence 11 is not available as an archived
redo log, you might find that it is available in one of the online redo logs.

---