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 downSQL> 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], [], [], [], [], []