Tag: 1Z0-043

QUESTION 1
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, https://www.pass4itsure.com/1z0-043.html while querying the user1.employees table, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: ‘/u01/app/oracle/oradata/orcl/example01.dbf’
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file, and all the archived logs are accessible. Which option would you choose?
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery

Correct Answer: D
QUESTION 2
A database is running in ARCHIVELOG mode. It has two online redo log groups and each group has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of a redo log file and the LGWR terminates causing the instance to crash.

 » Read more about: Latest Release Oracle 1Z0-043 Study Guide Download For Groundbreaking Results  »