You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()
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 data file in a different location while resto ing the file. Which option must you consider for this task?()
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
Using the LIST command in Recovery Manager (RMAN),which two pieces of information in the RMAN repository can be listed?()
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order?() 1. Grant the appropriate privileges (CONNECT and RESOURCE) and roles (RECOVERY_CATALOG_OWNER) to the user responsible for performing backup and recover operations. 2. Register the target database in the catalog. 3. Create the catalog using the RMAN command line interpreter. 4. Create a user and schema which will own the recovery catalog. 5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog. 6. Connect to the target database using SYSDBA privileges.
To perform a database point-in-time recovery using RMAN, after database restoration, you must ensure that the database is in which of the following states?()
In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()
You execute the following RMAN commands in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()