Oracle 11g DataGuard migration (ASM to non ASM)

http://oracleinstance.blogspot.tw/2010/08/duplicatecloneconvert-asm-file-system.html

重點1. Standby DB listener.ora (須改為靜態註冊)

SID_LIST_LISTENER_RAC1 =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
    (SID_DESC =
    (GLOBAL_DBNAME = dupdb)
    (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
    (SID_NAME = dupdb)
   )
 )

重點2. Standby DB parameter

db_file_name_convert='+DATA/DEMODB/DATAFILE/','/u01/app/oracle/oradata/dupdb/'
log_file_name_convert='+DATA/DEMODB/ONLINELOG/','/u01/app/oracle/oradata/dupdb/'

重點3. ODG broker 的設定如下:
Ref:
http://gavinsoorma.com/2010/03/11g-data-guard-broker-dgmgrl-configuration-quick-steps/

重點4. 記得在standby db 加上

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
或
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;


重點5. Primary DB 須設定參數:
LOG_ARCHIVE_MAX_PROCESSES=30

重點6. 11g 可開啟archive log 壓縮
LOG_ARCHIVE_DEST_3='SERVICE=denver SYNC COMPRESSION=ENABLE'
其他參數:
http://docs.oracle.com/cd/E11882_01/server.112/e25608/log_arch_dest_param.htm#BABBFBDI

重點7. 在DataGuard環境中，為了減少故障時資料損失，我們可以設置ARCHIVE_LAG_TARGET參數，強制進行日誌切換。(這在10g OCM也曾經考過)

http://www.eygle.com/archives/2006/11/archive_lag_target_force_logswitch.html

重點8. 設定 自動刪除Logical Standby archive log :   LOG_AUTO_DEL_RETENTION_TARGET 
Ref:
http://www.databasejournal.com/features/oracle/article.php/3929131/Top-10-New-Features-for-Oracle-11g-Data-Guard---Part-One.htm

To change the setting to something like three days you would use the following syntax:

DBMS_LOGSTDBY.APPLY_SET('LOG_AUTO_DEL_RETENTION_TARGET','4320');