19 July 2019

Some notes on upgrade - with physical standby in place

These are just quick & dirty steps for upgrade, with a physical standby in place. Use them with caution, at your own risk. Also, consult the Oracle documentation and Mike Dietrich's input for upgrade.

Move listener

cp sqlnet.ora, tnsnames.ora en listener.ora  to newhome/network/admin
stop listener on the old home
set environment variable $ORACLE_HOME for the new home
start the listener on the new home

Stop broker

disable broker config (dgmgrl > disable configuration)
set  dg_broker_start=false  on both primary and standby

Get ready


shutdown immediate primary
shutdown immediate standby
change  /etc/oratab on both primary and standby host
cp the spfile and orapw to the newhome/dbs
startup mount the standby (from the new home)
startup upgrade the primary (from the new home)
[or startup the primary on the old home, which should work as well when using dbua]

change the listener.ora on both nodes for the new oracle_home
reload the listeners

Upgrade

run dbua on the primary
(during the upgrade, you can run on the standby RMAN>recover database to make some progress. You can do this a few times)

After upgrade

cp the dr*.dat broker files to the newhome/dbs folder
set (2x) dg_broker_start=true
enable de broker config
check if logswitches get applied

No comments:

Post a Comment