本文主要是介绍Oracle RMAN全备脚本(正式测试可行),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
Oracle RMAN全备脚本 正式环境测试可行
请参考。
run{
allocate channel c1 type disk maxpiecesize=20G;
allocate channel c2 type disk maxpiecesize=20G;
allocate channel c3 type disk maxpiecesize=20G;
allocate channel c4 type disk maxpiecesize=20G;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
crosscheck copy;
delete noprompt expired copy;
report obsolete;
delete noprompt obsolete;
backup filesperset 6 tag 'full_incr_lv0' incremental level 0 database format 'F:\db_rman_backup\fulldb_lv0_%d_%U_%T';sql 'alter system archive log current';
backup filesperset 20 tag 'archbackup' archivelog all delete input format 'F:\db_rman_backup\arch_%d_%U_%T';
delete noprompt archivelog all completed before 'sysdate-1';release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
这篇关于Oracle RMAN全备脚本(正式测试可行)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!