File rename in standby with OMF
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: File rename in standby with OMF

  1. #1
    Join Date
    Jan 2008
    Posts
    31

    File rename in standby with OMF

    Datfile on primary (Prod):

    +DG1/prod/user.dbf


    Datafile on Stdby

    +DG1/prod/user.dbf


    On stdy we wanted this file to in
    the folder.

    +DG1/std_prod/user.dbf


    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
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
    Posts
    31
    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