How do you respond to this error?

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.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *