A. FILE B. PARFILE C. LOGFILE D. FEEDBACK
While working on the database, you receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery?()
A. Block Media Recovery must be used with RMAN. B. You must perform complete recovery of individual blocks. C. You must have a full RMAN backup, not an incremental backup. D. You must use the DBVERIFY utility before using the Block Media Recovery feature.
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()
A. The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view. B. The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view. C. The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view. D. The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.