Home » Server Options » Data Guard » data guard configuration (Oracle 10g R2)
data guard configuration [message #409422] Mon, 22 June 2009 09:22 Go to next message
imran_nu
Messages: 55
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




Your help would be regarded
Re: data guard configuration [message #409423 is a reply to message #409422] Mon, 22 June 2009 09:34 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
why can't Oracle find the *dbf files?
Re: data guard configuration [message #409426 is a reply to message #409423] Mon, 22 June 2009 09:53 Go to previous messageGo to next message
imran_nu
Messages: 55
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


Re: data guard configuration [message #409427 is a reply to message #409422] Mon, 22 June 2009 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
On the secondary, either
1) place the files where Oracle expects to find them
or
2) tell Oracle to look for them in the different/new folder.
Re: data guard configuration [message #409441 is a reply to message #409427] Mon, 22 June 2009 13:54 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Post your pfile from primary and standby database.

Thanks
Re: data guard configuration [message #409493 is a reply to message #409441] Mon, 22 June 2009 22:50 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Thanks for your help

My Primary and Standby database are located on the same path at different location.

Primary Database SID: sec (PFILE attached)
Physical Standby SID: STANDBY
Re: data guard configuration [message #409494 is a reply to message #409493] Mon, 22 June 2009 22:51 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Here is my Standby database PFILE

Please let me know if you need any other!!!!
Re: data guard configuration [message #409697 is a reply to message #409494] Tue, 23 June 2009 09:08 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
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'


As per the above update and your pfile; Your configuring data guard different structure from primary and standby database.

So; I'm not able to find the below parameter in your pfile.

DB_FILE_NAME_CONVERT & LOG_FILE_NAME_CONVERT

Refer: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/standby.htm#i64471
Re: data guard configuration [message #409812 is a reply to message #409697] Wed, 24 June 2009 03:08 Go to previous messageGo to next message
imran_nu
Messages: 55
Registered: February 2007
Location: Islamabad
Member

Great gentlebabu!!!

Problem solved!!!!

Thanks

Re: data guard configuration [message #409816 is a reply to message #409812] Wed, 24 June 2009 03:14 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for the feedback.

Babu
Previous Topic: How to create Physical standby database and steps for dataguard
Next Topic: estimating network delay of redo transfer - Dataguard
Goto Forum:
  


Current Time: Tue Dec 06 10:29:31 CST 2016

Total time taken to generate the page: 0.12624 seconds