Oracle Database Administration from Zero to Hero - Using RMAN in Oracle Multitenant Databases

This lecture covers backup and recovery procedures in Oracle multi-tenant databases using RMAN. It explains the differences between CDB and non-CDB environments, and provides detailed instructions on performing complete and incomplete recoveries. The lecture also discusses advanced recovery techniques, point-in-time recovery, and the use of RMAN commands for managing backups and recovery processes.

What is the primary difference between backup and recovery in a CDB and a non-CDB?

• Non-CDBs cannot be backed up.

• There is no significant difference.

• CDBs have additional data files.

• CDBs require different RMAN commands.

When taking an RMAN backup of a PDB, what is one of the options available?

• Connect to the PDB and use the backup database command.

• Use the backup PDB command.

• Use the backup all command.

• Connect to the root and use the backup all command.

What is a restriction when connected to a PDB as a target?

• You cannot delete data files.

• You cannot backup data files.

• You cannot perform a full backup.

• You cannot restore archived redo log files.

How do you perform a complete recovery of a CDB?

• Use the restore and recover commands with the root container name.

• Use the restore CDB command.

• Use the restore and recover commands without specifying the root container.

• Use the recover all command.

What is the recommended action when restoring the root container?

• Restore only the necessary data files.

• Restore all PDBs as well.

• Restore only the root container.

• Restore using the recover root command.

What happens during a point-in-time recovery (PITR) of a PDB?

• All PDBs are affected.

• The entire CDB is restored.

• Only the target PDB is affected.

• No changes are made to the PDB.

What is created during a PITR of a PDB?

• A backup of the entire CDB.

• A temporary auxiliary tablespace.

• A snapshot of the PDB.

• A new PDB.

Which RMAN command is used to obtain information about backups?

• SHOW BACKUPS

• DISPLAY BACKUPS

• LIST BACKUPS

• VIEW BACKUPS

What privilege is required to use RMAN list and report commands in a CDB?

• SYSBACKUP

• COMMON SYSBACKUP

• SYSDBA

• COMMON SYSDBA

What should be done if the FRA is not set up during PITR?

• Skip the recovery process.

• Specify the location of the auxiliary tablespace.

• Use default settings.

• Restart the database.