通过dblink连接10.2.0.1(未打补丁)scn同步

A库11204

B库10201

A库创建dblink连接B库

A库scn


SQL> select current_scn from v$database;

CURRENT_SCN
----------------------------------------

1901084

B库scn

SQL> select current_scn from v$database;

CURRENT_SCN
----------------------------------------

562370

A库通过dblink查询B库时发现,B库scn被同步

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    1901124

查询B库最大合理scn

SQL> col scn for 999,999,999,999,999,999
SQL> select 
  2  (
  3      (
  4          (
  5              (
  6                  (   
  7                      (
  8                          to_char(sysdate,'YYYY')-1988
  9                      )*12+
 10                  to_char(sysdate,'mm')-1
 11                  )*31+to_char(sysdate,'dd')-1
 12              )*24+to_char(sysdate,'hh24')
 13          )*60+to_char(sysdate,'mi')
 14      )*60+to_char(sysdate,'ss')
 15  ) * to_number('ffff','XXXXXXXX')/4 scn
 16  from dual
 17  /

                     SCN
------------------------
      16,651,134,159,851

将A库scn推进超过B库最大合理scn

SQL> shutdown abort
ORACLE instance shut down

SQL> startup mount
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size                  2257880 bytes
Variable Size             608177192 bytes
Database Buffers          226492416 bytes
Redo Buffers                2355200 bytes
Database mounted.
SQL> oradebug setmypid
Statement processed.
SQL>  oradebug poke 0x06001AE70 8 19651149004711
BEFORE: [06001AE70, 06001AE78) = 00000000 00000000
AFTER:  [06001AE70, 06001AE78) = 63C17FA7 000011DF
SQL> alter database open;

A库通过dblink连接B库


SQL> select * from dual@rac10;
select * from dual@rac10
                   *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ORA-00600: internal error code,
arguments: [2252], [4575], [1673625860], [], [], [], [], []
], [], [], [], [], [], [], [], [], [], [], []
ORA-02063: preceding line from RAC10

A库alert

Wed Aug 14 23:24:31 2019
Errors in file /u01/app/oracle/diag/rdbms/rac11/RAC111/trace/RAC111_ora_12684.trc  (incident=66258):
ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [2252], [4575], [1673625867], [], [], [], [], []
], [], [], [], [], [], [], [], [], [], [], []
ORA-02063: preceding line from RAC10
Incident details in: /u01/app/oracle/diag/rdbms/rac11/RAC111/incident/incdir_66258/RAC111_ora_12684_i66258.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

B库alert

Wed Aug 14 23:24:07 2019
Errors in file /u01/app/oracle/admin/rac10/udump/rac10_ora_3016.trc:
ORA-00600: internal error code, arguments: [2252], [4575], [1673625860], [], [], [], [], []

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值