Rman Backup Restore

backup.rman
run {
crosscheck archivelog all;
allocate channel t1 type disk;
backup
full
tag hot_db_bk_full
filesperset 10
format '/u03/oradata/atom/rman/current/bk_%U.bkp'
(database);
sql 'alter system archive log current';
backup
filesperset 100
format '/u03/oradata/atom/rman/current/al_%U.bkp'
(archivelog all delete input);
backup
format '/u03/oradata/atom/rman/current/ct_%U.bkp'
(current controlfile);
sql "alter database backup controlfile to ''/u03/oradata/atom/rman/current/control01.bak'' reuse";
sql "create pfile=''/u03/oradata/atom/rman/current/initatom.bkp'' from spfile";
}
exit;

backup_level_0.rman
run {
sql 'alter system archive log current';
backup incremental level 0 database
filesperset 10 maxsetsize 20G
tag 'full_db';
backup archivelog all delete input
filesperset 16 maxsetsize 20G
tag 'full_al';
backup current controlfile reuse;
delete noprompt obsolete;
}

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License