Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Tr : 9i Physical Standby - This is fun (not!)

Tr : 9i Physical Standby - This is fun (not!)

From: Bernard Polarski <bpolarsk_at_yahoo.com>
Date: Tue, 30 May 2006 00:02:25 -0700 (PDT)
Message-ID: <20060530070225.72906.qmail@web36507.mail.mud.yahoo.com>

<!-- DIV {margin:0px;}-->Mladen has cheated : This command is in the manual, here is the proof :  

 http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/sql_stmts.htm  

 Let's start a petition! It is time we kick in their bottom all people that reads the manuals.  

 B. Polarski    

 -----Original Message-----
 From: Mladen Gogala [mailto:gogala_at_sbcglobal.net]  Sent: Tuesday, 30 May, 2006 3:23 AM
 To: david.barbour1_at_gmail.com
 Cc: Oracle-L Freelists
 Subject: Re: 9i Physical Standby - This is fun (not!)      

 On 05/29/2006 08:46:46 AM, David Barbour wrote:
> Greetings on this Memorial Day Holiday. I've got a 9i Primary database -
> 9.2.0.7 on AIX 5.3L. The physical standby, with the same database, OS and
> filesystem, is located in another state. The physical standby has been
> operating perfectly. Receiving archive logs from the primary, able to
> convert to a read-only and back again, no trouble.
>
> Then I decided to try to perform a switchover.
>
> Told the primary to 'alter database commit to switchover to physical
> standby;' and got a 'database altered'. Then a shutdown immediate;, startup
> nomount; and alter database mount standby database; It's all good. But I'm
> expecting the switchover_status in v$database on the standby to go to
> SWITCHOVER PENDING. It doesn't.
>
> Bummer.
   

 David, no bummer. You did well my young padawan. The "SWITCHOVER PENDING" is  the desired status. Now, you have to perform the switchover. Uncle Larry  wants you (with the pointer finger pointed in your direction) to perform  the following:
 ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN WAIT;    Your database will then sprout a new set of online redo logs, if you don't  already have them created.  

 After that, you need to shutdown database (normal or immediate) and re-start it.  That's it. May the force be with you!  

 --
 Mladen Gogala
 http://www.mgogala.com  

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 30 2006 - 02:02:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US