Oracle Database Administration from Zero to Hero - Using RMAN Recovery Catalog (Part 1 of 3)

The video tutorial explains the RMAN recovery catalogue database, comparing it with control files as RMAN repositories. It highlights the advantages of using a recovery catalogue, such as storing RMAN repositories for multiple databases and creating custom reports. The tutorial provides a step-by-step guide to creating a recovery catalogue, including configuring the database, creating the catalogue owner, and managing target databases. It also covers registering and unregistering target databases in the recovery catalogue.

What is one of the main differences between using a control file and a recovery catalogue as an RMAN repository?

• Recovery catalogues can store RMAN repository for multiple databases.

• Control files can store RMAN scripts.

• Recovery catalogues have a time limit for storing RMAN repository.

• Control files can store RMAN repository for multiple databases.

What is a key advantage of using a recovery catalogue over control files?

• It limits the number of target databases.

• It simplifies database management.

• It allows for the use of the 'keep forever' clause.

• It reduces the need for backups.

What is the first step in creating a recovery catalogue?

• Create the Recovery Catalogue owner.

• Configure the database to store the recovery catalogue.

• Create a table space for the Recovery catalogue.

• Grant the role Recovery CATALOG OWNER.

Which command is used to create the recovery catalog database objects?

• CREATE CATALOG

• CONNECT CATALOG

• REGISTER DATABASE

• UNREGISTER DATABASE

What must be done after creating the Recovery catalog to manage target databases?

• Unregister the target databases.

• Register the target databases in the Recovery catalog.

• Create a new control file.

• Synchronize the recovery catalog with the control file.

What happens when you unregister a database from the recovery catalogue?

• All RMAN repository information is lost.

• The RMAN repository information is retained.

• The database is permanently deleted.

• The database is automatically re-registered.

What is the purpose of the 'register database' command in RMAN?

• To connect to the target database.

• To unregister a target database.

• To register a target database in the recovery catalog.

• To create a new recovery catalogue.