Re: Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 06 Jul 2006 11:37:05 -0700
Message-ID: <1152211028.135444@bubbleator.drizzle.com>

Mladen Gogala wrote:
> On Mon, 03 Jul 2006 05:26:03 -0700, nirav wrote:
>

>> Since in the clustered environment we have 9.2.0.6 version, is it AT
>> ALL POSSIBLE to move this database, which is 9.2.0.7 to that
>> enviroment?

>
> Yes sir. You will have to recreate the controlfile and add another log
> thread and change maxinstances parameter. Once that is done, your database
> is essentially RAC.

What is required for a RAC database:

SYSTEM, SYSAUX, and TEMP tablespaces
Undo Tablespace (one per instance)
Datafiles
Control Files
Online Redo Logs (one thread per instance)

Don't for get the UNDO too.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Jul 06 2006 - 13:37:05 CDT