Home » Server Options » Data Guard » delete datafile in Primary (10.2.0.1)
delete datafile in Primary [message #555669] Sat, 26 May 2012 23:40 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I haved drop a datafile on Primary,and the archived log has transported to Standby,but the datafile is still exist in Standby. Why?

Primary
alter tablespace tps_hxl
drop datafile '/u02/app/oracl/oradata/hxl10.dbf';

Re: delete datafile in Primary [message #555670 is a reply to message #555669] Sat, 26 May 2012 23:49 Go to previous messageGo to next message
Michel Cadot
Messages: 58644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does say the documentation?
Why do you still refuse to post what is requested?

Regards
Michel

[Updated on: Sat, 26 May 2012 23:49]

Report message to a moderator

Re: delete datafile in Primary [message #555676 is a reply to message #555669] Sun, 27 May 2012 01:40 Go to previous messageGo to next message
John Watson
Messages: 4417
Registered: January 2010
Location: Global Village
Senior Member
Read up on the instance parameter standby_file_management
Re: delete datafile in Primary [message #555679 is a reply to message #555676] Sun, 27 May 2012 03:29 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,I have read the doc,but i can not find the detail about my issue.
John,standby_file_management is set to auto on Standby.
Re: delete datafile in Primary [message #555685 is a reply to message #555679] Sun, 27 May 2012 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which ones did you read?

Regards
Michel

[Updated on: Sun, 27 May 2012 08:41]

Report message to a moderator

Re: delete datafile in Primary [message #555691 is a reply to message #555685] Sun, 27 May 2012 07:01 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,I can not find the detail about Oracle Doc.can you tell me?
Re: delete datafile in Primary [message #555696 is a reply to message #555691] Sun, 27 May 2012 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sun, 27 May 2012 12:15
Which ones did you read?

Regards
Michel

Re: delete datafile in Primary [message #556071 is a reply to message #555669] Thu, 31 May 2012 02:52 Go to previous message
mahir.quluzade
Messages: 2
Registered: August 2011
Location: Azerbaijan
Junior Member

Hi,

If you want automatically delete standby datafile, you must set *.standby_file_management parameter file value AUTO on primary and standby.
Becouse, if you make switchover, after that old standby chage role to primary and primary change role to standby.
After switchover you can delete datafile, and old primary must delete file automatically.

Regards.
Mahir M. Quluzade
Previous Topic: GAP archived log issue
Next Topic: db_file_name_convert and log_file_name_convert
Goto Forum:
  


Current Time: Sat Aug 02 01:08:03 CDT 2014

Total time taken to generate the page: 0.29213 seconds