Bimse备库上执行:
物理standby停止应用日志
点击(此处)折叠或打开
- alter database recover managed standby database cancel;
- 关闭备库
-
shutdown immediate
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
关闭主库
在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
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
点击(此处)折叠或打开
-
主库上查询:
-
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