Install patchset 10.2.0.4 with pysical Standby (data guard)
I searched some time to find the documentation which tell how to install a patch on a data guard configuration with a pysical standby.
You need this tow pieces of infomation:
- http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rollup.htm#i1029537
- Metalink Doc ID: 278641.1
My short summary for 10.2.0.3 to 10.2.0.4 upgrade:
1. primary: shutdown immedaite
2. primary: lsnrctl stop
3. standby: recover managed standby database cancel;
4. standby: shutdown immediate
5. standby: lsnrctl stop
6. primary: opatch apply
7. standby: opatch apply
8. standby: starup mount
9. standby: recover managed standby database nodelay disconnect;
10. primary: startup upgrade
11. primary: check log shipping, v$archive_dest.status
12. primary: alter system archive log current;
13. primary: select dest_id, status from v$archive_dest;
14. primary:
# disconnect & reconnet
SPOOL upgrade_info.log
@?/rdbms/admin/utlu102i.sql
SPOOL OFF
SPOOL patch.log
@?/rdbms/admin/catupgrd.sql
SPOOL OFF
SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
15. alter system archive log current;
16. primary: shutdown / startup
17. standby: select max(sequence#) from v$log_history; — check recovery works