Oracle RMAN全备脚本（正式测试可行）

最新推荐文章于 2024-04-30 15:52:25 发布

夹心饼2024

最新推荐文章于 2024-04-30 15:52:25 发布

阅读量375

点赞数 1

分类专栏：数据库运维案例分享文章标签： oracle 数据库

本文链接：https://blog.csdn.net/bing_yuan/article/details/135983711

版权

数据库运维案例分享专栏收录该内容

66 篇文章 0 订阅

订阅专栏

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;
}