High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

utilize standby for rollback of an upgrade ?

Greetings!

we have physical standby database in place and an upgrade of production from 10201 to 11204 is to do.

I think we can utilize standby database in case if we need to rollback the production database upgrade due to any unforeseen issue .... the idea is to sync standby and shutdown the production and standby both. then apply patchset4 (10g) and upgrade database to 11204 but only at production database without touching the standby database and after upgrade completes rebuild standby at 11204 level.

If It is required we can initiate failover to standby database and rebuild new standby at 10201 level and plan for the upgrade on-wards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center