What RMAN command

第1题：

What is the purpose of the catalog command？（）  

• A、 To review RMAN control file and recovery catalog metadata and ensure that its correct
• B、 To delete RMAN backup-related metadata from the recovery catalog
• C、 To create metadata in the control file and the recovery catalog related to backup set pieces 
• D、 To create a report that lists database backups
• E、 To rebuild the recovery catalog

第2题：

What RMAN command must you use before you can back up a database using the recovery catalog？（）

• A、 create catalog
• B、 install database
• C、 catalog database
• D、 merge Catalog with database
• E、 register database

第3题：

第4题：

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

第5题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第6题：

David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order？（）   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN. 

• A、  a， b， c， d， e， f， g
• B、 b， c， d， g， f， e， a
• C、 g， f， a， b， c， e， d
• D、 c， a， d， b， f， e， g
• E、 g， f， a， b， e， c， d

第7题：

What information does the report schema command not provide？（） 

• A、 Size of the datafiles
• B、 Size of the tempfiles
• C、 Date of last backup for datafiles and tempfiles
• D、 Filenames for each datafile
• E、 Checkpoint SCN associated with the last RMAN backup

第8题：

第9题：

When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（）   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command. 

• A、 a， b， c， d， e， f
• B、 c， d， a， b， f
• C、 d， c， a， b， f
• D、  d， b， d， c， e
• E、  d， c， a， b， e

第10题：

Consider this RMAN command：   RMAN> CONFIGURE RETENTION POLICY CLEAR；   What is the effect of this command？（）

• A、Backups will never expire.
• B、It removes any retention policy.
• C、The DELETE OBSOLETE command will fail with an error.
• D、It sets the retention policy to the default of REDUNDANCY 1.