This discussion is archived
2 Replies Latest reply: Nov 7, 2012 1:49 PM by rcc50886 RSS

best practice: let asm name your datafiles?

453674 Newbie
Currently Being Moderated
Hello,

Wanted to get opinions on what dbas prefer: let asm handle naming or explicitly name your datafiles?
+DATA/orcl/datafile/products.133.84672930
or
+DATA/orcl/datafile/products01.dbf

Reasons? Ease of maintenance, backup/recover, etc?

Thanks
  • 1. Re: best practice: let asm name your datafiles?
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    Please refer this http://docs.oracle.com/cd/B13789_01/server.101/b10739/omf.htm

    Your questions are answered in the above document. I have most of my databases on OMF and I leave it to Oracle on assigning the names.

    ninteck      
    Newbie
         
    Handle:      ninteck
    Status Level:      Newbie (5)
    Registered:      Sep 12, 2005
    Total Posts:      25
    Total Questions:      5 (4 unresolved)
    Name      ninteck
    If you feel that your questions have been answered, then please consider closing your questions by providing appropriate points and marking them as answered. Please keep the forum clean !
  • 2. Re: best practice: let asm name your datafiles?
    rcc50886 Journeyer
    Currently Being Moderated
    Wanted to get opinions on what dbas prefer: let asm handle naming or explicitly name your datafiles? 
    +DATA/orcl/datafile/products.133.84672930
    or
    +DATA/orcl/datafile/products01.dbf
    
    Reasons? Ease of maintenance, backup/recover, etc? 
    Even if you explicitly specify the name for a file, ASM will actually creates the filename with OMF standard and explicit name will be just alias for that file.

    So no need specify the name.

    -Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points