Re: Exadata and Oracle managed Files

From: Freek D'Hooge <>
Date: Mon, 07 Apr 2014 23:29:04 +0200
Message-ID: <1396906144.14527.8.camel_at_dhoogfr-lpt1>


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.


Exitas NV
Senior Oracle DBA
tel +32(03) 443 12 38

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

Received on Mon Apr 07 2014 - 23:29:04 CEST

Original text of this message