I did a rolling upgrade a few years ago (without the GI part), going from
10gR2 to 11gR1. The main doc I used at the time was:
http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-transrollupg-168590.pdf
If memory serves, the main caveats were:
- making sure that the versions upgrading between, any new OS, etc are all
supported for this [note 1085687.1]
- making sure there weren't data type issues for the logical conversion [
http://docs.oracle.com/cd/B28359_01/server.111/b28294/data_support.htm#CHDGFADJ
]
- having a solid back out plan in place should something fail mid-process
(and making sure that any surprise issues the upgrading db hits doesn't
mess up the current primary).
Other than that, the main doc is very detailed and with it, it was the
relatively standard upgrade process of a lot of documentation review and
testing.
On Sat, May 9, 2015 at 8:57 AM, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Hi Experts
Has anyone use Oracle Primary- Physical Standby Environment to upgrade
Oracle from old to newer version ? Point is to check the environment where
direct upgrade is available. I know that Oracle documentation has something
like the following but want to check if someone has really used it and
working or has seen any issue. Objective is to have least downtime.
1. ASM based single node Primary and Physical Standby environment
2. Upgrade GI on Standby server to newer version
3. Convert Physical Standby to Logical
4. Upgrade Database to newer version
5. Switchover from Primary to Logical Standby Server
6. Upgrade old Primary and current Logical Standby now
7. Switchover again and Live to old Server but now upgraded
This is Approach I summarised as per Oracle ducumentation and want to see
as if someone can share real practical experience or has some good Docs or
URL to see all steps or what are the restriction that can block this plan
as it involves Logical Standby or so.
TIA
Sanay
