GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Changing log_archive_dest_1 and log_archive_dest_2 in a streams environment .

edited Jul 25, 2010 9:41PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hello ,
We are working on Solaris 10 and Oracle 10.2.0.4 .

We have a capture, propagate and apply process for about 100 tables .

Because  of change in the hard Disks i have to set new value for the LOCATION of archived redo logs and i also have to change location for redo logs .

I plan to :
  • stop all streams processes
  • stop DB
  • OS guys do their work
  • mount db and rename redo log files ( after copy at os level )
  • modify log_archive_dest parameters in spfile
  • open DB
  • start all streams processes .
I think it is OK for capture process to change archive log dest in this way .  Isn'it  ?????

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