Bo's Oracle Station

【博客文章2013】逻辑standby由于找不到回收站对象,而使得apply中断

2016-5-13 11:15| 发布者: admin| 查看: 2045| 评论: 0|原作者: Bo Tang

摘要: 逻辑standby由于找不到回收站对象,而使得apply中断。

Oracle技术分享4:逻辑standby由于找不到回收站对象,而使得apply中断


Author: Bo Tang




1.
Stop SQL Apply:
SQL> ALTER DATABASE STOP LOGICAL STANDBY APPLY;
2.
Register the SKIP rules:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP (stmt => 'DML', schema_name => 'HR', -
object_name => 'EMPLOYEES', proc_name => null);
SQL> EXECUTE DBMS_LOGSTDBY.SKIP (stmt => 'SCHEMA_DDL', schema_name => 'HR', -
object_name => 'EMPLOYEES', proc_name => null);
3.
Start SQL Apply:
SQL> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
2

路过

雷人

握手

鲜花

鸡蛋

刚表态过的朋友 (2 人)

QQ|手机版|Bo's Oracle Station   

GMT+8, 2022-3-22 16:44 , Processed in 0.038878 second(s), 21 queries .

返回顶部