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.
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.
相关考题：
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
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 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.
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.
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.
Which of the following is the MOST important step in any disaster recovery plan？（）A、 Appropriate use of backup media and offsite storageB、 The disaster recovery testing process过程C、 Classifying systems according to operational impactD、 Use appropriate fire suppressant systems
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
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 recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
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 pointintime 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.
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、 ONLINEB、 REVERSEC、 PARALLELD、 COMPRESSE、 NOLOGGINGF、 COMPUTE STATISTICS
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-basedB、Recovery using a backup control fileC、Time-basedD、Change-based
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.
单选题Which of the following statements is NOT true about RMAN？（）AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations， with only full database backups.
单选题Which of the following would you use to enable automatic media recovery for a database？（）ASET AUTORECOVERY ONBSET RECOVERY ONCSET AUTO ONDYou cannot enable automatic media recovery.
多选题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？（）Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
多选题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（）ASpeeds up subsequent media recover actions.BWrites any uncorrupted block to disk during the test recovery.CCan be invoked by adding the TEST option to any RECOVER command.DAllows the Administrator to determine how many blocks are affected by corruption.EMarks blocks as corrupt in memory， allowing the test recover to proceed to completion.
多选题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？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
单选题Which of the following is the MOST important step in any disaster recovery plan？（）A Appropriate use of backup media and offsite storageB The disaster recovery testing process过程C Classifying systems according to operational impactD Use appropriate fire suppressant systems
多选题What are the two advantages of RMAN Block Media Recovery （BMR） over file-level 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 block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
多选题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？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
多选题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？（）AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery
多选题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？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
单选题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.
单选题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？（）APMON coordinates media recovery.BSMON coordinates instance recovery.CPMON coordinates instance recovery.DUndo Advisor would roll back all uncommitted transactions.ESQL*PLUS reports an error with the message asking you to perform instance recovery.
单选题You have issued the following command： RMANCONFIGURE 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.