OraFAQ Forum: Data Guard » Unable to apply the recovery in DR

Home » Server Options » Data Guard » Unable to apply the recovery in DR (oracle 9.2.0.6.0 , sun solaris : 5.9)

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

Unable to apply the recovery in DR [message #310784]

Wed, 02 April 2008 07:21

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Code: [Select all] [Show/ hide]

Dear sir,
we have restored last week coldbackup in dr site.
and now we need to apply the recovery...
but we are getting below error now :

Unable to identify datafile:
'/BDPRD_dbmain1/database/BDPRD/data/ITS_DATA01.dbf',

the reason is we have created one TABLESPACE (ITS_DATA) with above datafile....in LIVE database. ...but we have restored last week coldbackup.

Now in order to mount the DR and apply the recovery,
what i did, i generated backup controlfile trace and i removed this datafile entry in that file , and sent to DR and tried to mount....finally DR is getting mounted. but while applying the recovery it throw the error:

" controlfile is not standby controlfile "

now is there any way to apply the recovery in DR site....

can we do "alter database create datafile.....command ????

pls confirm at the earliest....

kesavan.

Code: [Select all] [Show/ hide]

i would like to inform one more
we have added this tablespace yesterday
but cold backup was taken lastweek and has been restored in dr now.

one more ,
can we drop this new tablespace created in live database in order to prevent this error ?
pls cfm

Code: [Select all] [Show/ hide]

[Updated on: Wed, 02 April 2008 07:24]

Report message to a moderator

Re: Unable to apply the recovery in DR [message #311488 is a reply to message #310784]

Fri, 04 April 2008 11:16

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

For data guard you must create standby controlfile.

Code: [Select all] [Show/ hide]

SQL> Alter database create standby controlfile as ‘c:\oracle\backup\standcontrol.ctl’;

When you create this file paste it on the same location as mentinoed in Pfile/Spfile an dthen startup mount and perform recovery.

Report message to a moderator

Previous Topic:	Gaps have occured in the archive logs on my Standby DB (using Dataguard)
Next Topic:	Keep Oracle Database with Data Guard or EMC/SRDF?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:07:48 CDT 2025