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

Thread: Dataguard - Cannot switchover

  1. #1
    Join Date
    Jan 2005
    Posts
    10

    Dataguard - Cannot switchover

    I am really at a loss. I have been on this problem for almost a week now.

    Primary switches over fine.

    On Standby I issue the command: alter database commit to switchover to primary with session shutdown

    I am getting this error:

    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'

    I have checked and rechecked the path and existence of these files that are located on the former primary server. They exists! Are they not being found? or Why would they be locked? The former primary is already converted and mounted as standby.

    Here is my DBWR trc File content:

    *** 2005-06-14 09:41:30.000
    *** SESSION ID:(2.1) 2005-06-14 09:41:30.000
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\CESCATI\SYSTEM01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
    ORA-01110: data file 2: 'E:\ORACLE\ORADATA\CESCATI\UNDOTBS1.ORA'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
    ORA-01110: data file 3: 'E:\ORACLE\ORADATA\CESCATI\CWMLITE01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
    ORA-01110: data file 4: 'E:\ORACLE\ORADATA\CESCATI\DRSYS01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    .
    .
    .

    I had the path values switched around to:

    db_file_name_convert='\oracle\oradata\cescati','\oracle\oradata\cescati2\standby'
    log_file_name_convert='\oracle\oradata\cescati\archive','\oracle\oradata\cescati2\standby'

    I dont know what to do next. Does anyone have a clue what I am missing here?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Just taking a shot at this .Since you are on windows you should be having something like

    db_file_name_convert='E:\oracle\oradata\cescati',
    'E:\oracle\oradata\cescati2\standby'
    log_file_name_convert='E:\oracle\oradata\cescati\archive',
    'E:\oracle\oradata\cescati2\standby'


    isnt it ?

    whats the version of oracle ?

    regards
    Hrishy

  3. #3
    Join Date
    Jan 2005
    Posts
    10
    Hey Hrishy,

    I found the problem. My log_file_name_convert parameter was pointing to the archivelog directory instead of the directory where the REDO LOGS were located and I switched the path values back around to the correct order. I kept switching the order trying to find out if I was correctly specifying them. Once I corrected this problem I was able to succesfully switchover. I cant beleive I didn't see this earlier.

    Thanks for your help and time.

    Garland

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