DG error：【ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []】 + 【FAL[client]: Failed to request gap sequence】
问题如题所示，具体如下：
在DG的备库端的Alert日志中看到：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
2018-06-30T09:10:35.167899+08:00 Media Recovery Log /home/app/oracle/arch_log/1_105_972571706.dbf Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc (incident=38786) (PDBNAME=CDB$ROOT): ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], [] Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38786/orcl_pr00_8582_i38786.trc 2018-06-30T09:10:38.251473+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2018-06-30T09:10:38.251783+08:00 Errors with log /home/app/oracle/arch_log/1_105_972571706.dbf MRP0: Background Media Recovery terminated with error 600 2018-06-30T09:10:38.252159+08:00 Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc: ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], [] Managed Standby Recovery not using Real Time Apply Recovery interrupted! 2018-06-30T09:10:38.421449+08:00 Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr00_8582.trc: ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], [] 2018-06-30T09:10:38.551930+08:00 Errors in file /home/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mrp0_8576.trc (incident=38466) (PDBNAME=CDB$ROOT): ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], [] ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave ORA-10877: error signaled in parallel recovery slave Incident details in: /home/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_38466/orcl_mrp0_8576_i38466.trc 2018-06-30T09:10:38.658930+08:00 Dumping diagnostic data in directory=[cdmp_20180630091038], requested by (instance=1, osid=8582 (PR00)), summary=[incident=38786]. 2018-06-30T09:10:39.594280+08:00 Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. 2018-06-30T09:10:39.594558+08:00 MRP0: Background Media Recovery process shutdown (orcl) |
检查DG备库端状态：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 |
[oracle@oracleme ~]$ sh check_dg_2.sh orcl SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 30 09:28:53 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> INSTANCE_NAME STATUS -------------------------------- ------------------------ orcl MOUNTED SQL> NAME DATABASE_ROLE ------------------ -------------------------------- OPEN_MODE ---------------------------------------- ORCL PHYSICAL STANDBY MOUNTED SQL> THREAD# Sequence ---------- ---------- 1 104 SQL> COUNT(*) ---------- 11 SQL> NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ spfile string /home/app/oracle/12c/release_2 /db_1/dbs/spfileorcl.ora SQL> NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ control_files string /home/app/oracle/oradata/ORCL/ controlfile/o1_mf_fd8x9qp0_.ct l, /home/app/oracle/fast_recov ery_area/orcl/ORCL/controlfile /o1_mf_fd8x9qwm_.ctl SQL> NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ background_core_dump string partial background_dump_dest string /home/app/oracle/12c/release_2 /db_1/rdbms/log SQL> NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ local_listener string LISTENER_ORCL SQL> SQL> Summary Size of GB ------------------ 3.97949219 SQL> SQL> SQL> SQL> PROCESS PID CLIENT_PID STATUS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS ------------------ ------------------------------------------------ -------------------- ------------------------ ---------- ------------ ------------- ARCH 8331 8331 CONNECTED 0 0 0 ARCH 8341 8341 CONNECTED 0 0 0 ARCH 8339 8339 CLOSING 0 0 0 ARCH 8337 8337 CONNECTED 0 0 0 DGRD 8335 N/A ALLOCATED 0 0 0 DGRD 8333 N/A ALLOCATED 0 0 0 RFS 8357 2314 IDLE 0 0 0 RFS 8360 2312 IDLE 0 0 0 RFS 8350 2304 IDLE 0 0 0 RFS 8355 2310 IDLE 0 0 0 RFS 8364 2322 IDLE 0 0 0 11 rows selected. SQL> SQL> SQL> SQL> NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- -------------------------------------- -------------------------------------- ------------------ /home/app/oracle/arch_log/1_99_972571706.dbf 1 99 2018-05-30 14:28:49 2018-05-30 14:29:10 YES /home/app/oracle/arch_log/1_100_972571706.dbf 1 100 2018-05-30 14:29:10 2018-05-30 14:36:53 YES /home/app/oracle/arch_log/1_101_972571706.dbf 1 101 2018-05-30 14:36:53 2018-05-30 14:36:54 YES /home/app/oracle/arch_log/1_102_972571706.dbf 1 102 2018-05-30 14:36:54 2018-05-30 14:48:59 YES /home/app/oracle/arch_log/1_103_972571706.dbf 1 103 2018-05-30 14:48:59 2018-05-30 14:49:58 YES /home/app/oracle/arch_log/1_104_972571706.dbf 1 104 2018-05-30 14:49:58 2018-05-30 14:50:00 YES /home/app/oracle/arch_log/1_105_972571706.dbf 1 105 2018-05-30 14:50:00 2018-05-30 22:01:03 NO /home/app/oracle/arch_log/1_106_972571706.dbf 1 106 2018-05-30 22:01:03 2018-05-31 03:49:16 NO /home/app/oracle/arch_log/1_107_972571706.dbf 1 107 2018-05-31 03:49:16 2018-05-31 23:01:49 NO /home/app/oracle/arch_log/1_108_972571706.dbf 1 108 2018-05-31 23:01:49 2018-06-01 06:06:06 NO /home/app/oracle/arch_log/1_109_972571706.dbf 1 109 2018-06-01 06:06:06 2018-06-01 23:13:36 NO NAME THREAD# SEQUENCE# First Next APPLIED ----------------------------------------------------------------- ---------- ---------- -------------------------------------- -------------------------------------- ------------------ /home/app/oracle/arch_log/1_110_972571706.dbf 1 110 2018-06-01 23:13:36 2018-06-02 07:00:09 NO /home/app/oracle/arch_log/1_111_972571706.dbf 1 111 2018-06-02 07:00:09 2018-06-02 12:34:46 NO /home/app/oracle/arch_log/1_112_972571706.dbf 1 112 2018-06-02 12:34:46 2018-06-02 19:30:25 NO /home/app/oracle/arch_log/1_113_972571706.dbf 1 113 2018-06-02 19:30:25 2018-06-02 23:15:51 NO 15 rows selected. SQL> SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@oracleme ~]$ |
可以看到DG的应用（MRP）已经停止。
查看与DG有[……]
- Posted on:
-
Author:
Adamhuan
- Categories: Oracle Dataguard
- Tags: [], [105], arguments: [2619], CONTROL_FILE_RECORD_KEEP_TIME, Data Guard, DG, error, FAL[client]: Failed to request gap sequence, Linux, ora-00600, ORA-00600: internal error code, Oracle, 错误
- Leave a comment: DG error：【ORA-00600: internal error code, arguments: [2619], [105], [], [], [], [], [], [], [], [], [], []】 + 【FAL[client]: Failed to request gap sequence】
