Wednesday, April 21, 2010

RMAN Scripts

Global Script - Full Backup

create|rename global script full_backup

{
backup incremental level 0 tag 'FULL' database;
backup archivelog all delete all input tag 'Archive';
crosscheck backupset;
crosscheck copy;
delete noprompt obsolete;
}


Global Script - Incremental Backup

create global script inc_backup
{
backup incremental level 1 tag 'INC' database;
backup archivelog all delete all input tag 'Archive';
crosscheck backupset;
crosscheck copy;
delete noprompt obsolete;
}

Other Commands
run { execute global script full_backup; }
print global script full_backup;
list global script names;
delete script full_backup;


1 comment:

/* begin todea */ /* end todea */