Tuesday, October 6, 2009

Simple RMAN Script

create or replace script backup_arch_all
 {
backup archivelog all delete all input filesperset 5;
}


create or replace script level2backup
 {
backup as compressed backupset
incremental level 2
tag incremBackup
filesperset 5
(database);
change archivelog all validate;
sql 'alter system switch logfile';
execute script backup_arch_all;
crosscheck backup;
}

create or replace script level0backup
  {
crosscheck backup;
crosscheck backup of archivelog all;
crosscheck backup of controlfile;
delete expired backup;
crosscheck backup of archivelog all;
delete expired backup of archivelog all;
crosscheck backup of controlfile;
delete expired backup of controlfile;
delete force noprompt obsolete ;
backup as compressed backupset
incremental level 0
tag fullBackup
filesperset 5
(database include current controlfile);
change archivelog all validate;
sql 'alter system switch logfile';
execute script backup_arch_all;
crosscheck backup;
}

No comments:

Post a Comment