Oracle
1Z0-034 · Question #18
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…
The correct answer is D. use the RMAN BLCCKRECOVER command. See the full explanation below for the reasoning.
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
How the community answered
(41 responses)- A12% (5)
- B2% (1)
- C7% (3)
- D76% (31)
- E2% (1)
Community Discussion
No community discussion yet for this question.