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

Comments embedded

On Sun, 29 Apr 2007 00:10:15 +0200, "Golan" <Golan_at_hotmail.it> wrote:

>Excuse Sybrand, I was not so clear in the main question:
>
>We have a 9i database on a server, we decided to create a new one 10g on the
>new server, recreating the main objects and transferring historical data
>with a db link.
>Now we want to make all possible actions, to make the new server "raccable"
>without duplicating data, and with the less effort possible.
>

So this wasn't a serious question after all. First of all you still didn't answer my question whether your data on the existing database is on RAW. Probably because you don't know the answer. However, the question has become irrelevant, because obviously you can't a 9i (potentially cooked) database with 10g RAC as the database format has changed.
At it's best you would need to upgrade the existing server to 10g (non-RAC) and use RMAN to duplicate your database to the cluster. And yes, that means moving 4 Terabyte

>Asm can give us just balancing becouse redundancy is guaranted by the raid
>configuration on the storage.
>

Your understanding of ASM is very limited. The main advantage of ASM is you can use ordinary files again.

>Massimo

I would recommend you stop wasting people's time by withhelding relevant details.

-- 
Sybrand Bakker
Senior Oracle DBA