Oracle Database Administration from Zero to Hero - Practice - Duplicating Databases and PDBs Using RMAN

This video tutorial covers various methods of database duplication, including active duplication and duplication from backup files with and without target connection. It provides detailed steps for setting up the environment, preparing the auxiliary database, and executing duplication processes using RMAN. The tutorial also discusses the duplication of PDBs online and concludes with a summary of the methods covered.

What is the first step in preparing the environment for database duplication?

• Create a directory named 'backup' in the staging folder.

• Take a snapshot of the database.

• Configure Oracle NET connectivity.

• Create a password file for the auxiliary database.

What is the purpose of creating an initialization parameter file for the auxiliary instance?

• To reload the listener configuration.

• To store backup files.

• To configure Oracle NET connectivity.

• To set parameters for the auxiliary database instance.

Why is it important to reload the listener configuration file?

• To take a snapshot of the database.

• To create a password file.

• To apply changes made to the listener.ora file.

• To start the auxiliary instance.

What is the role of the Oracle as ID variable in the duplication process?

• To configure Oracle NET connectivity.

• To specify the backup location.

• To ensure the correct environment is used for SQL*Plus.

• To set the database name.

Which tool is used to perform active database duplication?

• SQL*Plus

• RMAN

• Oracle Data Pump

• Oracle Enterprise Manager

What is the purpose of taking a snapshot of SRV one?

• To restore the database to a previous state if needed.

• To verify the duplication process.

• To configure Oracle NET connectivity.

• To create a backup of the auxiliary database.

What is the main difference when duplicating a database from backup files without connecting to the target database?

• The use of a different RMAN command.

• The need to specify the backup files location.

• The requirement to connect to a recovery catalog.

• The use of SQL*Plus instead of RMAN.

What is the significance of the 'close from active database' option in RMAN?

• It specifies the backup location.

• It is used to connect to the recovery catalog.

• It is omitted when duplicating from backup files.

• It is required for active database duplication.

What option is used to specify which PDBs to duplicate in a new instance?

• INCLUDE PDBS

• EXCLUDE PDBS

• PLUGGABLE DATABASE

• CONTAINER DATABASE

What should be done after verifying the duplication process is successful?

• Delete the backup files.

• Shut down SRV one and restore it from the snapshot.

• Create a new initialization parameter file.

• Take another snapshot.