2 Replies Latest reply: Nov 7, 2012 3:49 PM by rcc50886 RSS

    best practice: let asm name your datafiles?

    453674
      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
          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
            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