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 :
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 .
0