Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corr

题目

Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）

  • A、Speeds up subsequent media recover actions.
  • B、Writes any uncorrupted block to disk during the test recovery.
  • C、Can be invoked by adding the TEST option to any RECOVER command.
  • D、Allows the Administrator to determine how many blocks are affected by corruption.
  • E、Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.
相似考题

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 must be done to properly conduct testing of the data backup portion of a disaster recovery plan？（）A、 Perform an integrity test of backup media.B、 Verify data on backup media can be read.C、 Verify that backups have occurred and were successful via the logs.D、 Restore backed up data to a test server.

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

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

更多“Media recovery can&en”相关问题

  • 第1题：

    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

    • A、On startup， SMON coordinates instance recovery.
    • B、On startup， CKPT coordinates instance recovery.
    • C、On startup， use RMAN to perform instance recovery.
    • D、Uncommitted changes will be rolled back after the database is opened.
    • E、On startup， perform media recovery and then instance recovery.
    • F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

    正确答案:A,D

  • 第2题：

    每个系统的Creat Recovery media可以创建几套Product Recovery恢复光盘（）

    • A、4
    • B、2
    • C、1
    • D、3

    正确答案:C

  • 第3题：

    Which of the following is the MOST important step in any disaster recovery plan？（）

    • A、 Appropriate use of backup media and offsite storage
    • B、 The disaster recovery testing process过程
    • C、 Classifying systems according to operational impact
    • D、 Use appropriate fire suppressant systems

    正确答案:B

  • 第4题：

    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

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

  • 第7题：

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

  • 第8题：

    多选题
    Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）
    A

    Speeds up subsequent media recover actions.

    B

    Writes any uncorrupted block to disk during the test recovery.

    C

    Can be invoked by adding the TEST option to any RECOVER command.

    D

    Allows the Administrator to determine how many blocks are affected by corruption.

    E

    Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.


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

  • 第9题：

    单选题
    Which of the following is the MOST important step in any disaster recovery plan？（）
    A

     Appropriate use of backup media and offsite storage

    B

     The disaster recovery testing process过程

    C

     Classifying systems according to operational impact

    D

     Use appropriate fire suppressant systems


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

  • 第10题：

    多选题
    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
    A

    On startup， SMON coordinates instance recovery.

    B

    On startup， CKPT coordinates instance recovery.

    C

    On startup， use RMAN to perform instance recovery.

    D

    Uncommitted changes will be rolled back after the database is opened.

    E

    On startup， perform media recovery and then instance recovery.

    F

    On startup， all the files will be synchronized and you get both committed and uncommitted data.


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

  • 第11题：

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

  • 第12题：

    单选题
    You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
    A

    PMON coordinates media recovery.

    B

    SMON coordinates instance recovery.

    C

    PMON coordinates instance recovery.

    D

    Undo Advisor would roll back all uncommitted transactions.

    E

    SQL*PLUS reports an error with the message asking you to perform instance recovery.


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

  • 第13题：

    用户可以通过Creat Recovery media创建出几套恢复光盘（）

    • A、1
    • B、2
    • C、3
    • D、无数次

    正确答案:A

  • 第14题：

    每个系统的Creat Recovery media可以创建几套挽救介质（）

    • A、1
    • B、2
    • C、3
    • D、多次

    正确答案:D

  • 第15题：

    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

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

    As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）

    • A、Cancel-based
    • B、Recovery using a backup control file
    • C、Time-based
    • D、Change-based

    正确答案:A

  • 第18题：

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

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

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

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

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

  • 第24题：

    单选题
    You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）
    A

     The backup metadata will be maintained in the control file for 100 days.

    B

     The backup metadata will be maintained in the recovery catalog for 100 days.

    C

     The backup metadata will be maintained in the flash recovery area for 100 days.

    D

     After 100 days， the backup sets and image copies will be deleted from the media.


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

相关内容