tailieunhanh - Recovery Catalog Creation and Maintenance

Overview The recovery catalog is a schema that is created in a separate database. It contains the RMAN metadata obtained from the target database control file. RMAN propagates information about the database structure, archived redo logs, backup sets, and datafile copies into the recovery catalog from the control file of the target database. You should use a catalog when you have multiple target databases to manage. RMAN stores, uses, and maintains the information in the recovery catalog. The recovery catalog is maintained by RMAN when you do the following: 1. Register the target database in the catalog. 2. Resynchronize the catalog with the control file. | Recovery Catalog Creation and Maintenance Objectives After completing this lesson, you should be able to do the following: Describe the contents of the recovery catalog List the RMAN features which require the recovery catalog Create the recovery catalog Maintain the recovery catalog by using RMAN commands Use RMAN to register, resynchronize, and reset a database Objectives Query the recovery catalog to generate reports and lists Create, store, and run scripts Describe methods for backing up and recovering the recovery catalog Overview Target database Stored scripts Reporting REPORT LIST Backup Restore/Recovery Recovery Manager (RMAN) Catalog Maintenance Register Resynchronize Reset Change/Delete/Catalog Backup /Restore/Recover Enterprise Manager Control file Catalog database Overview The recovery catalog is a schema that is created in a separate database. It contains the RMAN metadata obtained from the target database control file. RMAN propagates information about the database structure, archived redo logs, backup sets, and datafile copies into the recovery catalog from the control file of the target database. You should use a catalog when you have multiple target databases to manage. RMAN stores, uses, and maintains the information in the recovery catalog. The recovery catalog is maintained by RMAN when you do the following: 1. Register the target database in the catalog. 2. Resynchronize the catalog with the control file of the target database. 3. Reset the database to a previous incarnation. 4. Change information about the backups or files. 5. Perform a backup, restore, or recovery operation. You can use the REPORT and LIST commands to obtain information from the recovery catalog. You can store scripts in the recovery catalog. Recovery Catalog Contents The recovery catalog is an optional repository containing information on: Datafile and archived redo log file backup sets and backup pieces Datafile copies Archived redo log files The physical structure of the . | Recovery Catalog Creation and Maintenance Objectives After completing this lesson, you should be able to do the following: Describe the contents of the recovery catalog List the RMAN features which require the recovery catalog Create the recovery catalog Maintain the recovery catalog by using RMAN commands Use RMAN to register, resynchronize, and reset a database Objectives Query the recovery catalog to generate reports and lists Create, store, and run scripts Describe methods for backing up and recovering the recovery catalog Overview Target database Stored scripts Reporting REPORT LIST Backup Restore/Recovery Recovery Manager (RMAN) Catalog Maintenance Register Resynchronize Reset Change/Delete/Catalog Backup /Restore/Recover Enterprise Manager Control file Catalog database Overview The recovery catalog is a schema that is created in a separate database. It contains the RMAN metadata obtained from the target database control file. RMAN propagates information about the database .