Re: DataGuard Configuration in 10g

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;


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


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: