data guard ADG小补丁应用

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

posted on 2017-07-26 17:58  #东来# 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/airport/p/7241112.html