Lesson 9

This module discussed the last few maintenance activities that you should know before you start backing up your database. Now that you have completed this module, you should be able to:

1. Add information to the recovery catalog
2. Re-create your recovery catalog
3. Use the report command
4. Use the list command
5. Create and use stored scripts
6. Use the run command
7. Use the Oracle-supplied data dictionary views . We have purposely not spent much time on the complete syntax for stored scripts. This will be covered in greater detail as you write scripts for your backup operations. The report and list commands will become your primary method to monitor your recovery catalog. You will learn the complete syntax for stored scripts as you begin to write scripts for your backup operations. The best source for information on stored scripts is in the Oracle8 documentation and samples from your peers.

1. `REPORT` and `LIST` commands: The `REPORT` and `LIST` commands are the primary methods to monitor a recovery catalog during database backup in Oracle 12c.These commands provide detailed information about the backup process, including the status of each backup piece, the elapsed time, and any errors that occur.
2. REPORT command: The `REPORT` command provides a high-level overview of the backup process. It displays information about the database being backed up, the backup type, the backup destination, and the status of each backup piece.
   

   RMAN> REPORT;
   

3. LIST command: The `LIST` command provides more detailed information about the backup process. It displays information about each backup piece, including the backup piece name, the backup type, the backup start time, the backup end time, the backup size, and the backup status.
   

   RMAN> LIST backup;
   

In addition to the `REPORT` and `LIST` commands, you can also use the following commands to monitor a recovery catalog during database backup:

`QUERY`: This command allows you to query the recovery catalog for specific information about backups.

RMAN> QUERY backup WHERE status='COMPLETED';

`DISPLAY`: This command displays detailed information about a specific backup piece.

RMAN> DISPLAY backup OF 'archivelog_1';

By using these commands, you can effectively monitor the backup process and ensure that your backups are completed successfully.

If the recovery catalog database is lost or damaged, and recovery of the recovery catalog database through the normal Oracle recovery mechanisms is not possible, then you must re-create the catalog. You have two options for partially re-creating the contents of the old catalog:

1. Issue catalog commands to re-catalog archived redo logs, backup control files, and datafile copies.
2. Use the resync catalog from controlfilecopy command to extract information from a backup control file and rebuild the recovery catalog from it.

You can re-create information about backup sets only by using the resync catalog from controlfilecopy command, because the catalog command does not support re-cataloging of backup pieces or backup sets. RMAN does not verify that the files being re-cataloged still exist, so the resynchronization may add records for files that no longer exist. Remove such records by issuing

change ... crosscheck

or crosscheck backup commands.

Click the Quiz link below to test your knowledge of the topics presented in this module.
Oracle Sripts - Quiz
In the next module, you will learn about making backup sets and image copies with RMAN.