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.
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 need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation? ()(Choose two.) A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two) A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
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
Which of the following statements is NOT true about RMAN？（）A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations， with only full database backups.
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.
Which two statements regarding compressed backups in Recovery Manager （RMAN） are true？（）A、 Backup compression is disabled by default.B、 Backup compression can be used with both backup sets and image copies.C、 Backup compression cannot be enabled using the CONFIGURE command.D、 Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.E、 Backup compression applies to only backup sets.F、 Backup compression applies to only image copies.
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery
Which of the following are correct about block media recovery？（）A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONB、 Logical corruptions are repairable by BMRC、 Physical corruptions are repairable by BMRD、 RMAN can use any backup for a BMR restoreE、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore
What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel recovery？（）A、BMR lowers the mean time to recover （MTTR）.B、BMR supports pointintime recovery of individual data blocks.C、BMR enables you to use incremental backups for block recovery.D、BMR enables recovery even when the database is not mounted or open.E、BMR enables you to use proxy backups to perform block media recovery.F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)A、Backup compression should be enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）A、Backup compression should be enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager
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.
Using the LIST command in Recovery Manager （RMAN）， which two pieces of information from the RMAN repository can be listed？ （）A、backups that can be deletedB、stored scripts in the recovery catalogC、backup sets and image copies that are obsoleteD、only the most recent backup sets or image copiesE、backups that do not have the AVAILABLE status in RMAN repository
What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）A、 BMR lowers the mean time to recover （MTTR）.B、 BMR supports point-in-time recovery of individual data blocks.C、 BMR enables you to use incremental backups for block recovery.D、 BMR enables recovery even when the database is not mounted or open.E、 BMR enables you to use proxy backups to perform block media recovery.F、 BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
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.
多选题You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery
单选题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
多选题Which two statements are true about Block Media Recovery （BMR）？（）ABMR increases the Mean Time To Recover （MTTR）.BBMR can only be implemented using Recovery Manager （RMAN）.CThe blocks that need to be recovered are accessible during BMR.DBMR cannot be performed using cumulative incremental backups.EThe datafile must be restored if most of the blocks in the datafile are corrupt.
单选题Which of the following statements is NOT true about RMAN？（）AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations， with only full database backups.
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
多选题Which two statements regarding compressed backups in Recovery Manager （RMAN） are true？（）ABackup compression is disabled by default.BBackup compression can be used with both backup sets and image copies.CBackup compression cannot be enabled using the CONFIGURE command.DBackup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.EBackup compression applies to only backup sets.FBackup compression applies to only image copies.
单选题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？（）ARebuild the index using the online option. BTake 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. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake 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.
多选题Which of the following are correct about block media recovery？（）APhysical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONBLogical corruptions are repairable by BMRCPhysical corruptions are repairable by BMRDRMAN can use any backup for a BMR restoreEARCHIVELOG mode is not required if you have both a full and incremental backup for restore
多选题What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）ABMR lowers the mean time to recover （MTTR）.BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
多选题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.