You work as a database administrator at certkiller.com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, 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?

Question

You work as a database administrator at certkiller.com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, 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?

Accepted Answer

D. use the RMAN BLOCKRECOVER command

Answer

A. flash back the corrupted blocks

Answer

B. use the DBMS_REPAIR package

Answer

C. use the RMAN TSPITR command

Answer

E. use the RESTORE DATABASEand RECOVER DATABASE commands

Answer

F. investigate the time at which the corruption occurred and perform a point-in-time recovery

You work as a database administrator at certkiller.com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the…

Question

Options

How the community answered

Community Discussion