Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i Physical Standby failover
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;
STATUSoracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ]On Behalf Of Roger Xu
------------
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:
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 databasefinish;
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 whichit 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-lReceived on Tue Oct 10 2006 - 07:47:23 CDT
![]() |
![]() |