LOG_FILE_NAME_CONVERT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: LOG_FILE_NAME_CONVERT

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Hi All,


    My Primary database has three redo logfiles with 2 members in each located at different drives, while setting up LOG_FILE_NAME_CONVERT parametre for standby database
    init.ora which path I have to specify...Path of first member of logfile to convert or second member of log file
    or can I specify path of any member ? because both member are at differnt drives..

    Thanks

    Sameer

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    http://otn.oracle.com/docs/products/...ch192.htm#5595

    Just mention the primary path and stby path as string1 and string2.
    Reddy,Sam

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    yes, but what do I have to specify if in primary database one log member is on one slice and other member is on another slice...

    F.ex

    group# member
    ------------------------------------------------------
    1 /data/oradata/ora4/redo01.log
    1 /opt/oracle/data2/ora4/logfile/redo01m.log

    2 /data/oradata/ora4/redo02.log
    2 /opt/oracle/data2/ora4/logfile/redo02m.log

    3 /data/oradata/ora4/redo03.log
    3 /opt/oracle/data2/ora4/logfile/redo03m.log

    Is it okay if I specify path of one of the member in init.ora of standby database...

    log_file_name_convert = ("/data/oradata/ora4","/data/oradata/ora5")

    what about members in "/opt/oracle/data2/ora4/".. How my standby database will know that other members path is also changed...

    Thanks

    Sameer

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Does it matter if I specify path of one of the member????

    what about second members path in standby database???

    Please answer

    Thanks

    Sameer

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    If you set up ypur database on OFA (Optimal Flexible Architecture) you can take advantage of this parmeter otherwise, Not.
    Reddy,Sam

  6. #6
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    in init of stand by you can specify only one log path convert
    others you need to convert using
    alter database rename datafile 1 to 2


  7. #7
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Thanks a lot for the replies...

    I ALTERed rest of members

    Thanks

    Sameer

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