OraFAQ Forum: Server Administration » Don't have disk space when add data file on primary database

Home » RDBMS Server » Server Administration » Don't have disk space when add data file on primary database (Oracle 10g, RHEL 5.4)

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

Don't have disk space when add data file on primary database [message #588262]

Mon, 24 June 2013 05:52

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Oracle JOB
Next Topic:	Blade server upgradation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:47:44 CST 2024