Friday 14 May 2010

EM RMAN BACKUP SCRIPTS

FRIDAY FULL INCREMENTAL 0 BACKUP :

--set encryption on for all tablespaces algorithm 'aes256' identified by '%password';

--backup device type disk tag '%tag' database;

backup incremental level 0 cumulative device type disk tag '%TAG' database;

backup device type disk tag '%TAG' archivelog all not backed up delete all input;;

allocate channel for maintenance device type disk;

crosscheck backup;

delete noprompt expired backup;

delete noprompt obsolete device type disk;

crosscheck archivelog all;

delete noprompt expired archivelog all;

release channel;

DAILY Full INCREMENTAL 1 (dIff) BACKUP;

backup incremental level 1 device type disk tag '%TAG' database;

backup device type disk tag '%TAG' archivelog all not backed up;

No comments: