You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()

  • A、 V$BACKUP_CORRUPTION
  • B、 V$COPY_CORRUPTION
  • C、 V$DATABASE_BLOCK_CORRUPTION
  • D、 RC_BACKUP_CORRUPTION

相关考题:

Which of the following is not an advantage of block media recovery (BMR)?()A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C

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 issued the following command: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;  What will be the result of issuing this command?()A、 The block change tracking feature is enabled, and the information about the system change number is written in the change tracking file.B、 The block change tracking feature is enabled, and the information about the log sequence number is written in the change tracking file.C、 The block change tracking feature is enabled, and the information about the blocks that are changed since the last backup is written in the change tracking file.D、 The block change tracking feature is enabled, and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

According to your backup strategy, you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true?()A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.  Which two statements are true about differential incremental backups()A、The backup performed on Sundays contains all the blocks that have ever been used in the database.B、The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. C、The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup,and every other working day contains all the blocks that have changed since the level 1 backup.

You are managing an Oracle Database 11g database with this backup strategy:  - Every Sunday night, level 0 backup is performed.  - On Monday night and subsequent days, level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true()A、The backup contains all the used blocks.B、The backup contains all the used and unused blocks.C、The backup contains blocks that have changed since the last level 0 backup.D、The backup contains blocks that have changed since the last level 1 backup taken last week.

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()A、V$COPY_CORRUPTB、V$COPY_CORRUPTIONC、V$BACKUP_CORRUPTD、V$BACKUP_CORRUPTION

You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()A、 You must ensure that the SALES database is mounted or open.B、 You must restore a backup control file to perform a block media recovery.C、 You must take the tools01.dbf data file offline before you start a block media recovery.D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、 You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.

You execute the following RMAN commands 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 backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the viewE、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

You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.

Which two statements are true about Block Media Recovery (BMR)?()A、 BMR increases the Mean Time To Recover (MTTR).B、 BMR can only be implemented using Recovery Manager (RMAN).C、 The blocks that need to be recovered are accessible during BMR.D、 BMR cannot be performed using cumulative incremental backups.E、 The datafile must be restored if most of the blocks in the datafile are corrupt.

You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()A、The backup performed on Sundays contains all the blocks that have ever been used in the database.B、The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.C、The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup

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.

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.

Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i?()A、Rebuild the index using the online option. B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list

单选题Which of the following is not an advantage of block media recovery (BMR)?()A Reduced MTTR.B Datafiles remain offline while corrupt blocks are repaired.C Datafiles remain online while corrupt blocks are repaired.D A and C

单选题You issued the following command: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;  What will be the result of issuing this command?()A The block change tracking feature is enabled, and the information about the system change number is written in the change tracking file.B The block change tracking feature is enabled, and the information about the log sequence number is written in the change tracking file.C The block change tracking feature is enabled, and the information about the blocks that are changed since the last backup is written in the change tracking file.D The block change tracking feature is enabled, and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

单选题You are managing an Oracle Database 11g database with this backup strategy:  - Every Sunday night, level 0 backup is performed.  - On Monday night and subsequent days, level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true()AThe backup contains all the used blocks.BThe backup contains all the used and unused blocks.CThe backup contains blocks that have changed since the last level 0 backup.DThe backup contains blocks that have changed since the last level 1 backup taken last week.

单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A redo log filesB password fileC control fileD change tracking file

单选题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.

单选题According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.

单选题You work as a database administrator for Certkiller .com. According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()AThe backup is similar to image copy.BThe backup contains all used data blocks.CThe backup contains only unused data blocks.DThe backup contains all data blocks changed since the last incremental level 1 backup.

单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list

单选题You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A V$BACKUP_CORRUPTIONB V$COPY_CORRUPTIONC V$DATABASE_BLOCK_CORRUPTIOND RC_BACKUP_CORRUPTION

多选题You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario?()AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks; point-in-time recovery of  individual data blocks is not supported.