GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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

stop ebo
start ebo

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center