Re: DataGuard Configuration in 10g

From: Surachart Opun <surachart_at_gmail.com>
Date: Wed, 18 Aug 2010 10:45:09 +0700
Message-ID: <AANLkTinsGozQAQOQO+DEFhuEyuPjmWk3RkEmL4j1O+WO_at_mail.gmail.com>

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> _at_$ORACLE_HOME/rdbms/admin/utlirp.sql

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 - 22:45:09 CDT