RE: 9i physical standby startup
- From: <Jay.Miller@xxxxxxxxxxxxxxxx>
- To: <cjpengel.dbalert@xxxxxxxxx>, <Roger.Xu@xxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 16:28:03 -0400
My apologies, I was thinking only in the context of the question (which
seemed to be concerned about accidentally messing up the standby through
issuing a startup command).
I'd guess SE would support a graceful failover using the pre-Dataguard
method of copying the logfiles and recreating the controlfile from a
backup to trace. But I don't have an installation to test that either.
Thanks,
Jay Miller
Sr. Oracle DBA
x68355
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carel-Jan Engel
Sent: Thursday, September 21, 2006 4:19 PM
To: Roger Xu
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i physical standby startup
9.2 will issue an error.
10g will automagically mount it in read only mode
There is more than activate. You can also use the 'alter database commit
to switchover to standby' on the primary, restart (nomount), 'alter
database mount standby database', followed by 'alter database commit to
switchover to primary' on the standby, with again a restart.
This is a graceful switchover (switch roles between primary and standby)
but I'm not sure whether SE supports this. No SE standby at hand to
test. EE does.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Thu, 2006-09-21 at 14:59 -0500, Roger Xu wrote:
9.2.0.7.0
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Carel-Jan Engel
Sent: Thursday, September 21, 2006 2:53 PM
To: Roger Xu
Cc: Oracle-L@Freelists. Org (E-mail)
Subject: Re: 9i physical standby startup
Version?
On Thu, 2006-09-21 at 14:45 -0500, Roger Xu wrote:
Hi List,
To start up a physical standby database, you use
"startup nomount" and "alter database mount standby database;" ....
What if someone just types in "startup" and hits Enter?
Does the standby need to be recreate from zero?
Thanks,
Roger
This e-mail is intended solely for the person or entity
to which it is addressed and may contain confidential and/or privileged
information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the
MessageLabs Email Security System.
===
If you think education is expensive, try ignorance. (Derek Bok)
===
DBA!ert, Independent Oracle consultancy
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel. +31 (0) 182 64 04 28
fax +31 (0) 182 64 04 29
e-mail info.dbalert@xxxxxxxxx
This e-mail is intended solely for the person or entity to which
it is addressed and may contain confidential and/or privileged
information. Any review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs
Email Security System.
Other related posts:
