1z0-067: Upgrade Oracle9i10g11g OCA OR OCP to Oracle Database 12c OCP Rman Practice Questions

For which three pieces of information can you use the RMAN list command?

Select 3 answers.

• AA. stored scripts in the recovery catalog
• BB. available archived redo log files
• CC. backup sets and image copies that are obsolete
• DD. backups of tablespaces
• EE. backups that are marked obsolete according to the current retention policy

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time. Examine the steps to recover this table from an RMAN backup: 1. Determine which backup contains the table that needs to be recovered. 2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified. 3. Import the Data Pump export dump file into the auxiliary instance. 4. Create a Data Pump export dump file that contains the recovered table on a target database. Identify the required steps in the correct order.

• AA. 1, 4, 3
• BB. 1, 2
• CC. 1, 4, 3, 2
• DD. 1, 2, 4

You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

• AA. MAXSETSIZE TO 2;
• BB. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• CC. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• DD. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1.Create media families for data files and archived redo log files. 2.Configure database backup storage selectors or RMAN media management parameters. 3.Create an OSB user preauthorized for RMAN operations. 4. Configure RMAN Access to the OSB SBT. 5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. Identify the steps in the correct order.

• AA. 1, 4, 3, 2, 5
• BB. 1, 3, 4, 5, 2
• CC. 4, 3, 1, 2, 5
• DD. 4, 3, 5, 1, 2