Re: DataGuard Configuration in 10g
- From: KRISHNA MOORTHY <krish33moorthy@xxxxxxxxx>
- To: Surachart Opun <surachart@xxxxxxxxx>
- Date: Wed, 18 Aug 2010 09:33:41 +0530
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:
