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 af

第1题：

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

第2题：

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

第3题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  In what sequence would you use this process to perform the recovery？（）

• A、7， 2， 3， 1， 4， 6， 5
• B、7， 1， 3， 2， 6， 5， 4
• C、2， 1， 7， 6， 3， 5， 4
• D、2， 7， 3， 5， 1， 6， 4

第4题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

• A、 By using the trace file.
• B、 By using the alert log file.
• C、 By using the database ID
• D、 By using the server parameter file.
• E、 By using the V$CONTROLFILE view.
• F、 By using the autobackup format configuration setting.

第5题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  1.RESTORE CONTROLFILE；  2.RESTORE DATABASE；  3.ALTER DATABASE MOUNT；  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS；  6.RECOVER DATABASE；  7.STARTUP NOMOUNT；  In what sequence would you use this process to perform the recovery？（）

• A、 2， 7， 3， 5， 1， 6， 4
• B、 2， 1， 7， 6， 3， 5， 4
• C、 7， 1， 3， 2， 6， 5， 4
• D、 7， 2， 3， 1， 4， 6， 5

第6题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第7题：

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

第8题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

• A、a tablespace is taken offline
• B、the database instance is restarted
• C、a new data file is added to an existing tablespace
• D、a successful backup is recorded in the RMAN repository
• E、the RMAN connection is disconnected from the target database

第9题：

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

• A、cannot be used in RMAN
• B、by starting up the database again
• C、by using the CATALOG command of RMAN
• D、by using the RECOVER CATALOG command in RMAN
• E、by re-creating the target control file to rebuild the RMAN repository

第10题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.