using log_file_name_convert
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: using log_file_name_convert

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    When using the log_file_name_convert parameter in creating a standby database, how can I configure my init.ora parameter file of the standby database on a different host to reference multiple redolog files on different mount points??

    Thanks
    roukie-dba

  2. #2
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Can someone MODERATORS please help with this???
    Thanks
    roukie-dba

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Are you getting any errors, or just would like to have some information on the configurations ?


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    When you create stanby DB you must place all files, including LOG in come directory structure ac primary DB.

    if uoy place db files and log files in another dir structure you must set 2 parameters for convers full file names with path for DB and LOG on standby DB box:

    db_file_name_convert
    log_file_name_convert

    for more information read classic books (Oracle Documentation library)

    [Edited by Shestakov on 10-17-2001 at 03:27 PM]

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Also check this Standby DB doc: http://oradoc.photo.net/ora817/DOC/s...a76995/toc.htm


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    SAM and others thanks!!!

    My problem is this:

    My primary database has two online logfile groups


    /u01/oradata/prod/redo01a.log
    /u01/oradata/prod/redo02a.log
    /u02/oradata/prod/redo01b.log
    /u02/oradata/prod/redo02b.log


    In the standby init.ora file, Oracle only allows the use of LOG_FILE_NAME_CONVERT just once and as follows:

    log_file_name_convert='/u01/oradata/prod', '/u01/oradata/standby'

    Which converts the logs in /u01/oradata/prod in the primary to /u01/oradata/standby of the standby host

    Now, my question is, how do I convert the logs in /u02/oradata/prod files???? When I put two LOG_FILE_NAME_CONVERT in the standby init.ora file, I get an error.

    Please moderators help!
    roukie-dba

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by roukie_dba

    log_file_name_convert='/u01/oradata/prod', '/u01/oradata/standby'

    Which converts the logs in /u01/oradata/prod in the primary to /u01/oradata/standby of the standby host
    Did you try

    log_file_name_convert= (('/u01/oradata/prod', '/u01/oradata/standby'),('/u02/oradata/prod', '/u02/oradata/standby'))


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Sam Thanks again, I have just tried your recommendation and now the instance start command gives the following error:

    SQL> startup nomount pfile=initstandbydb.ora
    ORA-01678: parameter log_file_name_convert must be two strings, a pattern and a replacement

    Doesn't like syntax...I still don't know how to convert for multiplexed logs...any more suggestions???
    roukie-dba

  9. #9
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    You may use convert string like this one:

    log_file_name_convert='/u0*/oradata/prod/redo*.log', '/u0*/oradata/standby/redo*.log'

    and use some convert rules for DB files

    db_file_name_convert='/u0*/oradata/prod/data_file*.ora', '/u0*/oradata/standby/datafile*.ora'

  10. #10
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Folks
    The preceding suggestion still did not work, any more ideas???
    roukie-dba

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