Oracle
1Z0-034 · Question #18
1Z0-034 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Question
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.emoloyees table, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf* You need to recover from this while ensuring that: 1. The data file remains online. 2. Mean Time To Recover (MTTR) is minimized as much as possible You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?
Options
- Aflash back the corrupted blocks
- Buse the DBMS_REPAIR package
- Cuse RMAN tablespace point in time recovery
- Duse the RMAN BLCCKRECOVER command
- Eperform a table point in time recovery with datapump export and import
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.