CMS专题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）Aback up the control file to traceBbring database to the MOUNT stateCopen a connection to the
题目
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
相似问题和答案
第1题：
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）
- A、The database is in NOMOUNT state.
- B、The database is in ARCHIVELOG mode and the tablespace is online.
- C、The database is in ARCHIVELOG mode and the tablespace is offline.
- D、The database is in NOARCHIVELOG mode and the tablespace is online.
- E、The database is in NOARCHIVELOG mode and the tablespace is offline.
正确答案:B,C,E
第2题：
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
- A、 a list of all those files that have been deleted in the last two days
- B、 a list of all those files that have been recovered within the last two days
- C、 a list of all the expired backups and copies
- D、 a list of backups and copies that are outside the range covered by the current retention policy
正确答案:D
第3题：
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
第4题：
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
- A、 target database
- B、 auxiliary database
- C、 third-party database
- D、 recovery catalog database
正确答案:C
第5题：
You disabled the Flashback Database feature by using the following command： SQL> ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）
- A、 Flashback logs are not deleted.
- B、 Flashback logs are deleted automatically.
- C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
- D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
- E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
正确答案:B
第6题：
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
正确答案:C,D
第7题：
You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）
- A、 The backup would be marked as invalid.
- B、 The backup would be marked as obsolete.
- C、 The backup would be removed from the media.
- D、 The backup would be removed from the RMAN repository.
正确答案:B
第8题：
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
- A、 a list of files that require a backup within three days
- B、 a list of files that have not been backed up for three days
- C、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
- D、 a list of files for which a backup has already been performed and may need a backup after three days
正确答案:B
第9题：
You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）
- A、 rman TARGET / NOCATALOG
- B、 rman TARGET sys/password
- C、 rman TARGET sys/password AS SYSDBA
- D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
正确答案:B
第10题：
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
正确答案:C,F