error in alert log of standby db [message #467398] |
Fri, 23 July 2010 13:51 |
kareem1825
Messages: 2 Registered: July 2010 Location: egy
|
Junior Member |
|
|
i did everything writen but when i do
*SQL>alter database recover managed standby database disconnect from session;*
i go and look in the standby database AlertLog file ,and thats whats writen
*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\SYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
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: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\UNDOTBS01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
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: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\SYSAUX01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
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: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\USERS01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DB\EXAMPLE01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.
*
strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!
any help would be appreciated
|
|
|
|
Re: error in alert log of standby db [message #470157 is a reply to message #467398] |
Mon, 09 August 2010 01:54 |
kareem1825
Messages: 2 Registered: July 2010 Location: egy
|
Junior Member |
|
|
well primary database been shutdown, cause i turned it down ,you say & the error says it cant lock the file cause it might be in use i turn it down so its not in use..
anyways about your solution ,u say "Have operating system make file available to database" how can i do that? do you mean the read-only option or what? please clearify and thanks a lot for your help so far
|
|
|