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:-)

5 comments:

Zheng junxai5 said...

zhengjx20160428
louis vuitton
michael kors outlet clearance
michael kors handbags
coach factory outlet online
coach factory outlet
coach factory outlet
ray ban sunglasses
replica rolex watches
michael kors handbags
north face jackets
ray ban outlet
michael kors handbags
ralph lauren outlet
true religion sale
michael kors outlet
burberry sale
coach outlet online
cheap rolex watches
toms wedges
ralph lauren outlet
louis vuitton
cheap oakleys
ray ban sunglasses outlet
instyler
nfl jerseys
coach outlet
michael kors outlet online sale
michael kors outlet online
marc jacobs outlet
toms shoes
michael kors outlet online sale
red bottom shoes
ralph lauren outlet
ray ban outlet
toms outlet
ugg boots
cheap oakley sunglasses
jordan 11
louis vuitton outlet
adidas superstar shoes

Blogger said...

Trying to find the Best Dating Website? Join to find your perfect match.

raybanoutlet001 said...

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

jeje said...

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

Pansys Silvaz said...

qzz0704
jordan shoes
longchamp handbags
michael kors handbags
canada goose outlet
cleveland cavaliers jersey
michael kors outlet
hawks jerseys
ugg outlet
michael kors
rockets jerseys