OraFAQ Forum: Data Guard » error after creating physical standby

Home » Server Options » Data Guard » error after creating physical standby (oracle9i, windows)

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

error after creating physical standby [message #324022]

Fri, 30 May 2008 05:22

dba_01
Messages: 8
Registered: January 2008

Junior Member

hi,
i tried to create the physical standby.
while giving recover standby database in physical standby.
i was getting following errors.

sql>recover standby database
ora:00283 - recovery session cancelled due to errors
ora:01110 - datafile 1: 'F:\oracle\ora91\oradata\system.dbf'
ora:01157 - cannot identity/lock datafile 1 - see DBWR trace file
ora:01110 - datafile 1: 'F:\oracle\ora91\oradata\system.dbf'

here...
my prod db is in F: drive in production server.
and my DR db is in C: drive in DR server.

my question is..
why is it pointing to prod server when 'm running in DR side.

help.

[Updated on: Fri, 30 May 2008 05:26]

Report message to a moderator

Re: error after creating physical standby [message #324065 is a reply to message #324022]

Fri, 30 May 2008 09:10

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Did you use DB_FILE_NAME_CONVERT in your spfile?

Report message to a moderator

Re: error after creating physical standby [message #324136 is a reply to message #324065]

Sat, 31 May 2008 02:02

dba_01
Messages: 8
Registered: January 2008

Junior Member

yes...
i have used
db_file_name_convert='f:\oracle\oradata\pidb','C:\oracle\oradata\PIDBSTANDBY\PIDB'
log_file_name_convert='f:\oracle\oradata\pidb','C:\oracle\oradata\PIDBSTANDBY\PIDB'

Report message to a moderator

Re: error after creating physical standby [message #324198 is a reply to message #324136]

Sat, 31 May 2008 08:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you sure you are starting the standby database with the correct spfile?

If so, you may want to try and manually rename the file and then perform recovery.

Report message to a moderator

Previous Topic:	rman 05507
Next Topic:	getting back to maximum availabilty

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 15 20:58:26 CDT 2024