delete noprompt archivelog

技术文章 8个月前 完美者
1,455 0

标签:check   ted   备份   date   日志   archive   complete   sync   sbt   

删除7天前已经备份的归档日志

delete noprompt archivelog all completed before ‘sysdate - 7‘;

备份没有备份的归档日志

backup archivelog all not backed up;

不备份已经备份1次的归档日志

backup archivelog all not backed up 1 times;  

归档日志备份过两次的, 第三次是不进行备份的

backup archivelog all not backed up 2 times; 

crosscheck archivelog all;
delete noprompt archivelog all completed before ‘sysdate - 1/2‘ BACKED UP 1 TIMES TO DEVICE TYPE SBT;

delete noprompt archivelog all backed up 1 times to DEVICE TYPE SBT completed before ‘sysdate-1/2‘;

backup archivelog all not backed up 1 times;  ---- # 不备份上次已经备份的归档
crosscheck archivelog all;
resync catalog;

delete noprompt archivelog

标签:check   ted   备份   date   日志   archive   complete   sync   sbt   

原文地址:https://www.cnblogs.com/lipeng20004/p/13897580.html

版权声明:完美者 发表于 2020-10-30 12:13:54。
转载请注明:delete noprompt archivelog | 完美导航

暂无评论

暂无评论...