[Oracle] ADG环境如何打PSU补丁？

1.主库停止日志传输。
2.关闭备库，备库应用补丁程序，备库启动mount，不开启日志应用。
3.关闭主库，主库应用补丁程序。
4.开启主库，开启日志传输。
5.备库开启日志应用。
6.执行检查，确保补丁安装成功。

##如果已配置DG Broker
dgmgrl sys/oracle@orcl
edit database orcl set state='LOG-TRANSPORT-OFF';

##未配置DG Broker
SQL> alter system set log_archive_dest_state_2=defer scope=both sid='*';

2.关闭备库，备库应用补丁程序，备库启动mount，不开启日志应用。

##Non-rac
shutdown immediate
lsnrctl stop
 
##rac
srvctl stop database -d orcl
srvctl stop listener
srvctl stop scan_listner

cd /u01/app/oracle/product/11.2.0/db/
mv OPatch/ OPatch0421
unzip -q /soft/p6880880_112000_Linux-x86-64.zip
opatch version

unzip -q p31537677_112040_Linux-x86-64.zip
cd 31537677 
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply

##已配置DG Broker，需要设置APPLY-OFF防止自动开启日志应用
edit database orcl_stby set state='APPLY-OFF';
##Non-rac
startup mount
lsnrctl start
##rac
srvctl start database -d orcl -o mount
srvctl start listener
srvctl start scan_listener

4.开启主库，开启日志传输。

--执行catbundle脚本
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@catbundle.sql psu apply
--编译无效对象
@utlrp.sql
--执行dbms_java_dev脚本
@dbmsjdev.sql
exec dbms_java_dev.disable

edit database orcl set state='ONLINE';

##已配置DG Broker，打开apply-on
edit database orcl_stby set state='ONLINE';
##备库开启到read only，开启ADG
alter database open;

6.执行检查，确保补丁安装成功。

opatch lspatches
select action_time,action,version,id,bundle_series,comments from dba_registry_history;

opatch lspatches
select action_time,action,version,id,bundle_series,comments from dba_registry_history;

##已配置DG Broker
show database orcl
show database orcl_stby
##未配置DG Broker
select process,group#,thread#,sequence# from v$managed_standby;
select group#,thread#,sequence#,bytes/1024/1024,archived,status from v$standby_log;