DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008

    File rename in standby with OMF

    Datfile on primary (Prod):


    Datafile on Stdby


    On stdy we wanted this file to in
    the folder.


    However, Oracle has created soft link and handling this internally which we can see within asmcmd.

    Everytime we add a datafile on primary, we use OMF and let oracle handle the path.
    But in the past somebody has added the datafile with absolute path and this resulted
    in the soft link creation on stdby.

    When we are cloning from stdby, we need to look into this path always. We want to get rid of this, and correct the path on Stdby.

    How can we do this ?

    The path on PRIMARY is correct. But on stdby we want the file to be moved to different folder.

    Is this possible ?

    We are on 11gR1 on Linux.

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    I think DB_FILE_NAME_CONVERT would do the trick.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jan 2008
    db_file_name convert would be ideal for new file creation.

    In this case, on stdby we have datafile with data in it. We just want to move the datafile to a different folder. Remind you that, the datafile on Primary is in the correct path. Only on stdby we need the change.

    If we follow the same procedure of renaming a datafile what we do in normal cases, ie., brign TS offline, move file to differnt path, alter ....rename, brign TS online etc. does this work in stdby ?

    does this has any impact on further transactions on these datafiles ?

    (I cannot test as this is prodcution )
    Last edited by sunidba; 11-23-2011 at 11:51 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.