单项选择题
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
A. Create a backup of the database and recover all corrupted blocks found in the backup.
B. Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
C. Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.
D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.
E. Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
相关考题
-
单项选择题
Whatpurposewouldyouachievebyenablingtheblockchangetrackingfeature?()
A. Eliminate the necessity for backups.
B. Perform optimized image copy backups.
C. Perform optimized incremental backups.
D. Enable checkpoint (CKPT) to perform checkpointing at every block change.
E. Enable database writer (DBWn) to write changed blocks to data files faster. -
单项选择题
Adatafilebecomecorruptedinyourdatabaseduetobadsectorsonthedisk.Becauseofcorruption,youlostalltheimportanttablesinthatdatafile.Whichmethodwouldyouuseforrecovery?()
A. Flash back all the tables in the data file, one by one.
B. Restore the data file to a new location and perform a media recovery.
C. Flash back the database, there is no need to restore the data file.
D. Restore the data file from the most recent backup and flash the database. -
单项选择题
Exhibit: View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find information about table fragmentation?()
A. Memory Advisor
B. Segment Advisor
C. SLQ Tuning Advisor
D. SLQ Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
