YET ANOTHER ORACLE DBA

Focus on Oracle DBA (Core/Apps/Fusion) stuffs

Posts Tagged ‘11gR1 and higher’

Database Rolling Upgrade Shell Script from Oracle called physru

Posted by Jay on August 3, 2011

The script can be downloaded from MOS note # 949322.1 as the script could get updated regularly

The Bourne shell script, called physru, performs a physical standby rolling upgrade for Oracle RDBMS versions 11gR1 and higher. A physical standby rolling upgrade typically involves numerous SQL operations and validations. The physru script greatly reduces the number of steps, leaving the following remaining steps for the user:

1. Calling DBUA or catupgrd.sql to upgrade the standby database.

2. Starting the upgraded standby database in the new Oracle home.

3. Starting the former primary database in the new Oracle home.

4. Starting and stopping RAC instances.

5. Disabling and enabling of RAC. Read the rest of this entry »

Posted in Database, Features | Tagged: , , , , | Leave a Comment »