RE: DataGuard Configuration in 10g
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <surachart@xxxxxxxxx>, "KRISHNA MOORTHY" <krish33moorthy@xxxxxxxxx>
- Date: Wed, 18 Aug 2010 08:46:54 -0400
The biggest reason that your switch over will fail is because redo apply
is still running. If you really want to be able to resync with the
primary then you need to use "alter database commit to switchover to
primary with session shutdown;" Using the activate command makes
permanent changes to the control files that cannot be reversed, you'll
have to rebuild the standby. Also, according to Oracle's
recommendations in the DG manual you should have the same operating
system and software, meaning that 32 bit primary and 64 bit standby is a
NO GO.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Surachart Opun
Sent: Wednesday, August 18, 2010 12:24 AM
To: KRISHNA MOORTHY
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: DataGuard Configuration in 10g
In case, (migrate mode, for 32bits to 64bits)
You should do after you failover database ....
But... if you mean after startup standby database for testing....and
then change to standby... again
Example:
SQL> select open_mode from v$database ;
OPEN_MODE
--------------------
MOUNTED
SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
no rows selected
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2211928 bytes
Variable Size 159387560 bytes
Database Buffers 50331648 bytes
Redo Buffers 5226496 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database ;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2211928 bytes
Variable Size 159387560 bytes
Database Buffers 50331648 bytes
Redo Buffers 5226496 bytes
SQL> alter database mount standby database;
Database altered.
SQL> select open_mode from v$database ;
OPEN_MODE
--------------------
MOUNTED
Surachart Opun
http://surachartopun.com
On Wed, Aug 18, 2010 at 11:03 AM, KRISHNA MOORTHY
<krish33moorthy@xxxxxxxxx> wrote:
Thanks for your reply.
1. Switch to Primary
SQL> alter database commit to switchover to primary;
if the commit to switchover fails for any reason you have to use
the activate command
SQL> alter database activate standby database;
------ After the above query execution The standby database
will act as an normal database.I think again we can not synch up with
primary database.
2. start database(migrate mode, for 32bits to 64bits) by
use nocluster
SQL> alter system set cluster_database=FALSE
scope=spfile;
SQL> shutdown immediate;
SQL> startup migrate;
SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql
---------- Once i execute the above steps in my standby
database server(64 bit) ,
sql> shutdown immediate
sql> startup open
Then ,is it synch with old primary server.
Regards
Krishna
Regards
KRishna
On Wed, Aug 18, 2010 at 9:15 AM, Surachart Opun
<surachart@xxxxxxxxx> wrote:
If 32bit -> 64 bit... you have to migrate mode
1. Switch to Primary
SQL> alter database commit to switchover to primary;
if the commit to switchover fails for any reason you
have to use the activate command
SQL> alter database activate standby database;
------ After the above query execution The DR database
will act as an normal database.I think again we can not synch up with
primary database.
2. start database(migrate mode, for 32bits to 64bits) by
use nocluster
SQL> alter system set cluster_database=FALSE
scope=spfile;
SQL> shutdown immediate;
SQL> startup migrate;
SQL> @$ORACLE_HOME/rdbms/admin/utlirp.sql
---------- Once i execute the above steps in my standby
database server ,
sql> shutdown immediate
sql> startup open
Then ,is it synch with primary server.
Surachart Opun
http://surachartopun.com <http://surachartopun.com/>
On Wed, Aug 18, 2010 at 10:33 AM, KRISHNA MOORTHY
<krish33moorthy@xxxxxxxxx> wrote:
Hi All,
I have a doubt during the dataguard
configuration in oracle 10g.
1) We have primary server which is 32 bit Linux
OS and 32 bit databae server and standby server which is 64 bit Linux OS
and 64 bit database server.By using this DG configuration will it work
properly.
2) Generally Standby database in mount
stage.Once switch over operation happened,Standby will become primary
database.During this time wheteher we need to run catlog.sql and
catproc.sql at the new primary server side..
Regards
Krishna
Other related posts:
