imran_nu Messages: 53 Registered: February 2007 Location: Islamabad
Member
Hi Gurus
I was given an assignment from my manager to implement Data Guard on an OLTP system. I have completed almost all the steps neccessary for data guard. The logs are written on both the Primary and Standby database. But I got the following error message when open the STANDBY database. Can anyone had the same issue. Please share the solution
alter database open read only;
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\DB_INSTALLED\ORADATA\SEC\SYSTEM01.DBF'
By digging out the trace file...i got the following error message
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'D:\DB_INSTALLED\ORADATA\SEC\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: 'D:\DB_INSTALLED\ORADATA\SEC\UNDOTBS01.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 3 - see DBWR trace file
ORA-01110: data file 3: 'D:\DB_INSTALLED\ORADATA\SEC\SYSAUX01.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: 'D:\DB_INSTALLED\ORADATA\SEC\USERS01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
imran_nu Messages: 53 Registered: February 2007 Location: Islamabad
Member
Thanks for your consideration!!!!
On Standby Database: The dbf files are located on path 'D:\DB_INSTALLED\ORADATA\STANDBY\SYSAUX01.DBF'
rather than on 'D:\DB_INSTALLED\ORADATA\SEC\SYSAUX01.DBF'
On Primary Database: DBF files are located 'D:\DB_INSTALLED\ORADATA\SEC\SYSAUX01.DBF'
I have created the control file from primary database by using create standby control file as '...' and paste it on STANDBY database. But its fetching the dbf files from the PRIMARY database path not STANDBY path.
SEC is the SID for Primary DB
and STANDBY is the SID for STANdBY DB
] 
Members
Search
Help
Register
Login
Home
