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

Thread: Dataguard - Switchover failure

  1. #1
    Join Date
    Jan 2005
    Posts
    10

    Dataguard - Switchover failure

    System Specs: W2k server, Oracle 9.2, Running High Availability mode

    Everytime I try to do a dataguard switchover I get errors from the standby database. The primary switches over with no problem but after submitting the "alter database commit to switchover to primary with session shutdown" on the the current physical standby I get these errors:

    alter database commit to switchover to primary with session shutdown
    *
    ERROR at line 1:
    ORA-00344: unable to re-create online log 'E:\ORACLE\ORADATA\CESCATI\REDO01.LOG'
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.

    E:\oracle\oradata\cescati\redo01.log is the correct path for redo logs on the current primary database. This is the path used in the db_file_name_convert.

    eg. *.db_file_name_convert='e:\oracle\oradata\cescati','g:\oracle\oradata\cescati2\standby'

    I thought maybe I should switch the path valuse around since the new primary will actually be the 2nd path value in this parameter

    After switching the path values in the db_name_convert and log_file_name_convert parameters and I get these errors:

    alter database commit to switchover to primary with session shutdown
    *
    ERROR at line 1:
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\CESCATI\SYSTEM01.DBF'

    Can anyone help me?

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Hi,

    you need to use this parameter in the init.ora file as well
    LOG_FILE_NAME_CONVERT => This converts primary database redo log filenames to standby database redo log filenames.

  3. #3
    Join Date
    Jan 2005
    Posts
    10
    Ihave the log_file_name_convert parameter set in the same manner as the db_file_name_convert.

    On the current primary these parameters should be set with the first path value of the current physical standby database right?

    These parameter are used only when the database is converted over to physical standby correct?
    Last edited by Orako; 06-06-2005 at 07:48 AM.

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