多选题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？（）AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control 

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

相似考题

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

2.Which four actions are possible during an Online Data file Move operation?()A. Creating and dropping tables in the data file being movedB. Performing file shrink of the data file being movedC. Querying tables in the data file being movedD. Performing Block Media Recovery for a data block in the data file being movedE. Flashing back the databaseF. Executing DML statements on objects stored in the data file being moved

3.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

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? ()(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

更多“You are performing a block media recovery on the tools01.dbf”相关问题

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

    正确答案:C

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

    正确答案:C,D

  • 第4题：

    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

  • 第5题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第6题：

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

    • A、 user managed complete recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第7题：

    You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

    • A、You are backing up to tape and your tape device performs its own compression.
    • B、You are making image copies, and you have not enabled tablespace compression.
    • C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
    • D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
    • E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

    正确答案:C,D,E

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
    A

     user managed complete recovery

    B

     user managed incomplete recovery

    C

     RMAN-based complete recovery

    D

     RMAN-based incomplete recovery


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

  • 第10题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第13题：

    Which four actions are possible during an Online Data file Move operation?（）

    • A、Creating and dropping tables in the data file being moved
    • B、Performing file shrink of the data file being moved
    • C、Querying tables in the data file being moved
    • D、Performing Block Media Recovery for a data block in the data file being moved
    • E、Flashing back the database
    • F、Executing DML statements on objects stored in the data file being moved

    正确答案:A,C,D,F

  • 第14题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）

    • A、ONLINE
    • B、REVERSE
    • C、PARALLEL
    • D、COMPRESS
    • E、NOLOGGING
    • F、COMPUTE STATISTICS

    正确答案:C,E

  • 第15题：

    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

    • A、 take data files from the read-only tablespace offline before performing a recovery
    • B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
    • C、 drop the read-only tablespace and re-create the tablespace after recovery
    • D、 perform a recovery； status of the tablespace in control file will be changed automatically

    正确答案:A

  • 第16题：

    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

  • 第17题：

    Which of the following would you use to enable automatic media recovery for a database？（）

    • A、SET AUTORECOVERY ON
    • B、SET RECOVERY ON
    • C、SET AUTO ON
    • D、You cannot enable automatic media recovery.

    正确答案:A

  • 第18题：

    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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Which of the following would you use to enable automatic media recovery for a database？（）
    A

    SET AUTORECOVERY ON

    B

    SET RECOVERY ON

    C

    SET AUTO ON

    D

    You cannot enable automatic media recovery.


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

  • 第21题：

    单选题
    You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）
    A

     take data files from the read-only tablespace offline before performing a recovery

    B

     recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    C

     drop the read-only tablespace and re-create the tablespace after recovery

    D

     perform a recovery； status of the tablespace in control file will be changed automatically


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

  • 第22题：

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


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

  • 第23题：

    多选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容