RE: DataGuard Configuration in 10g

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: