Home » RDBMS Server » Server Administration » Don't have disk space when add data file on primary database (Oracle 10g, RHEL 5.4)
Don't have disk space when add data file on primary database [message #588262] Mon, 24 June 2013 05:52 Go to next message
sk.zeeshan@yahoo.co.in
Messages: 16
Registered: March 2012
Location: Mumbai
Junior Member
Hi Team,

I'm new into Oracle, Please consider the below scenario and respond it accordingly.

I want to add 500GB data file at primary database side, but doesn't have space at standby database side. My STANDBY_FILE_MANAGEMENT is set to Auto. Please advise me how to overcome from this situation.

Best Regards,
Zeeshan
Re: Don't have disk space when add data file on primary database [message #588267 is a reply to message #588262] Mon, 24 June 2013 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How your standby database will work if you add 500G of data and there is no space?

Regards
Michel

[Updated on: Mon, 24 June 2013 05:58]

Report message to a moderator

Re: Don't have disk space when add data file on primary database [message #588286 is a reply to message #588267] Mon, 24 June 2013 08:08 Go to previous messageGo to next message
sk.zeeshan@yahoo.co.in
Messages: 16
Registered: March 2012
Location: Mumbai
Junior Member
I will get the warning at standby side but data file will successfully add at primary database side if standby_file_management set to auto.
Re: Don't have disk space when add data file on primary database [message #588287 is a reply to message #588286] Mon, 24 June 2013 08:23 Go to previous message
Michel Cadot
Messages: 58840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What I meant, what is the purpose of a standby database? to follow the primary one and supply it in case of primary crash. If your standby database cannot hold the primary data it is useless and you can just stop it.

Regards
Michel
Previous Topic: Oracle JOB
Next Topic: Blade server upgradation
Goto Forum:
  


Current Time: Wed Aug 20 06:11:55 CDT 2014

Total time taken to generate the page: 0.09943 seconds