逻辑备应用主库归档后删除命令

miss_puff

逻辑备库应用完主库传输过来的归档后，正常情况下应该删除应用了的归档，在给客户维护的时候发现归档并没有删除，将磁盘空间全部占完，导致逻辑备库无法启用日志应用了。
解决办法：开启自动删除参数。

SQL> execute DBMS_LOGSTDBY.PURGE_SESSION

PL/SQL procedure successfully completed.

SQL> SELECT * FROM DBA_LOGMNR_PURGED_LOG;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/archivelog/1_89_996681245.dbf
/u01/app/archivelog/1_90_996681245.dbf
/u01/app/archivelog/1_91_996681245.dbf
/u01/app/archivelog/1_92_996681245.dbf
/u01/app/archivelog/1_93_996681245.dbf

SQL> EXECUTE DBMS_LOGSTDBY.APPLY_SET('LOG_AUTO_DELETE','TRUE');

PL/SQL procedure successfully completed.