Tuesday, August 9, 2011

"CATALOG and "CHANGE" command in RMAN

CATALOG:

Purpose:
- 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.

Examples:

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:

Purpose:
- 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.

Examples:

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;

Enjoy:-)