Friday, December 19, 2008

Rman full backup examples

Full database backup plus archivelog backup (9i,10g)

backup as compressed backupset format '/[mount_point]/[backup_name]__%Y-%M-%D-%t_s%s_p%p' database plus archivelog not backed up delete all input;

Fast incremental startegy by having the last backup full recovered every day (10g and up)

backup incremental level 1 cumulative for recover of copy with tag 'FULL_DB'device type disk filesperset = 10 tag 'INC_DB' database;
recover copy of database with tag 'FULL_DB';
backup filesperset = 25 tag 'ARCH_BACKUP' archivelog all not backed up delete all input;

No comments:

Post a Comment