Thursday 15 July 2010

RMAN JOBS


Friday JOB ::

backup 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;

report obsolete;

delete noprompt obsolete device type disk;

crosscheck archivelog all;

delete noprompt expired archivelog all;

restore database validate check logical;

release channel;

============== OR ==========================================

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

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

crosscheck backup;

delete noprompt expired backup;

report obsolete;

delete noprompt obsolete device type disk;

restore database validate check logical;


Mon –Thu Job::


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

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

restore database validate check logical;

No comments: