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?

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

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