4 Replies Latest reply: Jun 6, 2013 6:02 AM by Santosh Pradhan RSS

    using "log_file_name_convert" and "db_file_name_convert" in asm for standby

    Santosh Pradhan
      Hi ,
      Oracle 11R2 enterprise edition asm

      We have cbsprod primary database on server and planning to create standby database .
      I want to use "log_file_name_convert" and "db_file_name_convert" .

      Plz let me know how the above parameters will be utilized by considering following info

      Details on PRIMARY :
      GROUP# STATUS MEMBER
      ---------- ------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 +DATA1/cbsprod/onlinelog/group_1.262.813692221
      1 +DATA1/cbsprod/onlinelog/group_1.263.813692221
      2 +DATA1/cbsprod/onlinelog/group_2.264.813692221
      2 +DATA1/cbsprod/onlinelog/group_2.265.813692221
      3 +DATA1/cbsprod/onlinelog/group_3.266.813692221
      3 +DATA1/cbsprod/onlinelog/group_3.267.813692221
      4 +REDOCONTROL01/cbsprod/onlinelog/group_4.256.813773233
      4 +REDOCONTROL02/cbsprod/onlinelog/group_4.256.813773235
      5 +REDOCONTROL03/cbsprod/onlinelog/group_5.256.813773335
      5 +REDOCONTROL01/cbsprod/onlinelog/group_5.257.813773335
      6 +REDOCONTROL02/cbsprod/onlinelog/group_6.257.813773375
      6 +REDOCONTROL03/cbsprod/onlinelog/group_6.257.813773375
      7 +REDOCONTROL01/cbsprod/onlinelog/group_7.258.813773443
      7 +REDOCONTROL02/cbsprod/onlinelog/group_7.258.813773443
      8 +REDOCONTROL03/cbsprod/onlinelog/group_8.258.813773461
      8 +REDOCONTROL01/cbsprod/onlinelog/group_8.259.813773461
      9 +REDOCONTROL01/cbsprod/onlinelog/group_9.260.813773465
      9 +REDOCONTROL02/cbsprod/onlinelog/group_9.259.813773465



      Details on Standby database :
      SQL> select GROUP#,STATUS,MEMBER from v$logfile order by GROUP#;

      GROUP# STATUS MEMBER
      ---------- ------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      1 +DATA1/cbsdr/onlinelog/group_1.262.813692221
      1 +DATA1/cbsdr/onlinelog/group_1.263.813692221
      2 +DATA1/cbsdr/onlinelog/group_2.264.813692221
      2 +DATA1/cbsdr/onlinelog/group_2.265.813692221
      3 +DATA1/cbsdr/onlinelog/group_3.266.813692221
      3 +DATA1/cbsdr/onlinelog/group_3.267.813692221
      4 +REDOCONTROL01/cbsdr/onlinelog/group_4.256.813773233
      4 +REDOCONTROL02/cbsdr/onlinelog/group_4.256.813773235
      5 +REDOCONTROL03/cbsdr/onlinelog/group_5.256.813773335
      5 +REDOCONTROL01/cbsdr/onlinelog/group_5.257.813773335
      6 +REDOCONTROL02/cbsdr/onlinelog/group_6.257.813773375
      6 +REDOCONTROL03/cbsdr/onlinelog/group_6.257.813773375
      7 +REDOCONTROL01/cbsdr/onlinelog/group_7.258.813773443
      7 +REDOCONTROL02/cbsdr/onlinelog/group_7.258.813773443
      8 +REDOCONTROL03/cbsdr/onlinelog/group_8.258.813773461
      8 +REDOCONTROL01/cbsdr/onlinelog/group_8.259.813773461
      9 +REDOCONTROL01/cbsdr/onlinelog/group_9.260.813773465
      9 +REDOCONTROL02/cbsdr/onlinelog/group_9.259.813773465

      18 rows selected.

      The same situation for datafiles :
      Datafiles on primary resides on +DATA1/cbsprod/datafiles/
      +DATA2/cbsprod/datafiles/
      +DATA3/cbsprod/datafiles/
      +DATA4/cbsprod/datafiles/
      +DATA5/cbsprod/datafiles/
      +DATA6/cbsprod/datafiles/
      +DATA7/cbsprod/datafiles/
      +DATA8/cbsprod/datafiles/
      +DATA9/cbsprod/datafiles/

      Datafiles on standby resides on +DATA1/cbsdr/datafiles/
      +DATA2/cbsdr/datafiles/
      +DATA3/cbsdr/datafiles/
      +DATA4/cbsdr/datafiles/
      +DATA5/cbsdr/datafiles/
      +DATA6/cbsdr/datafiles/
      +DATA7/cbsdr/datafiles/
      +DATA8/cbsdr/datafiles/
      +DATA9/cbsdr/datafiles/                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
        • 1. Re: using "log_file_name_convert" and "db_file_name_convert" in asm for standby
          1012306
          Enter below parameters in INIT<SID>.ORA file.

          *.log_file_name_convert='<path of logfile in PR>','<path of logfile in DR>'
          *.db_file_name_convert='<path of dbfile in PR>','<path of dbfile in DR>'

          If there are multiple log and db destinations:

          *.log_file_name_convert='<1st path of logfile in PR>','<1st path of logfile in DR>','<2nd path of logfile in PR>','<2nd path of logfile in DR>',...
          *.db_file_name_convert='<1st path of dbfile in PR>','<2nd path of dbfile in DR>','<1st path of dbfile in PR>','<2nd path of dbfile in DR>',...

          In your case:

          *.log_file_name_convert='+DATA1/cbsprod/onlinelog/','+DATA1/cbsdr/onlinelog/','+REDOCONTROL01/cbsprod/onlinelog/','+REDOCONTROL01/cbsdr/onlinelog/','+REDOCONTROL02/cbsprod/onlinelog/','+REDOCONTROL02/cbsdr/onlinelog/',' REDOCONTROL03/cbsprod/onlinelog/','REDOCONTROL03/cbsdr/onlinelog/'

          *.db_file_name_convert='+DATA2/cbsprod/datafiles/','+DATA2/cbsdr/datafiles/','+DATA3/cbsprod/datafiles/','+DATA3/cbsdr/datafiles/','+DATA4/cbsprod/datafiles/','+DATA4/cbsdr/datafiles/','+DATA5/cbsprod/datafiles/','+DATA5/cbsdr/datafiles/','+DATA6/cbsprod/datafiles/','+DATA6/cbsdr/datafiles/','+DATA7/cbsprod/datafiles/','+DATA7/cbsdr/datafiles/','+DATA8/cbsprod/datafiles/','+DATA8/cbsdr/datafiles/','+DATA9/cbsprod/datafiles/','+DATA9/cbsdr/datafiles/'

          Note: Put "/" at the end of path.

          Edited by: 1009303 on Jun 2, 2013 12:47 AM
          • 2. Re: using "log_file_name_convert" and "db_file_name_convert" in asm for standby
            Santosh Pradhan
            s

            Edited by: Santosh Pradhan on Jun 2, 2013 1:15 PM
            • 3. Re: using "log_file_name_convert" and "db_file_name_convert" in asm for standby
              Shivananda Rao
              Hello,
              Details on PRIMARY :
              GROUP# STATUS MEMBER
              -------
              1 +DATA1/cbsprod/onlinelog/group_1.262.813692221
              1 +DATA1/cbsprod/onlinelog/group_1.263.813692221
              2 +DATA1/cbsprod/onlinelog/group_2.264.813692221
              2 +DATA1/cbsprod/onlinelog/group_2.265.813692221
              3 +DATA1/cbsprod/onlinelog/group_3.266.813692221
              3 +DATA1/cbsprod/onlinelog/group_3.267.813692221
              4 +REDOCONTROL01/cbsprod/onlinelog/group_4.256.813773233
              4 +REDOCONTROL02/cbsprod/onlinelog/group_4.256.813773235
              5 +REDOCONTROL03/cbsprod/onlinelog/group_5.256.813773335
              It looks like you are using Oracle Managed Files (OMF) where Oracle names the files accordingly. In this case, you do not require to set the "db_file_name_convert" and "log_file_name_convert" on the standby database.
              You'll have to make sure that you set the "db_create_file_dest" on the standby database and Oracle automatically converts the filename from cbsprod to cbsdr.


              Regards,
              Shivananda
              • 4. Re: using "log_file_name_convert" and "db_file_name_convert" in asm for standby
                Santosh Pradhan
                yaaa u r right Shivananda Rao .
                I didnt use " db_file_name_convert" and "log_file_name_convert" for standby creation and as u explained OMF taken care in my case ..

                Thanxxxxxxxxxxxx