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

题目
多选题
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.Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

2.You can control instance recover performance by setting parameters to define targets for（）A、The size of the redo buffer in SGA. B、The instance that will perform recovery in Real Application Cluster database. C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

3.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、ONLINEB、REVERSEC、PARALLELD、COMPRESSE、NOLOGGINGF、COMPUTE STATISTICS

4.You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A、 Whole databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs

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

  • 第1题：

    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,D,E

  • 第2题：

    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

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

    You have a read/x7fonly tablespace on read/x7fonly 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/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

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

    正确答案: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题：

    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

  • 第7题：

    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

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

    单选题
    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
    A

     clear the redo log group

    B

     perform redo log file import

    C

     perform an incomplete recovery

    D

     perform a redo log recovery using Recovery Manager （RMAN）

    E

     shut down the database and open the database in the NOARCHIVELOG mode


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

  • 第10题：

    单选题
    You work as a database administrator for Certkiller .com. 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. 


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

  • 第11题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

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


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

  • 第13题：

    Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）

    • A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
    • B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
    • C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
    • D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.

    正确答案:C

  • 第14题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第15题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

    • A、Open the database in NORMAL mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第16题：

    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

  • 第17题：

    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

    • A、 clear the redo log group
    • B、 perform redo log file import
    • C、 perform an incomplete recovery
    • D、 perform a redo log recovery using Recovery Manager （RMAN）
    • E、 shut down the database and open the database in the NOARCHIVELOG mode

    正确答案:A

  • 第18题：

    You work as a database administrator for Certkiller .com. 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. 

    正确答案:B

  • 第19题：

    单选题
    You can control instance recover performance by setting parameters to define targets for（）
    A

    The size of the redo buffer in SGA. 

    B

    The instance that will perform recovery in Real Application Cluster database. 

    C

    The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 

    D

    The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.


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

  • 第20题：

    多选题
    Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）
    A

    The database opens normally.

    B

    The database prompts for a database recovery.

    C

    The database writer writes to a trace file， indicating that the temporary file is not found.

    D

    The database gets mounted and throws an error indicating that the temporary file requires recovery.


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

  • 第21题：

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


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

  • 第22题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

  • 第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
    解析： 暂无解析

相关内容