Integration between Oracle Golden Gate and RMAN
edited Aug 12, 2013 4:53AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
Hello experts.
I trying about a week to configure RMAN and Golden Gate for non delete the archived logs ( from log_archive_dest) needed to extract gg garantee the recoverability.
I'm using Oracle Database 11.2.0.2 and Oracle Golden Gate 11.2 on Oracle Solaris Sparc 64 bits without Grid Infra (without ASM).
I tried:
./ggsci
dblogin userid, password
register extract ebo logretention
edit param ebo (and added LOGRETENTION ENABLED)
EXTRACT EBO
setenv (ORACLE_SID="dwtbr01")
USERID ggsa, PASSWORD AACAAAAAAAAAAAEAXHQENIZIGFYIACYE, ENCRYPTKEY default
EXTTRAIL ./dirdat/bo
DISCARDFILE ./dirdsc/ebo.dsc, APPEND
GETTRUNCATES
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
TRANLOGOPTIONS EXCLUDEUSER ggsa, LOGRETENTION ENABLED
setenv (ORACLE_SID="dwtbr01")
USERID ggsa, PASSWORD AACAAAAAAAAAAAEAXHQENIZIGFYIACYE, ENCRYPTKEY default
EXTTRAIL ./dirdat/bo
DISCARDFILE ./dirdsc/ebo.dsc, APPEND
GETTRUNCATES
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
TRANLOGOPTIONS EXCLUDEUSER ggsa, LOGRETENTION ENABLED
stop ebo
start ebo
0