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

第1题：

第2题：

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）

• A、using only the RMAN SWITCH command to set the new location for the data file
• B、placing the database in the MOUNT state for the restore and recovery operations.
• C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
• D、configuring two channels: one for the restore operation and the other for the recovery operation

第3题：

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

第5题：

To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）

• A、Multiple change tracking files can be created for a database.
• B、The change tracking file must be created after the first level 0 backup.
• C、RMAN does not support backup and recovery of the change tracking file.
• D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

第6题：

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.

第7题：

You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you issued this command: SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’; To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which three statements are true?（）

• A、Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B、The change tracking file must always be backed up when you perform a full database backup.
• C、Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D、More than one database block may be read by an incremental backup for a change made to a single block.
• E、The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

第8题：

第9题：

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

第10题：

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.