Upgrade Primary database and Standby will be upgraded automatically
Pre-Checks
|
Check no Nologging operation has
been performed or Tablespace is offline.
|
|
Software and New Listener
|
Install new Software i.e new $ORACLE_HOME
|
|
Copy files to the New $ORACLE_HOME
: SPFILE file, orapwd, tnsnames.ora and listener.ora
|
||
In Primary ans Standby , Start
Listener FROM THE NEW $ORACLE_HOME
|
||
StandBy DB from new Software
|
Stop the Standby DB
|
|
Modify oratab of Standby DB to point
to new ORACLE_HOME
|
||
Startup mount the Standby DB
|
||
Start recover managed Standby
Database
|
||
Upgrade
|
||
Now upgrade Primary database
|
||
When the primary is upgraded, the
physical standby is automatically
upgraded as wel
|
Upgrade with converting to Transient Logical Standby and physru script
Pre checks
|
Enable
flashback database in Primary and
Standby
|
Run 1
|
./physru
sys databaseA databaseB databaseA
databaseB 11.2.0.2.0
It create restore point in Standby DB(Restorept_DataB) and Create backup ControlFile It create restore point in Primary DB(Restorept_DataA) and Create backup ControlFile Convert DatabaseB to Logical Standby keeping the DBID same Database A : Now Primary : Running on old Software Database B : Now Logical : Running on old Software |
Manual
Step : Startup Upgrade DatabaseB with
the new software
Install new Software i.e new $ORACLE_HOME Copy files to the New $ORACLE_HOME : SPFILE file, orapwd, tnsnames.ora and listener.ora In Primary ans Standby , Start Listener FROM THE NEW $ORACLE_HOME (NoT Required) SQL> startup upgrade; SQL> @?/rdbms/admin/catupgrd ; exit; SQL> startup; SQL> @?/rdbms/admin/utlrp Database A : Now Primary : Running on old Software Database B : Now Logical : Running on new Software |
|
Run 2
|
./physru
sys databaseA databaseB databaseA
databaseB 11.2.0.2.0
Makes DatabaseA as logical standby Makes DatabaseB as Primary Shutdown , Mount DatabaseA; Flashback to Restorept_DataA; and Convert DatabaseA to physical Standby and shutdowns Database A : Now Physical: Running on old Software Database B : Now Primary : Running on new Software Manual Step : Startup Mount DatabaseA with the new software Database A : Now Physical : Running on new Software Database B : Now Primary : Running on new Software |
Run 3
|
./physru
sys databaseA databaseB databaseA
databaseB 11.2.0.2.0
Apply redo changes to Database A received from from Database B Perform switcover again Database A : Now Primary : Running on new Software Database B : Now Physical : Running on new Software |
