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:-)
2 comments:
nike air max 90
ray ban sunglasses
coach outlet online
ugg boots
ugg boots
coach outlet store online
michael kors outlet
nike air huarache
chargers jerseys
michael kors handbags
jordan shoes
michael kors outlet
golden goose
under armour curry 3
adidas superstar UK
jordan shoes
converse outlet store
adidas ultra boost
pandora charms
curry 3
Post a Comment