OraFAQ Forum: Data Guard » data guard configuration

Home » Server Options » Data Guard » data guard configuration (Oracle 10g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data guard configuration [message #409422]

Mon, 22 June 2009 09:22

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

Report message to a moderator

Re: data guard configuration [message #409423 is a reply to message #409422]

Mon, 22 June 2009 09:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

why can't Oracle find the *dbf files?

Report message to a moderator

Re: data guard configuration [message #409426 is a reply to message #409423]

Mon, 22 June 2009 09:53

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

Report message to a moderator

Re: data guard configuration [message #409427 is a reply to message #409422]

Mon, 22 June 2009 10:10

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: data guard configuration [message #409441 is a reply to message #409427]

Mon, 22 June 2009 13:54

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Post your pfile from primary and standby database.

Thanks

Report message to a moderator

Re: data guard configuration [message #409493 is a reply to message #409441]

Mon, 22 June 2009 22:50

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

Attachment: initSEC(Primary).ORA
(Size: 1.44KB, Downloaded 2796 times)

Report message to a moderator

Re: data guard configuration [message #409494 is a reply to message #409493]

Mon, 22 June 2009 22:51

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!!!!

Attachment: initSTANDBY(STANDBY).ora
(Size: 1.63KB, Downloaded 2623 times)

Report message to a moderator

Re: data guard configuration [message #409697 is a reply to message #409494]

Tue, 23 June 2009 09:08

babuknb
Messages: 1736
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

Report message to a moderator