RE: 9i Physical Standby failover

From: Polarski, Bernard <Bernard.Polarski_at_atosorigin.com>
Date: Tue, 10 Oct 2006 14:47:23 +0200
Message-ID: <25D4919915CCF742A88EE3366D6D913D0D56871E@mailserver1>

Sound like people are mixing 'switch' and 'open' a standby. If you have properly configured your primary, you can flip flop primary and standby and reverse without having to rebuild either one. I have done it and its works fine. Just read the documentation, it is very good on the topic and you can do this without resorting to dgmgrl. I have done it with just 'sqlplus / as sysdba' to escape a main site electricity maintenance for a Tera DB and came back a day later, applied all the logs generated on the DG site while the DB was performing as primary and switch back from DG site to primary at the end of the day.. I did not had to rebuild any DB for this. Just ensure you have applied all your logs and you are fine.  

Stick to the oracle documentation  

B. Polarski

---

From: eagle fan [mailto:eagle.f_at_gmail.com] Sent: Tuesday, 10 October, 2006 11:11 AM To: Roger.Xu_at_dp7upbg.com
Cc: Oracle-L_at_Freelists. Org (E-mail)
Subject: Re: 9i Physical Standby failover

hi:

If you active standby database, you need to build a new standby database for the new activated primary database.

I think it's not your original purpose. You planned to do swithover but at last you did activate standby. They are different things.

On 10/10/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:

        It's working now - thank you all - Roger          

        SQL> alter database mount standby database;          

        Database altered.          

        SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;                   Database altered.          

        SQL> select status from v$instance;          

	STATUS


	------------

	STARTED
	 
	SQL> alter database mount;
	 
	Database altered.
	 
	SQL> alter database open;
	 
	Database altered.
	 
	SQL> select status from v$instance;
	 
	STATUS


	------------

	OPEN
	 
	SQL>
	

		-----Original Message-----
		From: oracle-l-bounce_at_freelists.org [mailto:

oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ]On Behalf Of Roger Xu

		Sent: Monday, October 09, 2006 2:54 PM
		To: Oracle-L_at_Freelists. Org (E-mail)
		Subject: 9i Physical Standby failover
		
		
		Hi,
		 
		I am testing failover but getting ORA-1666 error.
		Am I missing something here?
		 
		Thanks,
		 
		Roger
		 
		 
		 
		SQL> alter database recover managed standby database

finish;                  

                Database altered.                  

		SQL> alter database commit to switchover to primary;
		alter database commit to switchover to primary
		*
		ERROR at line 1:
		ORA-16139: media recovery required
		 
		

		SQL> shutdown immediate;
		ORA-01109: database not open
		 

		Database dismounted.
		ORACLE instance shut down.
		SQL> startup
		ORACLE instance started.
		 
		Total System Global Area  420480856 bytes
		Fixed Size                   730968 bytes
		Variable Size             117440512 bytes
		Database Buffers          301989888 bytes
		Redo Buffers                 319488 bytes
		ORA-01666: controlfile is for a standby database
		 

		SQL>

	
	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.         

        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.         

-- 
Eagle Fan

Oracle DBA 

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 10 2006 - 07:47:23 CDT