Re: DataGuard Configuration in 10g

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
>
>
>
>
> 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: