Pages

Wednesday, February 6, 2013

Simple RMAN Backup script

run 
{
allocate channel d1 device type disk format '/mnt/bu/ora_%T_df%t_s%s_s%p';
backup incremental level 0 database include tag='Clean-VS-1-Ledger'current controlfile;
release channel d1;
}

Level 1 etc 
run 
{
  allocate channel d1 device type disk format '/mnt/bu/ora_%T_df%t_s%s_s%p';
  backup incremental level 1 database;
  release channel d1;
}

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE INCLUDE CURRENT CONTROLFILE;
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE INCLUDE CURRENT CONTROLFILE; 
 
CROSSCHECK BACKUP; # checks backup sets and copies on configured channels

DELETE BACKUPPIECE 101;  ##Based on reference number from LIST BACKUP;
DELETE CONTROLFILECOPY '/tmp/control01.ctl'; 
DELETE BACKUP;  ## DELETE ALL BACKUPS!!!
 
 
 
More complex structures here