Tuesday, 5 August 2014

Full Backup with RMAN(Recovery Manager)


run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database tag wednesday_29_08_12 plus archivelog;
CROSSCHECK BACKUP;
CROSSCHECK archivelog all;
delete noprompt obsolete ;
delete noprompt EXPIRED BACKUP;
delete noprompt expired archivelog all;
sql ‘alter system archive log current’;
backup filesperset = 5 as COMPRESSED BACKUPSET archivelog all not backed up tag wednesday_29_08_12;
release channel c1;
release channel c2;
}

Photo: Full Backup with RMAN (Recovery Manager).

run {
 allocate channel c1 type disk;
 allocate channel c2 type disk;
 backup database tag wednesday_29_08_12 plus archivelog;
 CROSSCHECK BACKUP;
 CROSSCHECK archivelog all;
 delete noprompt obsolete ;
 delete noprompt EXPIRED BACKUP;
 delete noprompt expired archivelog all;
 sql ‘alter system archive log current’;
 backup filesperset = 5 as COMPRESSED BACKUPSET archivelog all not backed up tag wednesday_29_08_12;
 release channel c1;
 release channel c2;
 }