RE: 9i Physical Standby failover
- From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
- To: <eagle.f@xxxxxxxxx>,<Roger.Xu@xxxxxxxxxxx>
- Date: Tue, 10 Oct 2006 14:47:23 +0200
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@xxxxxxxxx]
Sent: Tuesday, 10 October, 2006 11:11 AM
To: Roger.Xu@xxxxxxxxxxx
Cc: Oracle-L@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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]On
Behalf Of Roger Xu
Sent: Monday, October 09, 2006 2:54 PM
To: Oracle-L@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
Other related posts:
