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