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;
}
Tuesday, October 6, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment