rman备份脚本
rman target / < run {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
allocate channel d1 type disk;
backup incremental level 0 database format '/oracle/rman_backup/level0_%d_%s_%p_%t_%T.bak'
tag='level 0' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '/oracle/rman_backup/archivelog_%d_%s_%p_%t_%T.bak' delete all input;
release channel d1;
}
crosscheck backup;
delete noprompt expired backup;
EOF
rman target / < run {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;
allocate channel d1 type disk;
backup incremental level 0 database format '/oracle/rman_backup/level0_%d_%s_%p_%t_%T.bak'
tag='level 0' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '/oracle/rman_backup/archivelog_%d_%s_%p_%t_%T.bak' delete all input;
release channel d1;
}
crosscheck backup;
delete noprompt expired backup;
EOF
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10569970/viewspace-1726249/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10569970/viewspace-1726249/