Wednesday, September 21, 2011

Making Compressed Backups

If you want to save storage then the best bet is to perform compressed backups.

so here's how you do it.


RMAN> backup as compressed backupset database plus archivelog;


This command will backup the datafiles and archived redo logs as compressed backup set. The best time to take compressed backup is during off peak hours as the it has an overhead on CPU.

Also, there is not need to uncompress it as RMAN does it automatically during the recovery..

No comments:

Post a Comment