Re: Exadata and Oracle managed Files
- From: Freek D'Hooge <freek.dhooge@xxxxxxxxx>
- To: royxavier@xxxxxxxxx
- Date: Mon, 07 Apr 2014 23:29:04 +0200
Thomas,
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@xxxxxxxxx
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
Other related posts:
