自己的一个库,备份冗余设置的为2, 备份脚本如下
://wwwdba/tianxiadishi/article/3016
run{
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
allocate channel t1 type disk;
allocate channel t2 type disk;
allocate channel t3 type disk;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/test/jmgs_%T_control_%F_yhc01';
backup database format '/home/oracle/test/jmgs_%T_datafile_%d_%u_%t_%U_yhc';
sql'alter system switch logfile';
sql'alter system archive log current';
backup as compressed backupset archivelog all format '/home/oracle/test/jmgs_%T_archive_%d_%u_%t_%U_yhc';
report obsolete;
Delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
release channel t1;
release channel t2;
release channel t3;
}
这个脚本执行多次,://wwwdba/tianxiadishi/article/3016://wwwdba/tianxiadishi/article/3016
结果如下:
1.当数据文件、控制文件和参数文件,只要超过三份,就会把最早的那个备份集删除掉,
2.归档日志的备份集,通过以上脚本,冗余度超过2份以上,也不会删除,
请问大师,这个情况是正常的吗?
crosscheck backup;
delete noprompt expired backup;
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle
本文发布于:2024-03-09 11:32:52,感谢您对本站的认可!
本文链接:https://www.4u4v.net/it/1710231443135621.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |