RE: Dataguard 10g switchover question
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <cjnewman@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Nov 2009 07:33:41 -0500
Chris,
A graceful switch over, without the shutdown of the primary in
the first place, will be just fine. Part of the switchover from primary
to standby process is to ensure that the last log data is sent to all of
the existing standby's. Also, I don't recommend using arch since log
stream feeds only happen at log switches, when arch becomes active.
Instead I recommend LGWR with standby redo logs. That way instead of
network bursts when you switch archive logs, you get this steady stream
of data as LGWR becomes active whenever a commit is issued or the log
buffer fills up. It's a pretty constant stream, but takes up almost no
bandwidth.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Newman, Christopher
Sent: Monday, November 02, 2009 9:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Dataguard 10g switchover question
Sanity Check: We're have a primary and 3 physical standby's in ARCH
mode. We're going to activate one of the standby's as primary, ditch
the original primary and have the other 2 standby's feeding off the new
primary.
So here's a rough plan, let me know if you see anything horribly wrong:
1) On Primary: Shutdown immediate, startup, switch log, ALTER DATABASE
COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
2) On the standby we'll be turning on as the primary: Verify last log
applied then
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE OPEN;
Point OID to the new primary, enable the other standby locations on the
new primary, verify logs are being shipped and applied and backup the
new primary.
My main concern is making sure that the other two standby's are still
usable.
I believe if I use the 'activate standby' it will make the other
standby's unusable, but a graceful switchover should be OK.
Thanks- Chris
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
