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: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 28 Apr 2007 11:10:08 -0700
Message-ID: <1177783808.874806.128980@y80g2000hsf.googlegroups.com>


On Apr 28, 10:14 am, sybra..._at_hccnet.nl wrote:
> On Sat, 28 Apr 2007 13:19:54 +0200, "Golan" <G..._at_hotmail.it> wrote:
>
> >> 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
>
> >I have to decide what to use.
> >So which can be the best choice ?
>
> >Thank you very much.
>
> What was unclear about my response?
> Did you read it, at all?
> You didn't respond to my question.
> I was referring to your current database. If your current database
> doesn't reside on a RAC compatible filesystem, you would need to move
> all your datafiles to a RAC compatible filesystem, and your 'trick'
> won't work.
> All things being equal, RAW is inflexible, and ASM is preferred.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Guess it may be time for the BAARF gang to publish the "You probably don't need ASM" article. Received on Sat Apr 28 2007 - 13:10:08 CDT

Original text of this message

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