如何定期自动删除归档日志

发布网友发布时间：2022-05-04 00:45

共2个回答

懂视网时间：2022-05-04 05:06

rman中如何制定删除某段时间的归档日志 eg： RMAN sql alter session set nls_date_format=YYYY-MM-DD; sql statement: alter session set nls_date_format=YYYY-MM-DD RMAN delete archivelog from time 2012-12-01 until time 2013-02-28; released channe

rman中如何制定删除某段时间的归档日志

eg：
RMAN> sql 'alter session set nls_date_format="YYYY-MM-DD"';

sql statement: alter session set nls_date_format="YYYY-MM-DD"

RMAN> delete archivelog from time "2012-12-01" until time "2013-02-28";

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
specification does not match any archive log in the recovery catalog

小结：
sql 'alter session set nls_date_format="YYYY-MM-DD"';
delete archivelog from time "2012-12-01" until time "2013-02-28";

热心网友时间：2022-05-04 02:14

开归档的目的即为备份，满足你备份策略的archive log都是可以删除的。在backup archivelog时加上delete input，备份后归档日志自然就删除了。所以你可以加大一下备份归档日志的频次。

手动的删除也没问题，不过当rman备份时会检测到日志的缺失，按如下的操作即可：

RMAN> crosscheck archivelog all;
RMAN> delete obsolete;