On Jul 23, 12:24 pm, rajesh_chopr..._at_yahoo.co.uk wrote:
> I have archive logging enabled on by 10G R2 database with FRA in use
> an all my files are comming throught as OMF. Does anyone know if it is
> possible to change the archive log file name format?
>
> o1_mf_1_10_3b7qf19x_.arc
>
> TIA
Why?
The OMF filosophy dictates file names are irrelevant. As you should
use RMAN when using OMF, RMAN will know how to find those files. If
you want to find them, query v$archived_log.
Note: you either use OMF or you don't use it. No compromise possible!
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 23 2007 - 06:01:18 CDT
