Home » RDBMS Server » Server Administration » Database upgrades - with No downtime (12c)
Database upgrades - with No downtime [message #678163] Thu, 14 November 2019 00:05 Go to next message
deepakdot
Messages: 28
Registered: July 2015
Junior Member
Hi,

for the banking application database, What is the Best way to Upgrade the database with the new DDL/ DML changes going in, with the No downtime ?

we have a online database and a DR database. The requirement is not to have any downtime while upgrading the database. Any document / process followed as a best practice ?

Deepak
Re: Database upgrades - with No downtime [message #678164 is a reply to message #678163] Thu, 14 November 2019 02:47 Go to previous messageGo to next message
cookiemonster
Messages: 13754
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have a look at editions
Re: Database upgrades - with No downtime [message #678168 is a reply to message #678164] Thu, 14 November 2019 05:06 Go to previous messageGo to next message
deepakdot
Messages: 28
Registered: July 2015
Junior Member
I think Table is noneditionable. we dont have editionable objects like views , triggers etc in the database.
we upgrade only tables.
Re: Database upgrades - with No downtime [message #678170 is a reply to message #678168] Thu, 14 November 2019 06:23 Go to previous messageGo to next message
cookiemonster
Messages: 13754
Registered: September 2008
Location: Rainy Manchester
Senior Member
See if this is any help: https://blogs.oracle.com/oraclemagazine/edition-based-redefinition-part-2
Re: Database upgrades - with No downtime [message #678172 is a reply to message #678163] Thu, 14 November 2019 06:49 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
deepakdot wrote on Thu, 14 November 2019 00:05
Hi,

for the banking application database, What is the Best way to Upgrade the database with the new DDL/ DML changes going in, with the No downtime ?

we have a online database and a DR database. The requirement is not to have any downtime while upgrading the database. Any document / process followed as a best practice ?

Deepak
you said "upgrade the database", but it sounds like what you mean is to "upgrade" the application and its schemas. Please clarify. "Upgrade the database" normally means to apply a version upgrade or Release Update provided by Oracle - an update to the database software itself.
Re: Database upgrades - with No downtime [message #678214 is a reply to message #678172] Sun, 17 November 2019 23:14 Go to previous messageGo to next message
deepakdot
Messages: 28
Registered: July 2015
Junior Member
Here for upgrade I mean, the application and the schema. Where I will be upgrading the schema object ( New DDL, Alter DDL, DMLs etc ).
Re: Database upgrades - with No downtime [message #678215 is a reply to message #678214] Mon, 18 November 2019 00:19 Go to previous message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Editions are then the correct solution but you have to first build editioning views upon your tables which means the first time you can't avoid downtime.

Previous Topic: Object change from valid to invalid
Next Topic: Plenty of UNDO but keep getting ORA-01555
Goto Forum:
  


Current Time: Mon Dec 09 09:47:13 CST 2019