2 Replies Latest reply: Apr 8, 2013 11:27 AM by Victor Armbrust RSS

    db_file_name_convert in primary RAC database

    Neo-b
      Hello All,

      I am using Oracle 11gR2.

      My primary database is Oracle RAC 2 nodes with ASM.
      I am trying to build a physical standby database single instance and I am creating the pfile for the primary database, I have a question concerning the "db_file_name_convert" and the "log_file_name_convert" paramters.

      it should be like below:
      db_file_name_convert='+DATA/ORCL/DATAFILE/','/u01/app/oracle/oradata/STANDBY/'
      log_file_name_convert='+DATA/ORCL/ONLINELOG','/u01/app/oracle/oradata/STANDBY/'
      or
      db_file_name_convert='+DATA(DATAFILE)','/u01/app/oracle/oradata/STANDBY/'
      log_file_name_convert='+DATA(ONLINELOG)','/u01/app/oracle/oradata/STANDBY/'
      Since when I want to create a datafile in ASM for example, I do not mention: create tablespace TS_NAME DATAFILE '+DATA/ORCL/DATAFILE/filename.dbf', instead I use create tablespace TS_NAME DATAFILE +DATA(DATAFILE) in order not create links.

      Please advise

      Regards,