Oracle OCP IZ0-053 Q582(Recover Archivedlog)
582.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 1ORA-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: AC
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-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: AC
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2061217/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP IZ0-053 Q193(rman recover)Oracle
- Oracle OCP IZ0-053 Q543Oracle
- Oracle OCP IZ0-053 Q2Oracle
- Oracle OCP IZ0-053 Q282Oracle
- Oracle OCP IZ0-053 Q705Oracle
- Oracle OCP IZ0-053 Q476Oracle
- Oracle OCP IZ0-053 Q452Oracle
- Oracle OCP IZ0-053 Q14(Hot Patch)Oracle
- Oracle OCP IZ0-053 Q682(Rman Crosscheck)OracleROS
- Oracle OCP IZ0-053 Q88(Rman Channel)Oracle
- Oracle OCP IZ0-053 Q432(Segment Shrink)Oracle
- Oracle OCP IZ0-053 Q651(Scheduler Job)Oracle
- Oracle OCP IZ0-053 Q694(Transportable Tablespace)Oracle
- Oracle OCP IZ0-053(Recovery Missing Active Redo Log)Oracle
- Oracle OCP IZ0-053 Q448(Job Coordinator)Oracle
- Oracle OCP IZ0-053 Q695(Rman catalog)Oracle
- Oracle OCP IZ0-053 Q257(workload capture)OracleAPT
- Oracle OCP IZ0-053 Q594(RMAN Image Copy)Oracle
- Oracle OCP IZ0-053 710(Recyclebin&Tablespace Quato)Oracle
- Oracle OCP IZ0-053 Q425( transportable tablespace set)Oracle
- Oracle OCP IZ0-053 Q157(Data Encryption)Oracle
- Oracle OCP IZ0-053 Q530(ASM Shutdown Normal)OracleASMORM
- Oracle OCP IZ0-053 Q620(Rman Catalog)Oracle
- Oracle OCP IZ0-053 Q14(? ?NLS_LENGTH_SEMANTICS)Oracle
- Oracle OCP IZ0-053 Q251(Rman Import Catalog)OracleImport
- Oracle OCP IZ0-053 Q166(Flashback Data Archive)OracleHive
- Oracle OCP IZ0-053 Q219(DB_SECUREFILE)Oracle
- Oracle OCP IZ0-053 Q692(Workload Capture and Replay)OracleAPT
- Oracle OCP IZ0-053 Q216(Job Chain Process)OracleAI
- Oracle OCP IZ0-053 Q64(Rman controlfile)Oracle
- Oracle OCP IZ0-053 Q319(Rman Retention)Oracle
- Oracle OCP IZ0-053 Q240(ASM DISK_REPAIR_TIME)OracleASMAI
- Oracle OCP IZ0-053 Q478(SQL Plan Baselines)OracleSQL
- Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)Oracle
- Oracle OCP IZ0-053 Q312(RMAN Catalog)Oracle
- Oracle OCP IZ0-053 Q411(Workload Capture of RAC)OracleAPT
- Oracle OCP IZ0-053 Q365(tablespace point-in-time recovery)Oracle
- Oracle OCP IZ0-053 Q400(資料塊校驗)Oracle