Dataguard Configurations Simplified

Assumptions:

Primary IP – 10.0.0.1
Standby IP – 10.0.0.2

Changes/Additions to Primary PFILE (initPRIMARY.ora):

*.fal_server=STANDBY
*.fal_client=PRIMARY
*.log_archive_config='DG_CONFIG=(PRIMARY,STANDBY)'
*.log_archive_dest_1='location=/mnt/primarydb/10.2.0/dbs/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=PRIMARY'
*.log_archive_dest_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.LOG_ARCHIVE_MAX_PROCESSES=5 [optional]

Changes/Additions to Standby PFILE (initSTANDBY.ora):

*.fal_server=' PRIMARY'
*.fal_client='STANDBY'
*.log_archive_config='DG_CONFIG=( PRIMARY,STANDBY)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/mnt/standbydb/10.2.0/dbs/arch/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STANDBY'
*.LOG_ARCHIVE_DEST_2='SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY'

Changes/Additions to Primary Tnsnames.ora:

STANDBY=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.2)(PORT=1521))
            (CONNECT_DATA=
                (SID= PRIMARY)
            )
        )

Changes/Additions to Standby Tnsnames.ora:

PRIMARY=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.1)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME= PRIMARY)
                (INSTANCE_NAME= PRIMARY)
            )
        )

STANDBY=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.2)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME= PRIMARY)
                (INSTANCE_NAME= PRIMARY)
            )
        )