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

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

相似考题

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

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

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

更多“单选题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 b”相关问题

  • 第1题：

    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

    • A、The backup piece size will be limited to 300 MB
    • B、The RMAN uses multiplexing to perform backup
    • C、The operation is accomplished using the default channel available
    • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

    正确答案:A,C

  • 第2题：

    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

    • A、back up the control file to trace
    • B、bring database to the MOUNT state
    • C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
    • D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

    正确答案:C

  • 第3题：

    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

    • A、Perform Export before TSPITR and Import after TSPITR
    • B、Move objects to another schema that has the same tablespace assigned
    • C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
    • D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

    正确答案:A

  • 第4题：

    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

    • A、OPEN
    • B、MOUNT
    • C、NOMOUNT
    • D、CLOSE

    正确答案:B

  • 第5题：

    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.

    正确答案:A,E

  • 第6题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第7题：

    单选题
    You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    单选题
    Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
    A

     Perform Export before TSPITR and Import after TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


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

  • 第11题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

  • 第12题：

    单选题
    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）
    A

    OPEN

    B

    MOUNT

    C

    NOMOUNT

    D

    CLOSE


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

  • 第13题：

    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

    • A、flash back the corrupted blocks
    • B、use the DBMS_REPAIR package
    • C、use the RMAN TSPITR command
    • D、use the RMAN BLOCKRECOVER command
    • E、use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

    • A、 RECOVER FILE=1201 BLOCK=1968
    • B、 RECOVER CORRUPTION LIST
    • C、 RECOVER DATAFILE 1201 BLOCK 1968
    • D、 RECOVER BLOCK CORRUPTION LIST
    • E、 None of the above

    正确答案:B,C

  • 第18题：

    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.

    正确答案:A,F

  • 第19题：

    单选题
    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
    A

    flash back the corrupted blocks

    B

    use the DBMS_REPAIR package

    C

    use the RMAN TSPITR command

    D

    use the RMAN BLOCKRECOVER command

    E

    use the RESTORE DATABASE and RECOVER DATABASE commands

    F

    investigate the time at which the corruption occurred and perform a point­in­time recovery


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

  • 第20题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第21题：

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


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

  • 第22题：

    多选题
    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）
    A

    RECOVER FILE=1201 BLOCK=1968

    B

    RECOVER CORRUPTION LIST

    C

    RECOVER DATAFILE 1201 BLOCK 1968

    D

    RECOVER BLOCK CORRUPTION LIST

    E

    None of the above


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

  • 第23题：

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


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

  • 第24题：

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


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

相关内容