What is the recommanded procedure to upgrade Primary and Standby Databases in Data Guard:
edited Sep 1, 2011 12:57AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 7 commentsAnswered
What is the recommanded procedure to upgrade/patch Primary and Standby Databases in Data Guard:
We have following Data Gurad configuration
ORATST - Primary Database on host1
ORAPSD - Physical Standby Database on host2
We have upgraded theses databases from 11.1.0.6.0 to 11.1.0.7.0 as follows:
PRIMARY DATABASE1. Downloaded the patch for 11.1.0.7.0
2. Shutdown Database ORATST
3. Shutdown oraacle windows services
4. Installed the patch
5. Started windows services
6. Started database ORATS
7. Upgraded the database as follows:
STARTUP UPGRADE;
STARTUP;
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql
PHYSICAL STANDBY DATABASE1. Shutdown Database ORAPSD
2. Shutdown oraacle windows services
0