Database - RAC/Scalability (MOSC)

MOSC Banner

standby redo logs for RAC

edited Aug 11, 2019 12:21PM in Database - RAC/Scalability (MOSC) 2 commentsAnswered ✓

Oracle Database 12.1.0.2

Solaris SPARC 14

source: rac 2 nodes

target: rac 2 nodes

Hello Team,

I would like to know how to create standby redo logs on the target database for Golden Gate downstream capture.

source:

select * from v$log;

standby redo logs creation (for standalone script)

ALTER DATABASE ADD STANDBY LOGFILE GROUP 9 ('+RECO','+DATA') size 2147483648;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 10 ('+RECO','+DATA') size 2147483648;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 ('+RECO','+DATA') size 2147483648;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 ('+RECO','+DATA') size 2147483648;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 13 ('+RECO','+DATA') size 2147483648;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 14 ('+RECO','+DATA') size 2147483648;

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