Oracle Database Administration from Zero to Hero - Practice - Using RMAN in Oracle Multitenant Databases (Part 1 of 2)

This video tutorial covers performing backup and recovery operations in the ACDB database using RMAN. It includes creating backup files for CDB and PDBs, enabling local PDB administrators to manage backups, and implementing recovery scenarios. The tutorial demonstrates using RMAN commands to enable archive log mode, take full backups, and manage backup sets. It also explores the differences between backup sets of the entire database and the root container, and how to enable a local admin user to perform backups and restores.

What is the primary tool used for creating backup files in the ACDB database?

• Oracle Enterprise Manager

• RMAN

• Data Pump

• SQL*Plus

Which command is used to enable archive log mode in a CDB database?

• ENABLE ARCHIVELOG MODE

• START ARCHIVELOG

• ALTER DATABASE ARCHIVELOG

• SET ARCHIVELOG ON

What does the command 'list backup set of database root' display?

• Backup sets of all PDBs

• Backup sets of the root container only

• Archived redo log files

• All backup sets

What is the purpose of taking a whole PDB backup?

• To backup a specific PDB

• To backup the entire CDB

• To backup archived redo log files

• To backup only the root container

What is the role of a local admin user in PDB management?

• To manage the entire CDB

• To backup and restore its specific PDB

• To manage all PDBs

• To delete archived redo log files

Why can't a local admin user delete archived redo log files?

• They do not have access to RMAN

• They are not connected to the root container

• They have SYS backup privilege on PDB only

• They lack SYSDBA privileges

What is the significance of the DB ID in PDB management?

• It is the same for all containers

• It is unique for each PDB and root container

• It determines backup frequency

• It is used to connect to the CDB