| Apply Patches on Oracle Database with Logical Standby Database [message #504275] |
Fri, 22 April 2011 21:40  |
 |
dbnewbie
Messages: 2
Registered: April 2011
|
Junior Member |
|
|
Here I am:
I got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
Thanks in advance.
|
|
|
|
|
|
| Re: Apply Patches on Oracle Database with Logical Standby Database [message #504315 is a reply to message #504301] |
Sat, 23 April 2011 09:49  |
|
dbnewbie
Messages: 2
Registered: April 2011
|
Junior Member |
|
|
Thanks John.
Actually I did read the following article:
12 Using SQL Apply to Upgrade the Oracle Database
(12.5 Performing a Rolling Upgrade With an Existing Logical Standby Database)
I planned to make the name server pointing to the upgraded logcial standby databse, rather than following the steps 4 to 8 (SwitchOver) suggested in article.What I did worry about is whether there is any negative impact of not doing so.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
