Re: DataGuard Configuration in 10g

From: Surachart Opun <surachart_at_gmail.com>
Date: Wed, 18 Aug 2010 11:23:50 +0700
Message-ID: <AANLkTikuX3D8N0N=EkwKezcjYunggYL15mOHvn0nJUUc_at_mail.gmail.com>

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_at_gmail.com>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> _at_$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_at_gmail.com>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> _at_$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_at_gmail.com> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 17 2010 - 23:23:50 CDT