Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g to RAC - what to do to avoid data duplication ?

Re: 10g to RAC - what to do to avoid data duplication ?

From: <sybrandb_at_hccnet.nl>
Date: Sat, 28 Apr 2007 13:01:18 +0200
Message-ID: <m7a633p1te46t3kn49te9qop1bbqrg4uj6@4ax.com>


On Sat, 28 Apr 2007 11:14:05 +0200, "Golan" <Golan_at_hotmail.it> wrote:

>I'm going to create a 10gR2 database on a server (to be installed: SO Linux
>Red Hat 4.4).
>I will load in the database 4 terabyte of data during next months .
>
>On next december we would like the database to be part of a three node RAC.
>
>Now, the question is:
>Since I do not want to make a copy of 4 tera (cloning the database on the
>RAC, and I do not know how), would it be possible to make my actual node as
>part of the RAC without copying any data ?
>What can I do now on the server (to be installed as mentioned before) to put
>myself in the best situation for the future migration to the RAC ?
>
>Thank you
>Massimo
>

And your current datafiles are on

- RAW
- ASM
- cooked filesystem?

In the latter case you would need to convert the datafiles to RAW (using dd or RMAN) or ASM (using RMAN). This would involve copying 4Tb.
In short: yes it can be done, but forget about it if your files are not on a RAC compatible file system.

-- 

Sybrand Bakker
Senior Oracle DBA
Received on Sat Apr 28 2007 - 06:01:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US