- Add metadata about a user-managed datafile copy, control file copy, archived log or backup piece to the RMAN repository.
- Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy.
Cataloging an Archived Redo Log:
CATALOG ARCHIVELOG 'd:\oradata\archive1_30.dbf';
Cataloging a File Copy as an Incremental Backup:
CATALOG DATAFILECOPY 'd:\users.bak' level 0;
Cataloging Multiple Copies in a Directory:
The following example catalogs a directory full of archived logs that were copied into the d:\tmp\arch_logs directory with an operating system utility:
CATALOG START WITH 'd:\tmp\arch_logs';
Cataloging File in the Flash Recovery Area:
CATALOG RECOVERY AREA NOPROMPT;
Cataloging Backup Pieces:
CATALOG BACKUPPIECE 'd:\oradata\bkp.dmp';
- Change the status of backups, copies, and archived logs in the repository to AVAILABLE or UNAVAILABLE.
- The CHANGE command can alter the repository status of usable backups and copies from prior incarnations.
Updating Backups to Status UNAVAILABLE:
CHANGE BACKUPSET 100 UNAVAILABLE;
Changing the Retention Status of a Backupset:
In this example,we change the status of the backup for a long-term:
CHANGE BACKUP TAG 'consistent_db_bkup' KEEP FOREVER NOLOGS;