data guard ADG小补丁应用

1、备库停止应用日志
Bimse备库上执行：
物理standby停止应用日志

alter database recover managed standby database cancel;
关闭备库
shutdown immediate

2、备库应用补丁
bimse从库上操行：
检查是否会和以前的补丁集冲突

$ cd <PATCH_TOP_DIR>/22241601
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

$ $ORACLE_HOME/OPatch/opatch lsinventory
$ unzip -d <PATCH_TOP_DIR> p22241601_112047_SOLARIS64.zip
$ cd <PATCH_TOP_DIR>/22241601
$ $ORACLE_HOME/OPatch/opatch apply
$ $ORACLE_HOME/OPatch/opatch lsinventory
启动备库:
SQL> startup

3、主库应用补丁
关闭主库
在bimsd主机执行

shutdown immediate
检查是否会和以前的补丁集冲突
$ cd <PATCH_TOP_DIR>/22241601
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

应用补丁:
Bimsd主库上操行：

$ $ORACLE_HOME/OPatch/opatch lsinventory
$ unzip -d <PATCH_TOP_DIR> p22241601_112047_SOLARIS64.zip
$ cd <PATCH_TOP_DIR>/22241601
$ $ORACLE_HOME/OPatch/opatch apply
$ $ORACLE_HOME/OPatch/opatch lsinventory
启动主库:
SQL> startup

4、备库启动日志实时应用
bimse从库上执行：

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

5、检查主备库状态

主库上查询：
SQL> select status ,gap_status from v$archive_dest_status where dest_id in (1,2);

STATUS    GAP_STATUS
--------- ------------------------
VALID
VALID     NO GAP
SQL> select switchover_status from v$database;

从库信息：
SQL> select status,gap_status from v$archive_dest_status where dest_id in (1,2);

STATUS    GAP_STATUS
--------- ------------------------
VALID
VALID     NO GAP
检查主备库日志序列是否一致
在主备库执行
select max(Sequence#) from v$log;
archive log list