星期五, 6月 16, 2017

Data Guard RMAN delete Archive log policy 注意事項

Data Guard RMAN delete Archive log policy 注意事項

For 11g版本以後 :
1.記得在Primary/ Standby db 加上 CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; 否則archive log 在standby db : ASM DISKGROUP RECO 會滿,
無法以rman delete expired archivelog all; 指令進行清除

2.記得在Primary/ Standby db 加上_log_deletion_policy='ALL';  第一點才會正常的運作work.
   SQL>  alter system set "_log_deletion_policy"='ALL' scope=spfile;

因為Primary DB / Standby DB都有角色切換的機會, 所以都要進行設定.

ref:
https://justiono.wordpress.com/2010/04/25/archivelog-files-deletion-policy-in-data-guard-environment/
http://jaychu649.blogspot.tw/2012/01/oracle-11g-active-dataguard-config_18.html
http://jaychu649.blogspot.tw/2011/11/archive-log.html

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...