Home » Server Options » Replication » Applying DB Structure changes without downtime (Oracle 11g)
Applying DB Structure changes without downtime [message #499920] Wed, 16 March 2011 12:52 Go to next message
subxgum
Messages: 2
Registered: March 2011
Location: New York, USA
Junior Member
Hello all,

We are trying eliminate/minimize the downtime for our application. As part of new code deployments sometimes we need to modify DB Structure also. As it is taking time to backup current DB and apply new DDL, the application is down.

Is there a way to eliminate the downtime, if I can leverage Data Guard, Golden Gate or RAC concepts?

I am reading about these products and thought about asking out as this requirement is common among Web Applications.

Thanks for your help!

Re: Applying DB Structure changes without downtime [message #499922 is a reply to message #499920] Wed, 16 March 2011 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there a way to eliminate the downtime,

One word EDITION = 0 application downtime.

Regards
Michel

[Updated on: Wed, 16 March 2011 13:06]

Report message to a moderator

Re: Applying DB Structure changes without downtime [message #499923 is a reply to message #499922] Wed, 16 March 2011 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/technetwork/issue-archive/2009/09-nov/o69asktom-089919.html
http://www.oracle.com/technetwork/issue-archive/2010/10-jan/o10asktom-172777.html
http://www.oracle.com/technetwork/issue-archive/2010/10-mar/o20asktom-098897.html
http://www.oracle.com/technetwork/issue-archive/2010/10-may/o30asktom-082672.html

Regards
Michel
Re: Applying DB Structure changes without downtime [message #500074 is a reply to message #499923] Thu, 17 March 2011 10:24 Go to previous message
subxgum
Messages: 2
Registered: March 2011
Location: New York, USA
Junior Member

Thank you!!!!
Previous Topic: Data block corruption
Next Topic: Refresh fails on MV with CLOB data type
Goto Forum:
  


Current Time: Thu Mar 28 15:40:13 CDT 2024