Home » Server Options » Data Guard » error in alert log of standby db
error in alert log of standby db [message #467398] Fri, 23 July 2010 13:51 Go to next message
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 #467674 is a reply to message #467398] Mon, 26 July 2010 10:29 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member

ORA-01157: cannot identify/lock data file string - see DBWR trace file 

Cause: The background process was either unable to find one of the data files or failed to lock it because 
the file was already in use. 
The database will prohibit access to this file but other files will be unaffected. 
However the first instance to open the database will need to access all online data files. 
Accompanying error from the operating system describes why the file could not be identified.
 
Action: Have operating system make file available to database. 
Then either open the database or do ALTER SYSTEM CHECK DATAFILES. 


>>although im doing this command while primary database is shutdown!

Why primary database down?

Babu
Re: error in alert log of standby db [message #470157 is a reply to message #467398] Mon, 09 August 2010 01:54 Go to previous message
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
Previous Topic: Best practice for Archive_log destination
Next Topic: remote_login_passwordfile for dataguard
Goto Forum:
  


Current Time: Wed Jul 30 04:15:14 CDT 2014

Total time taken to generate the page: 0.21801 seconds