Creating Oracle GoldenGate Parameter Files for the Standby Database on Oracle 11g

This section describes the parameter files that you need to create and modify manually for the standby database on Oracle 11g.

• mgr.prm

• configure_standby.oby

• trgtrep.prm

Creating configure_standby.oby

Example to create a file named configure_standby.oby, on Oracle 11g:

-- ################################################################################⇒
##########
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
-- Edit and modify REMOTE Host and Trail 
-- ################################################################################⇒
##########
dblogin, userid OGGUSER, password OGGUSER
add checkpointtable OGGUSER.GGSCHKPT
add replicat trgtrep, exttrail ./dirdat/pr, checkpointtable OGGUSER.GGSCHKPT

Creating trgtrep.prm

Example to create a file named trgtrep.prm, on Oracle 11g:

-- ################################################################################⇒
##########
-- Edit and modify NLS_LANG parameter as required (eg. language.territory.character⇒
)
-- Edit and modify ORACLE_HOME
-- Edit and modify Primary ORACLE_SID
-- Edit and modify 'OGGUSER' to Oracle GoldenGate Admin Userid and PW
-- Edit and modify 'SYSADM' to PSACCESSID
-- ################################################################################⇒
##########
REPLICAT trgtrep

SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
SETENV (ORACLE_HOME = "/products/oracle/11.2.0.2.0-64bit")
SETENV (ORACLE_SID = "sg112064")

USERID OGGUSER PASSWORD OGGUSER

ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/trgtrep.dsc, APPEND

DISCARDROLLOVER ON SUNDAY
ALLOWNOOPUPDATES

MAP SYSADM.*, TARGET SYSADM.*;