重庆思庄Oracle、Redhat认证学习论坛
标题:
逻辑备应用主库归档后删除命令
[打印本页]
作者:
miss_puff
时间:
2019-3-6 17:10
标题:
逻辑备应用主库归档后删除命令
逻辑备库应用完主库传输过来的归档后,正常情况下应该删除应用了的归档,在给客户维护的时候发现归档并没有删除,将磁盘空间全部占完,导致逻辑备库无法启用日志应用了。
解决办法:开启自动删除参数。
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.
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)
Powered by Discuz! X3.2