DataGuard Setup
Primary
DB_NAME=PROD
DB_UNIQUE_NAME=PROD
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,PROD02)'
CONTROL_FILES='/u01/app/oracle/oradata/PROD/control01.ctl','/u01/app/oracle/oradata/PROD/control02.ctl','/u01/app/oracle/oradata/PROD/control03.ctl'
LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/archivelog/PROD VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD'
LOG_ARCHIVE_DEST_2='SERVICE=PROD02 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD02'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
LOG_ARCHIVE_MAX_PROCESSES=10

FAL_SERVER=PROD02
FAL_CLIENT=PROD
DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD02','/u01/app/oracle/oradata/PROD'
LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD02','/u01/app/oracle/oradata/PROD'
STANDBY_FILE_MANAGEMENT=AUTO
Standby
DB_NAME=PROD
DB_UNIQUE_NAME=PROD02
LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD,PROD02)'
CONTROL_FILES='/u01/app/oracle/oradata/PROD02/control01.ctl','/u01/app/oracle/oradata/PROD02/control02.ctl','/u01/app/oracle/oradata/PROD02/control03.ctl'
DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/PROD02'
LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PROD','/u01/app/oracle/oradata/PROD02'
LOG_ARCHIVE_FORMAT='%t_%s_%r.arc'
LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/archivelog/PROD02 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD02'
LOG_ARCHIVE_DEST_2='SERVICE=PROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=PROD
FAL_CLIENT=PROD02

*.audit_file_dest='/u01/app/oracle/admin/PROD02/adump'
*.background_dump_dest='/u01/app/oracle/admin/PROD02/bdump'
*.core_dump_dest='/u01/app/oracle/admin/PROD02/cdump'
*.user_dump_dest='/u01/app/oracle/admin/PROD02/udump'
PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = odd.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD)
    )
  )

PROD_SHARED =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = odd.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = PROD_XPT)
    )
  )

PROD01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = odd.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD01)
    )
  )

PROD02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = odd.localdomain)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PROD02)
    )
  )
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License