多选题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？（）AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks； point-in-time recovery of individual data blocks is not supported.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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 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
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.
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.
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
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_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION
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 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 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
Which of the following are correct about block media recovery？（）A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONB、 Logical corruptions are repairable by BMRC、 Physical corruptions are repairable by BMRD、 RMAN can use any backup for a BMR restoreE、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore
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
Which of the following would you use to enable automatic media recovery for a database？（）A、SET AUTORECOVERY ONB、SET RECOVERY ONC、SET AUTO OND、You cannot enable automatic media recovery.
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 recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery
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.
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.
单选题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.
单选题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 recoveryB user managed incomplete recoveryC RMAN-based complete recoveryD RMAN-based incomplete recovery
单选题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
多选题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
单选题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_CORRUPTIONB V$COPY_CORRUPTIONC V$DATABASE_BLOCK_CORRUPTIOND RC_BACKUP_CORRUPTION
多选题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 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.