Home » Server Options » Data Guard » error after creating physical standby (oracle9i, windows)
error after creating physical standby [message #324022] Fri, 30 May 2008 05:22 Go to next message
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 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you use DB_FILE_NAME_CONVERT in your spfile?
Re: error after creating physical standby [message #324136 is a reply to message #324065] Sat, 31 May 2008 02:02 Go to previous messageGo to next message
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'
Re: error after creating physical standby [message #324198 is a reply to message #324136] Sat, 31 May 2008 08:30 Go to previous message
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.
Previous Topic: rman 05507
Next Topic: getting back to maximum availabilty
Goto Forum:
  


Current Time: Thu Mar 28 08:31:13 CDT 2024