Re: Exadata and Oracle managed Files

In this aspect, the exadata storage is just ASM storage. Whenever you are creating datafiles within ASM, oracle will create an OMF filename.
If you explicitly name the file during creation, Oracle will still create an OMF filename and then create an alias to the file using the name you specified.

For datafiles copied using the cp command in asmcmd, I think Oracle will take the filename specified and append the file number and incarnation to it (while also generating an alias for it using the name you specified).
But I would need to check up on that.

I would always use the OMF files itself, not the alias names.

regards,

Exitas NV
Senior Oracle DBA
email: freek.dhooge_at_exitas.be
tel +32(03) 443 12 38
http://www.exitas.be

On ma, 2014-04-07 at 03:50 -0700, Thomas P S wrote:
> Hello List,

>
>
> We are in the middle implementing Exadata and a question came in -
> should we use OMF or not? OMF will help any way in Exadata other than
> simplifying file management ? We are planning to migrate the
> databases using Cross platform TTS. While doing TTS, we need to
> mention the full qualified names which will be treated as non-OMF
> files? Any help will be highly appreciated.
>
>
>
> Regards,
> Thomas

--
http://www.freelists.org/webpage/oracle-l