cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 11g patch upgrade

Former Member
0 Kudos
105

Hello All,

We have some query regarding oracle 11.2.0.2 to 11.2.0.4 patch upgrade on Production.

Production environment can you please suggest how we can upgrade Rolling Database on DR side for reducing downtime.





Regards,

Gurpal

Accepted Solutions (0)

Answers (1)

Answers (1)

ACE-SAP
Active Contributor
0 Kudos

Hi

As you are in 11.2.0.2 you could use out-of-place patching that is available as of that version.

The problem is that SAP only supports it as of 11.2.0.3 as stated in the here under note.

1696869 - Patching of Oracle Homes with Minimal Downtime

How To Perform Out Of Place Patching To Minimize DB Downtime (Doc ID 1389364.1)

Regards

Former Member
0 Kudos

Hi Yuves,

Thanks for your reply.

Our Production environment is configured with oracle data guard (Physical standby) Because if we do normal upgrade process we need to re create the DR system from the backup of the primary system

on standby database the downtime will be increase.

Is there any additional steps for special upgrade with data guard?

Regards,

Gurpal

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Gurpal,

Refer below link it will may helpful.

Data Guard Concepts and Administration - Contents

Thanks & Regards,

V Srinivasan

Reagan
Product and Topic Expert
Product and Topic Expert
0 Kudos

You do not need to recreate the standby instead you can apply the offline redologs created during the primary upgrade on the standby database to get it upgraded as well.

Former Member
0 Kudos

we don`t have test system do actually we have raised message with SAP they said it is in under testing start upgrade activity as normal upgrade.

If we go with normal process then need to re-setup the DR also our downtime will be increase.

Regards,

Gurpal