多选题What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel 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 bloc

题目
多选题
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 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 that requires a recovery can remain online.

相似考题

1.Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

2.Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

3.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

4.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

更多“What are the two advantages of RMAN Block Media Recovery （BM”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）

    • A、 The backup would be marked as invalid.
    • B、 The backup would be marked as obsolete.
    • C、 The backup would be removed from the media.
    • D、 The backup would be removed from the RMAN repository.

    正确答案:B

  • 第3题：

    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 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 that requires a recovery can remain online.

    正确答案:A,F

  • 第4题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

    • A、You can use RMAN stored scripts
    • B、Recovery is faster if data is stored in catalog in addition to the control file
    • C、You can store backup information of all registered databases in one place
    • D、Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第5题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts
    • B、 Recovery is faster if data is stored in catalog in addition to the control file
    • C、 You can store backup information of all registered databases in one place
    • D、 Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第6题：

    多选题
    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）
    A

    You can use RMAN stored scripts.

    B

    Recovery is faster if data is stored in catalog in addition to the control file.

    C

    You can store backup Information of all registered databases in one place.

    D

    Database backups are automatically deleted when they are older than the specified time period.


    正确答案： A,C
    解析： 暂无解析

  • 第7题：

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


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）
    A

     After two days， the backup will be marked obsolete.

    B

     After two days， the backup will be deleted from the media.

    C

     If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.

    D

     If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    多选题
    What is the purpose of the RMAN recovery catalog？（）
    A

    Make backups faster

    B

    Store RMAN metadata

    C

    Store RMAN scripts

    D

    Provide the ability to do centralized backup reporting

    E

    Make recovery faster


    正确答案： C,A
    解析： 暂无解析

  • 第10题：

    多选题
    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 file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


    正确答案： B,C
    解析： 暂无解析

  • 第11题：

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


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed， what would be the status of this backup after seven days？（）
    A

    The backup would be marked as invalid.

    B

    The backup would be marked as obsolete.

    C

    The backup would be removed from the media.

    D

    The backup would be removed from the RMAN repository.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts.
    • B、 Recovery is faster if data is stored in catalog in addition to the control file.
    • C、 You can store backup Information of all registered databases in one place.
    • D、 Database backups are automatically deleted when they are older than the specified time period.

    正确答案:A,C

  • 第14题：

    Which of the following are correct about block media recovery？（）

    • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
    • B、 Logical corruptions are repairable by BMR
    • C、 Physical corruptions are repairable by BMR
    • D、 RMAN can use any backup for a BMR restore
    • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

    正确答案:A,C

  • 第15题：

    You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of the above command？（）

    • A、 After two days， the backup will be marked obsolete.
    • B、 After two days， the backup will be deleted from the media.
    • C、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media.
    • D、 If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.

    正确答案:D

  • 第16题：

    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 blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第17题：

    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？（）

    • 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.

    正确答案:A,E

  • 第18题：

    多选题
    Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)
    A

    You can use RMAN stored scripts

    B

    Recovery is faster if data is stored in catalog in addition to the control file

    C

    You can store backup information of all registered databases in one place

    D

    Database backups are automatically deleted when they are older than the specified time period


    正确答案： B,C
    解析： 暂无解析

  • 第19题：

    多选题
    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 instance

    B

    add new tempfiles to the temporary tablespaces after recovery

    C

    perform a media recovery and open the database with the RESETLOGS option

    D

    perform a media recovery and bring the database to NOARCHIVELOG mode


    正确答案： B,C
    解析： 暂无解析

  • 第20题：

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


    正确答案： D,E
    解析： 暂无解析

  • 第21题：

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


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    多选题
    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 file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


    正确答案： E,A
    解析： 暂无解析

  • 第23题：

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


    正确答案： C
    解析： 暂无解析

  • 第24题：

    多选题
    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)？（）
    A

    You can use RMAN stored scripts

    B

    Recovery is faster if data is stored in catalog in addition to the control file

    C

    You can store backup information of all registered databases in one place

    D

    Database backups are automatically deleted when they are older than the specified time period


    正确答案： A,D
    解析： 暂无解析

相关内容