db_file_name_convert for multiple mount point
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: db_file_name_convert for multiple mount point

  1. #1
    Join Date
    Mar 2001
    Posts
    286
    Please help on this issue:

    db_file_name_convert for multiple mount point

    I am working on creating a standby database. The problem I have is how the parameter, db_file_name_convert converting from multiple mount points.

    The the datafiles in the primary:
    ------------------------------
    /u02/oradata/dbt2/system01.dbf
    /u03/oradata/dbt2/tools01.dbf
    /u04/oradata/dbt2/rbs01.dbf
    KK.

    The projected datafiles in the standby is a single mount for the test purpose:

    /www/oradata/dbt2/system01.dbf
    /www/oradata/dbt2/ tools01.dbf
    /www/oradata/dbt2/ rbs01.dbf
    KK..

    db_file_name_convert converts only one mount point to one mount point. I have tried some different format and failed for converting more than one point,

    in the init.ora

    1)work: db_file_name_convert = /u02, /www

    2)failed: db_file_name_convert = /u02, /www
    db_file_name_convert = /u03, /www
    KK.
    3)failed: db_file_name_convert = (/u02, /www; /u03, /www; K..)

    4)failed: db_file_name_convert = (/u02, /www /u03, /www K..)

    The error for all the failed :
    SVRMGR> startup nomount pfile = /opt/app/oracle/admin/dbt2/pfile/initdbt2.ora
    ORA-01678: parameter db_file_name_convert must be two strings, a pattern and a replacement

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    that is because the error says "two strings, a pattern and a replacement" but should say "two strings AND ONLY TWO STRINGS, a pattern and a replacement "

    you only get one shot at it, as you have discovered.

    if your filesystems are not similar --on our primary we have 7 logical file systems and the standby has 2 logical filesystems [*note: not by *my* design ]-- you have to rename the files in the controlfile (normal methodolgy except this is done after ALTER DATABASE MOUNT STANDBY DATABASE ) or as they are added
    ALTER DATABASE CREATE DATAFILE 'primaryname' AS 'standbyname';

    check out the the oracle white paper on standbys or oracle docs on standby. it alludes to this, but does not actually *tell* you how to do it.

    hth, d.

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