OraFAQ Forum: Data Guard » Delete the datafile from Standby

Home » Server Options » Data Guard » Delete the datafile from Standby (ORACLE 10g Release 2 )

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

Delete the datafile from Standby [message #428930]

Fri, 30 October 2009 16:23

stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai

Junior Member

Hi,

On production i ran "alter database datafile...offline drop" command to drop the datafile from tablespace. But didn't worked. then i again made the same datafile online by performing media recovery and dropped the datafile using "alter tablespace drop datafile" command.
But on standby system it is still showing in v$datafile table. The standby system is properly sync with production.

Can you please suggest how can i drop the same from standby system?

Regards,
Vish

Report message to a moderator

[Message index]

		Delete the datafile from Standby By: stonevishcool on Fri, 30 October 2009 16:23
		Re: Delete the datafile from Standby By: Sahba1969 on Thu, 26 November 2009 08:18
		Re: Delete the datafile from Standby By: babuknb on Thu, 26 November 2009 15:18
		Re: Delete the datafile from Standby By: stonevishcool on Thu, 26 November 2009 22:47
		Re: Delete the datafile from Standby By: babuknb on Fri, 27 November 2009 04:59

Previous Topic:	Create Logical Standby coexisting with Physical Standby database
Next Topic:	Physical Standby, using ASM (!?)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 18:07:33 CDT 2024