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