【故障解決】OGG-00446 錯誤解決
【故障解決】OGG-00446 Could not find archived log for sequence
一.1 BLOG文件結構圖
一.2 前言部分
一.2.1 導讀和注意事項
各位技術愛好者，看完本文後，你可以掌握如下的技能，也可以學到一些其它你所不知道的知識，~O(∩_∩)O~：
① OGG-00446 Could not find archived log for sequence 的解決方法（重點）
② OGG基本的維護、排錯操作
Tips：
① 若文章程式碼格式有錯亂，推薦使用QQ或360瀏覽器，也可以下載pdf格式的文件來檢視，pdf文件下載地址：http://yunpan.cn/cdEQedhCs2kFz? （提取碼：ed9b）
② 本篇BLOG中程式碼部分需要特別關注的地方我都用黃色背景和紅色字型來表示，比如下邊的例子中，thread 1的最大歸檔日誌號為33，thread 2的最大歸檔日誌號為43是需要特別關注的地方，命令一般使用粉紅顏色標註，註釋一般採用藍色字型表示。
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48
1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58
2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49
2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53
[ZFXDESKDB1:root]:/>lsvg -o
T_XDESK_APP1_vg
rootvg
[ZFXDESKDB1:root]:/>
[ZFXDESKDB1:root]:/>lsvg rootvg
====》2097152*512/1024/1024/1024=1G
本文如有錯誤或不完善的地方請大家多多指正，ITPUB留言或QQ皆可，您的批評指正是我寫作的最大動力。
一.2.2 相關參考文章連結
一.2.3 本文簡介
同事說有一套OGG的環境掛掉了，不能同步了，讓處理一下，檢視了程式狀態和錯誤日誌後分析得出是source端的歸檔日誌不見了，也沒有備份，最後只能重新初始化資料來解決了。
一.3 相關知識點掃盲
一.3.1 OGG的告警日誌路徑
ogg也有類似oracle的告警檔案，該檔案在 $OGG_HOME/ggserr.log
oracle@ZT1XPADRDB1:/gg/ogg$ l ggserr.log
-rw-rw-r-- 1 oracle dba 81355509 Jul 25 2025 ggserr.log
oracle@ZT1XPADRDB1:/gg/ogg$
一.4 故障分析及解決過程
一.4.1 故障環境介紹
| 專案 | source db | target db |
| db 型別 | rac環境 | rac環境 |
| db version | 10.2.0.5.0 | 11.2.0.3.0 |
| db 儲存 | RAW | ASM |
| ORACLE_SID | oraXPAD | oraXPAD |
| db_name | oraXPAD | oraXPAD |
| 主機IP地址： | 22.188.131.27 22.188.131.47 | 22.188.132.82 22.188.132.85 |
| OS版本及kernel版本 | AIX 5.3 | AIX 6.1 |
| OS hostname | ZTGXPADDB1 | ZT1XPADRDB1 |
一.4.2 故障發生現象及報錯資訊
source 端：
root@ZTGXPADDB1:/# ps -ef|grep gg
root 3248278 3211312 1 09:15:45 pts/0 0:00 grep gg
oracle 3719330 3751980 1 Dec 30 - 7:29 /gg/ogg/extract PARAMFILE /gg/ogg/dirprm/ggspump.prm REPORTFILE /gg/ogg/dirrpt/GGSPUMP.rpt PROCESSID GGSPUMP USESUBDIRS
oracle 3723472 3706978 0 Aug 03 - 0:03 /oracle/app/oracle/product/10.2.0/crs/bin/evmlogger.bin -o /oracle/app/oracle/product/10.2.0/crs/evm/log/evmlogger.info -l /oracle/app/oracle/product/10.2.0/crs/evm/log/evmlogger.log
oracle 3751980 1 0 Aug 03 - 21:00 ./mgr PARAMFILE /gg/ogg/dirprm/mgr.prm REPORTFILE /gg/ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
oracle 3772504 3751980 3 Dec 30 - 18:42 /gg/ogg/extract PARAMFILE /gg/ogg/dirprm/ggsext.prm REPORTFILE /gg/ogg/dirrpt/GGSEXT.rpt PROCESSID GGSEXT USESUBDIRS
root@ZTGXPADDB1:/# cd /gg/ogg/
oracle@ZTHXPADDB2:/gg/ogg$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Oct 5 2011 02:32:51
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ZTHXPADDB2) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED GGSEXT 00:00:00 21915:44:49
EXTRACT RUNNING GGSPUMP 00:00:00 unknown
GGSCI (ZTHXPADDB2) 5> view report GGSEXT
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Oct 5 2011 02:52:14
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2020-08-03 07:47:21
***********************************************************************
Operating System Version:
AIX
Version 5, Release 3
Node: ZTGXPADDB1
Machine: 00C207D44C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 2113596
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT ggsext
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID="oraXPAD1")
Set environment variable (ORACLE_SID=oraXPAD1)
USERID goldengate, PASSWORD **********
DISCARDFILE ./dirrpt/ggsext.dsc, APPEND, MEGABYTES 100
--DDL INCLUDE MAPPED
--DDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORT
TRANLOGOPTIONS RAWDEVICEOFFSET 0
EXTTRAIL ./dirdat/st
TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY INSTANCE oraXPAD1 /gg/sarch1, ALTARCHIVELOGDEST INSTANCE oraXPAD1 /gg/sarch2, ALTARCHIVELOGDEST INSTANCE oraXPAD2 /gg/sarch2, ALTARCHIVELOGDEST INSTANCE oraXPAD2 /gg/sarch1
--TRANLOGOPTIONS ALTARCHIVELOGDEST PRIMARY INSTANCE oraXPAD1 /gg/sarch1, ALTARCHIVELOGDEST INSTANCE oraXPAD2 /gg/sarch2
WILDCARDRESOLVE DYNAMIC
dynamicresolution
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000
--GETTRUNCATES
TABLE XPADB.BASE_ACTIONPOWER;
TABLE XPADB.BASE_BANK;
TABLE XPADB.BASE_BANKMERGE;
TABLE XPADB.BASE_BANKTREE;
TABLE XPADB.BASE_BRCHBANKCTRL;
TABLE XPADB.BASE_CERTIFICATE;
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
TABLE XPADB.RICH_TRANSFERTRADE;
TABLE XPADB.RICH_LISTING;
TABLE XPADB.RICH_DELISTING;
TABLE XPADB.RICH_CUSTPROOFPROPERTY;
TABLE XPADB.BASE_FEESCALE;
TABLE XPADB.BASE_FEEDISCOUNT;
TABLE t.t2;
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /gg/ogg
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
2020-08-03 07:47:22 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 1: p1916948_Redo Thread 1.
2020-08-03 07:47:22 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.
2020-08-03 07:47:22 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 2598, RBA: 89822224, SCN: 2850.524344649 (12241181138249), Timestamp: 2018-07-01 04:09:42.000000.
2020-08-03 07:47:22 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 2598, RBA: 89823232, SCN: 2850.524344649 (12241181138249), Timestamp: 2018-07-01 04:09:42.000000.
2020-08-03 07:47:22 INFO OGG-01639 BOUNDED RECOVERY: ACTIVE: for object pool 2: p1916948_Redo Thread 2.
2020-08-03 07:47:22 INFO OGG-01640 BOUNDED RECOVERY: recovery start XID: 0.0.0.
2020-08-03 07:47:22 INFO OGG-01641 BOUNDED RECOVERY: recovery start position: SeqNo: 2382, RBA: 245488144, SCN: 2850.524344719 (12241181138319), Timestamp: 2018-07-01 04:09:41.000000.
2020-08-03 07:47:22 INFO OGG-01642 BOUNDED RECOVERY: recovery end position: SeqNo: 2382, RBA: 245489152, SCN: 2850.524344719 (12241181138319), Timestamp: 2018-07-01 04:09:41.000000.
2020-08-03 07:47:22 INFO OGG-01643 BOUNDED RECOVERY: CANCELED: for object pool 2: p1916948_Redo Thread 2.
2020-08-03 07:47:22 INFO OGG-01579 BOUNDED RECOVERY: VALID BCP: CP.GGSEXT.000000102.
2020-08-03 07:47:22 INFO OGG-01629 BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: 1.
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
2020-08-03 07:47:24 INFO OGG-00546 Default thread stack size: 196608.
2020-08-03 07:47:24 INFO OGG-00547 Increasing thread stack size from 196608 to 1048576.
2020-08-03 07:47:24 INFO OGG-01513 Positioning to (Thread 1) Sequence 2598, RBA 89822224, SCN 2850.524344649.
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/aime2/adestore/views/aime2_staxk11/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [extract_start_point(time_elt_def *, time_elt_def *)]
SourceLine : [13026]
2020-08-03 07:47:44 ERROR OGG-00446 Could not find archived log for sequence 2598 thread 1 under alternative destinations. SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>. Last alternative log tried /gg/sarch2/1_2598_704996932.arc, error retrieving redo file name for sequence 2598, archived = 1, use_alternate = 0Not able to establish initial position for sequence 2598, rba 89822224.
2020-08-03 07:47:44 ERROR OGG-01668 PROCESS ABENDING.
source端告警日誌：
oracle@ZT1XPADRDB1:/gg/ogg$ tail -f ggserr.log
2020-08-03 07:47:27 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ggspump.prm: Socket buffer size set to 27985 (flush size 27985).
2020-08-03 07:47:27 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery initialization completed for target file ./dirdat/tt002073, at RBA 1153.
2020-08-03 07:47:27 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ggspump.prm: Output file ./dirdat/tt is using format RELEASE 10.4/11.1.
2020-08-03 07:47:27 INFO OGG-01026 Oracle GoldenGate Capture for Oracle, ggspump.prm: Rolling over remote file ./dirdat/tt002074.
2020-08-03 07:47:27 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery completed for target file ./dirdat/tt002074, at RBA 1119.
2020-08-03 07:47:27 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ggspump.prm: Recovery completed for all targets.
2020-08-03 07:47:44 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ggsext.prm: Could not find archived log for sequence 2598 thread 1 under alternative destinations. SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>. Last alternative log tried /gg/sarch2/1_2598_704996932.arc, error retrieving redo file name for sequence 2598, archived = 1, use_alternate = 0Not able to establish initial position for sequence 2598, rba 89822224.
2020-08-03 07:47:44 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ggsext.prm: PROCESS ABENDING.
2020-12-29 15:37:48 ERROR OGG-01117 Oracle GoldenGate Command Interpreter for Oracle: Received signal: Program interrupt (2).
2020-12-29 15:37:48 ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.
target 端：
oracle@ZT1XPADRDB1:/gg/ogg$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Oct 5 2011 00:37:03
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ZT1XPADRDB1) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED GGSREP 30088:08:59 3577:00:35
GGSCI (ZT1XPADRDB1) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED GGSREP 30088:08:59 3577:47:23
GGSCI (ZT1XPADRDB1) 5> start GGSREP
Sending START request to MANAGER ...
REPLICAT GGSREP starting
GGSCI (ZT1XPADRDB1) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED GGSREP 33665:56:32 00:03:08
GGSCI (ZT1XPADRDB1) 8> view report GGSREP
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
AIX 5L, ppc, 64bit (optimized), Oracle 11g on Oct 5 2011 02:03:36
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2020-12-30 09:34:14
***********************************************************************
Operating System Version:
AIX
Version 6, Release 1
Node: ZT1XPADRDB1
Machine: 00C08DF04C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 35717358
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT ggsrep
--SETENV (ORACLE_SID = ggstd)
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID goldengate, PASSWORD **********
--DDL include MAPPED
--DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 RETRYDELAY 5
--DDLOPTIONS report
REPERROR DEFAULT, ABEND
ASSUMETARGETDEFS
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
--BATCHSQL
--GROUPTRANSOPS 2000
DISCARDFILE ./dirrpt/ggsrep.dsc, APPEND, MEGABYTES 1000
WILDCARDRESOLVE DYNAMIC
Dynamicresolution
ALLOWNOOPUPDATES
--GETTRUNCATES
MAP XPADB.*, TARGET XPADRPT.*;
--OGG test table
MAP t.*, TARGET tt.t*;
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
For further information on character set settings, please refer to user manual.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file ./dirdat/tt002032 at 2020-12-30 09:34:14
Wildcard MAP resolved (entry XPADB.*):
MAP XPADB.RICH_CUSTPAYAMOUNTHIS, TARGET XPADRPT.RICH_CUSTPAYAMOUNTHIS;
2020-12-30 09:34:14 WARNING OGG-00869 No unique key is defined for table RICH_CUSTPAYAMOUNTHIS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using following columns in default map by name:
SERIALNO, TRADENO, ACCOUNT, CUSTACCOUNT, ISSUEID, FLAG, BANKID,
EXECDATE, CURRENCYID, AMOUNT, BANCSNO, CASHREMIT, STATE, MEMO,
PAYEXRATE, RESEND, EXECMODE, TRANCODE, RESPONSECODE, DATEEXPIRATION,
TRADECHANNEL, TSNUMBER, FREEZESRLNO, EXPDATE, AMTTYPE, RELTRANTYPE,
PROMOCODE, RELSERIALNO
Using the following key columns for target table XPADRPT.RICH_CUSTPAYAMOUNTHIS: SERIALNO, TRADENO, ACCOUNT, CUSTACCOUNT, ISSUEID, FLAG, BANKID, EXECDATE, CURRENCYID, AMOUNT, BANCSNO, CASHREMIT, STATE, MEMO, PAYEXRATE, RESEND, EXECMODE, TRANCODE, RESPONSECODE, DATEEXPIRATION, TRADECHANNEL, TSNUMBER, FREEZESRLNO, EXPDATE, AMTTYPE, RELTRANTYPE, PROMOCODE, RELSERIALNO.
2020-12-30 09:34:14 WARNING OGG-01004 Aborted grouped transaction on 'XPADRPT.RICH_CUSTPAYAMOUNTHIS', Database error 1403 ().
2020-12-30 09:34:14 WARNING OGG-01003 Repositioning to rba 47143866 in seqno 2032.
2020-12-30 09:34:14 WARNING OGG-01154 SQL error 1403 mapping XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
2020-12-30 09:34:14 WARNING OGG-01003 Repositioning to rba 47143866 in seqno 2032.
Source Context :
SourceModule : [er.main]
SourceID : [/scratch/aime2/adestore/views/aime2_staxk11/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [take_rep_err_action(short, int32_t, const char *, extr_ptr_def *, std_rec_hdr_def *, char *, file_def *, bool)]
SourceLine : [16148]
2020-12-30 09:34:14 ERROR OGG-01296 Error mapping from XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name : ./dirdat/tt002032
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 854 (x0356) IO Time : 2017-02-26 15:37:42.331328
IOType : 115 (x73) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 2301 AuditPos : 568568848
Continued : N (x00) RecCount : 1 (x01)
2017-02-26 15:37:42.331328 GGSKeyFieldComp Len 854 RBA 47143866
Name: XPADB.RICH_CUSTPAYAMOUNTHIS
___________________________________________________________________
Reading ./dirdat/tt002032, current RBA 47143866, 0 records
Report at 2020-12-30 09:34:14 (activity since 2020-12-30 09:34:14)
From Table XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS:
# inserts: 0
# updates: 0
# deletes: 0
# discards: 1
Last log location read:
FILE: ./dirdat/tt002032
SEQNO: 2032
RBA: 47143866
TIMESTAMP: 2017-02-26 15:37:42.331328
EOF: NO
READERR: 0
2020-12-30 09:34:14 ERROR OGG-01668 PROCESS ABENDING.
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 512M cache force paging = 881M
buffer min = 64K buffer highwater = 4M
pageout eligible size = 4M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
================================================================================
CUMULATIVE STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
Cached Transaction Size Distribution
0: 0
< 4K: 0
4K: 0 0 | 16K: 0 0
64K: 0 0 | 256K: 0 0
1M: 0 0 | 4M: 0 0
16M: 0 0 | 64M: 0 0
256M: 0 0 | 1G: 0 0
4G: 0 0 | 16G: 0 0
64G: 0 0 | 256G: 0 0
1T: 0 0 | 4T: 0 0
16T: 0 0 | 64T: 0 0
256T: 0 0 |1024T: 0 0
QUEUE Statistics:
num queues = 15 default index = 0
cur len = 0 max len = 0
q vm current = 0 vm max = 0
q hits = 0 q misses = 0
queue size q hits curlen maxlen cannibalized
0 64K 0 0 0 0
1 128K 0 0 0 0
2 256K 0 0 0 0
3 512K 0 0 0 0
4 1M 0 0 0 0
5 2M 0 0 0 0
6 4M 0 0 0 0
7 8M 0 0 0 0
8 16M 0 0 0 0
9 32M 0 0 0 0
10 64M 0 0 0 0
11 128M 0 0 0 0
12 256M 0 0 0 0
13 512M 0 0 0 0
14 1G 0 0 0 0
================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO group: ggsrep id: p35717358_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
last error = (0=<none>)
Allocation Request Distribution
< 128B: 0
128B: 0 0 | 512B: 0 0
2K: 0 0 | 8K: 0 0
32K: 0 0 | 128K: 0 0
512K: 0 0 | 2M: 0 0
8M: 0 0 | 32M: 0 0
128M: 0 0 | 512M: 0 0
2G: 0 0 | 8G: 0
================================================================================
CUMULATIVE STATS FOR CACHE POOL #0
POOL INFO group: ggsrep id: p35717358_BLOB
trans active = 0 trans concurrent (max) = 0
trans total = 0 (0 )
flag = 0x00000030
target端告警日誌：
oracle@ZT1XPADRDB1:/gg/ogg$ tail -f ggserr.log
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.
2020-12-30 09:27:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.
2020-12-30 09:34:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start GGSREP.
2020-12-30 09:34:14 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 22.188.132.82 (START REPLICAT GGSREP ).
2020-12-30 09:34:14 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT GGSREP starting.
2020-12-30 09:34:14 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP starting.
2020-12-30 09:34:14 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP started.
2020-12-30 09:34:14 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: No unique key is defined for table RICH_CUSTPAYAMOUNTHIS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2020-12-30 09:34:14 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Aborted grouped transaction on 'XPADRPT.RICH_CUSTPAYAMOUNTHIS', Database error 1403 ().
2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.
2020-12-30 09:34:14 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: SQL error 1403 mapping XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.
2020-12-30 09:34:14 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Error mapping from XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
2020-12-30 09:34:14 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: PROCESS ABENDING.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.
2020-12-30 09:37:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.
一.4.3 故障分析及解決過程
一.4.3.1 確認歸檔檔案是否存在
根據報錯資訊，可以知道source端的thread 1 2598歸檔日誌不存在了，如果備份存在的話可以先把備份的歸檔還原回來就可以了，我們看看歸檔是否存在？
oracle@ZTHXPADDB2:/oracle$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 30 08:50:48 2020
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
SQL> set line 9999
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
1 1 2907 1072693248 1 NO CURRENT 1.2242E+13 30-DEC-20
2 1 2905 1072693248 1 YES INACTIVE 1.2242E+13 28-DEC-20
3 1 2906 1072693248 1 YES INACTIVE 1.2242E+13 29-DEC-20
4 2 2718 1072693248 1 YES INACTIVE 1.2242E+13 29-DEC-20
5 2 2719 1072693248 1 NO CURRENT 1.2242E+13 29-DEC-20
6 2 2717 1072693248 1 YES INACTIVE 1.2242E+13 28-DEC-20
6 rows selected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /gg/sarch2
Oldest online log sequence 2717
Next log sequence to archive 2719
Current log sequence 2719
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
oracle@ZTHXPADDB2:/oracle$ cd /gg/sarch2
oracle@ZTHXPADDB2:/gg/sarch2$ l
total 193332080
-rw-rw---- 1 oracle dba 1065581568 Mar 05 2020 2_2625_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Mar 06 2020 2_2626_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Mar 06 2020 2_2627_704996932.arc
-rw-rw---- 1 oracle dba 1065577472 Mar 07 2020 2_2628_704996932.arc
-rw-rw---- 1 oracle dba 1065568768 Mar 20 2020 2_2629_704996932.arc
-rw-rw---- 1 oracle dba 1065582592 Mar 21 2020 2_2630_704996932.arc
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
-rw-rw---- 1 oracle dba 1065574400 Dec 23 13:06 2_2707_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Dec 24 00:26 2_2708_704996932.arc
-rw-rw---- 1 oracle dba 1065574912 Dec 24 13:15 2_2709_704996932.arc
-rw-rw---- 1 oracle dba 1065744384 Dec 25 02:23 2_2710_704996932.arc
-rw-rw---- 1 oracle dba 1065566208 Dec 25 19:23 2_2711_704996932.arc
-rw-rw---- 1 oracle dba 1065576960 Dec 26 09:08 2_2712_704996932.arc
-rw-rw---- 1 oracle dba 1065627648 Dec 26 23:21 2_2713_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Dec 27 12:25 2_2714_704996932.arc
-rw-rw---- 1 oracle dba 1065691648 Dec 28 04:32 2_2715_704996932.arc
-rw-rw---- 1 oracle dba 1065658368 Dec 28 21:02 2_2716_704996932.arc
-rw-rw---- 1 oracle dba 1065575936 Dec 29 10:37 2_2717_704996932.arc
-rw-rw---- 1 oracle dba 1067223552 Dec 29 23:22 2_2718_704996932.arc
-rw-r--r-- 1 oracle dba 79 Jun 27 2013 afiedt.buf
oracle@ZTHXPADDB2:/gg/sarch2$ l *1_2598*
ls: 0653-341 The file *1_2598* does not exist.
oracle@ZTHXPADDB2:/gg/sarch2$ cd /gg/sarch1
oracle@ZTHXPADDB2:/gg/sarch1$ l
total 166951440
-rw-rw---- 1 oracle dba 1065574400 Mar 05 2020 1_2825_704996932.arc
-rw-rw---- 1 oracle dba 1065580032 Mar 06 2020 1_2826_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Mar 06 2020 1_2827_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Mar 07 2020 1_2828_704996932.arc
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
-rw-rw---- 1 oracle dba 1065574400 Dec 27 10:52 1_2902_704996932.arc
-rw-rw---- 1 oracle dba 1065574400 Dec 28 00:59 1_2903_704996932.arc
-rw-rw---- 1 oracle dba 1065687040 Dec 28 15:16 1_2904_704996932.arc
-rw-rw---- 1 oracle dba 1065607680 Dec 29 08:40 1_2905_704996932.arc
-rw-rw---- 1 oracle dba 1065577984 Dec 30 01:32 1_2906_704996932.arc
-rw-rw---- 1 oracle dba 278522368 Aug 06 07:15 2_2689_704996932.arc
-rw-r--r-- 1 oracle dba 90 Dec 22 2013 afiedt.buf
oracle@ZTHXPADDB2:/gg/sarch1$
RMAN> list archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
4651 1 2825 A 05-MAR-20 /gg/sarch1/1_2825_704996932.arc
4653 1 2826 A 05-MAR-20 /gg/sarch1/1_2826_704996932.arc
4655 1 2827 A 06-MAR-20 /gg/sarch1/1_2827_704996932.arc
4656 1 2828 A 06-MAR-20 /gg/sarch1/1_2828_704996932.arc
4658 1 2829 A 07-MAR-20 /gg/sarch1/1_2829_704996932.arc
4660 1 2830 A 20-MAR-20 /gg/sarch1/1_2830_704996932.arc
4662 1 2831 A 20-MAR-20 /gg/sarch1/1_2831_704996932.arc
4665 1 2832 A 21-MAR-20 /gg/sarch1/1_2832_704996932.arc
4667 1 2833 A 30-MAR-20 /gg/sarch1/1_2833_704996932.arc
4670 1 2834 A 30-MAR-20 /gg/sarch1/1_2834_704996932.arc
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
4793 2 2702 A 02-OCT-20 /gg/sarch2/2_2702_704996932.arc
4795 2 2703 A 20-DEC-20 /gg/sarch2/2_2703_704996932.arc
4796 2 2704 A 21-DEC-20 /gg/sarch2/2_2704_704996932.arc
4798 2 2705 A 21-DEC-20 /gg/sarch2/2_2705_704996932.arc
4801 2 2706 A 22-DEC-20 /gg/sarch2/2_2706_704996932.arc
4803 2 2707 A 22-DEC-20 /gg/sarch2/2_2707_704996932.arc
4804 2 2708 A 23-DEC-20 /gg/sarch2/2_2708_704996932.arc
4806 2 2709 A 24-DEC-20 /gg/sarch2/2_2709_704996932.arc
4808 2 2710 A 24-DEC-20 /gg/sarch2/2_2710_704996932.arc
4811 2 2711 A 25-DEC-20 /gg/sarch2/2_2711_704996932.arc
4813 2 2712 A 25-DEC-20 /gg/sarch2/2_2712_704996932.arc
4815 2 2713 A 26-DEC-20 /gg/sarch2/2_2713_704996932.arc
4817 2 2714 A 26-DEC-20 /gg/sarch2/2_2714_704996932.arc
4819 2 2715 A 27-DEC-20 /gg/sarch2/2_2715_704996932.arc
4821 2 2716 A 28-DEC-20 /gg/sarch2/2_2716_704996932.arc
4823 2 2717 A 28-DEC-20 /gg/sarch2/2_2717_704996932.arc
4824 2 2718 A 29-DEC-20 /gg/sarch2/2_2718_704996932.arc
可以看到 2598號的歸檔日誌已經不存在了。
一.4.3.2 第一種辦法：改變抽取程式的時間
改變抽取程式的時間， 但是會導致資料不一致，若是測試庫，可以執行：alter extract extl,begin now
GGSCI (ZTHXPADDB2) 11> alter extract GGSEXT,begin now
EXTRACT altered.
GGSCI (ZTHXPADDB2) 12> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED GGSEXT 00:00:00 00:00:05
EXTRACT RUNNING GGSPUMP 00:00:00 00:00:00
GGSCI (ZTHXPADDB2) 13> start GGSEXT
Sending START request to MANAGER ...
EXTRACT GGSEXT starting
GGSCI (ZTHXPADDB2) 14> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GGSEXT 00:00:00 00:00:28
EXTRACT RUNNING GGSPUMP 00:00:00 unknown
GGSCI (ZTHXPADDB2) 17> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GGSEXT 00:00:00 unknown
EXTRACT RUNNING GGSPUMP 00:00:00 00:00:00
GGSCI (ZTHXPADDB2) 18> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GGSEXT 00:00:00 unknown
EXTRACT RUNNING GGSPUMP 00:00:00 unknown
GGSCI (ZTHXPADDB2) 19> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING GGSEXT 00:00:00 unknown
EXTRACT RUNNING GGSPUMP 00:00:00 00:00:01
可以看到雖然處於RUNNING的狀態，但是Time Since Chkpt列是不對的，而這是target端也不能正常啟動。
oracle@ZT1XPADRDB1:/gg/ogg$ tail -f ggserr.log
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.
2020-12-30 09:27:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.
2020-12-30 09:27:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.
2020-12-30 09:34:14 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start GGSREP.
2020-12-30 09:34:14 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 22.188.132.82 (START REPLICAT GGSREP ).
2020-12-30 09:34:14 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT GGSREP starting.
2020-12-30 09:34:14 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP starting.
2020-12-30 09:34:14 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: REPLICAT GGSREP started.
2020-12-30 09:34:14 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: No unique key is defined for table RICH_CUSTPAYAMOUNTHIS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2020-12-30 09:34:14 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Aborted grouped transaction on 'XPADRPT.RICH_CUSTPAYAMOUNTHIS', Database error 1403 ().
2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.
2020-12-30 09:34:14 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: SQL error 1403 mapping XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
2020-12-30 09:34:14 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Repositioning to rba 47143866 in seqno 2032.
2020-12-30 09:34:14 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: Error mapping from XPADB.RICH_CUSTPAYAMOUNTHIS to XPADRPT.RICH_CUSTPAYAMOUNTHIS.
2020-12-30 09:34:14 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ggsrep.prm: PROCESS ABENDING.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39947, modtime is 212619862981000000 for /gg/ogg/dirdat/tt001891.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -39951, modtime is 212619877906000000 for /gg/ogg/dirdat/tt001892.
2020-12-30 09:37:54 WARNING OGG-00956 Oracle GoldenGate Manager for Oracle, mgr.prm: hours_since_modified calculated as -40038, modtime is 212620189201000000 for /gg/ogg/dirdat/tt001893.
2020-12-30 09:37:54 WARNING OGG-00950 Oracle GoldenGate Manager for Oracle, mgr.prm: Purge of old extract file /gg/ogg/dirdat/tt001894 failed because the prev seqno exists. Purge rule was applying UseCheckPoints purge rule: Oldest Chkpt Seqno 2032 > 1894.
GGSCI (ZT1XPADRDB1) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED GGSREP 33665:56:32 00:03:08
一.4.3.3 第二種辦法：資料初始化
一、 source端準備oracle@ZTGXPADDB1:/softtmp$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jan 2 16:38:32 2021
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
SQL> col current_scn format 999999999999999
SQL> Select current_scn from v$database;
CURRENT_SCN
----------------
12242466771468
SQL>
由於是基於表級別的複製，並且全使用者和表的大小差異很大，所以建議匯出的時候基於表來匯出，匯入也基於表來匯入。
source庫匯出操作，flashback_scn為 12242466771468：
oracle@ZTGXPADDB1:/softtmp$ expdp XPADB/XPADB directory=DMP dumpfile=xpadb_20160125_01.dmp LOGFILE=xpadb_20160125.log TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE FLASHBACK_SCN=12242466771468
Export: Release 10.2.0.5.0 - 64bit Production on Saturday, 02 January, 2021 16:41:50
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
Starting "XPADB"."SYS_EXPORT_TABLE_01": XPADB/******** directory=DMP dumpfile=xpadb_20160125_01.dmp LOGFILE=xpadb_20160125.log TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE,BASE_BRCHBANKCTRL,BASE_CERTIFICATE,BASE_CESS,BASE_COREBANK,BASE_CURRENCY,BASE_DEPARTMENT,BASE_HOLIDAYCALENDAR,BASE_HOLIDAYDATE,BASE_INTEREST,BASE_INTERESTHIS,BASE_MAINAREA,BASE_MENU,BASE_PRODTYPECODE,BASE_RATE,BASE_ROLE,BASE_SYSLOG,BASE_SYSPARAM,BASE_TERMINALTELLER,BASE_USER,FINANCIAL_BANKPROFITLOG,FINANCIAL_DIVIDENDPLAN,FINANCIAL_FUNDPRICE,FINANCIAL_INTERESTRESET,FINANCIAL_ISSUE,FINANCIAL_ISSUEAUDIT,FINANCIAL_ISSUEAUDITHIS,FINANCIAL_ISSUEBRAND,FINANCIAL_ISSUECFL,FINANCIAL_ISSUECONTROL,FINANCIAL_ISSUEDIFFRATE,FINANCIAL_ISSUEDISCOUNT,FINANCIAL_ISSUEEXPD,FINANCIAL_ISSUEEXT,FINANCIAL_ISSUEFEE,FINANCIAL_ISSUEFORCUSTRISKLVL,FINANCIAL_ISSUEFUNDSTRANSFER,FINANCIAL_ISSUEOBSERV,FINANCIAL_ISSUEPAY,FINANCIAL_ISSUEPROFIT,FINANCIAL_ISSUEQTYSPLIT,FINANCIAL_ISSUESELLCTRL,FINANCIAL_ISSUESERIAL,FINANCIAL_ISSUEVARIABLE,FINANCIAL_ISSUEWORKTIME,FINANCIAL_LIQUIDATEACT,FINANCIAL_MESSAGEINFO,FINANCIAL_PERIOD,FINANCIAL_PRICE,FINANCIAL_PRICEHIS,FINANCIAL_REFERINDEX,FINANCIAL_POSITION,RICH_AUTOTRADE,RICH_CUSTACCOUNT,RICH_CUSTAUTOTRADE,RICH_CUSTAUTOTRADEHIS,RICH_CUSTCAPITAL,RICH_CUSTFAVORABLE,RICH_CUSTFREEZEUNIT,RICH_CUSTFUNDPROFIT,RICH_CUSTIMPAWN,RICH_CUSTKEEPBAL,RICH_CUSTOMERINFO,RICH_CUSTOMERINFOHIS,RICH_CUSTORDERTRADE,RICH_CUSTPAYAMOUNTLOG,RICH_CUSTPRODUCTBAL,RICH_CUSTPRODUCTBALQTY,RICH_CUSTPROFITDCCY,RICH_CUSTPROFITLOG,RICH_CUSTPROFITNORMAL,RICH_CUSTPROFITPAYMODE,RICH_CUSTPROFITPAYMODEHIS,RICH_CUSTRISKLVL,RICH_FUNDTRADELOG,RICH_NOPAYAMOUNT,RICH_NORMALPAY,RICH_ORDERTRADE,RICH_SMSCMDSIGN,RICH_SMSCMDTRADE,RICH_STARTBAL,RICH_STARTBALHIS,financial_positionhis,financial_positiontra,financial_positioncst,financial_positionacc,corp_stattemptab,corp_stattemptabacc,corp_stattemptabcst,FINANCIAL_ICCARDCODE,BASE_FINANCIALICCARD,FINANCIAL_ISSUESPECIFICATION,PA_RPT_PARAM,FINANCIAL_SALEBANK_HIS,RICH_TRA
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6.913 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "XPADB"."RICH_CUSTPRODUCTBAL" 63.64 KB 582 rows
. . exported "XPADB"."RICH_CUSTOMERINFO" 616.9 KB 2596 rows
. . exported "XPADB"."RICH_CUSTACCOUNT" 11.33 MB 177757 rows
. . exported "XPADB"."FINANCIAL_MESSAGEINFO" 329.7 MB 3067896 rows
. . exported "XPADB"."RICH_AUTOTRADE" 36.53 KB 161 rows
. . exported "XPADB"."BASE_SYSLOG" 24.70 KB 131 rows
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
. . exported "XPADB"."RICH_TRADELOG_HIS":"P_201411" 0 KB 0 rows
. . exported "XPADB"."RICH_TRADELOG_HIS":"P_201412" 0 KB 0 rows
. . exported "XPADB"."RICH_TRADELOG_HIS":"P_999999" 0 KB 0 rows
ORA-39166: Object RIC was not found.
Master table "XPADB"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for XPADB.SYS_EXPORT_TABLE_01 is:
/softtmp/dmp/xpadb_20160125_01.dmp
Job "XPADB"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 16:42:37
二、 target 準備
先做匯出備份操作：
root@ZT1XPADRDB1:/# su - oracle
oracle@ZT1XPADRDB1:/oracle$ expdp xpadrpt/xpadrpt directory=OGGD dumpfile=xpadb_20160125_02.dmp LOGFILE=xpadb_20160125_2.log TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE,BASE_BRCHBANKCTRL,BASE_CERTIFICATE,BASE_CESS,BASE_COREBANK,BASE_CURRENCY,BASE_DEPARTMENT,BASE_HOLIDAYCALENDAR,BASE_HOLIDAYDATE,BASE_INTEREST,BASE_INTERESTHIS,BASE_MAINAREA,BASE_MENU,BASE_PRODTYPECODE,BASE_RATE,BASE_ROLE,BASE_SYSLOG,BASE_SYSPARAM
Export: Release 11.2.0.3.0 - Production on Sat Jan 2 17:06:22 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "XPADRPT"."SYS_EXPORT_TABLE_01": xpadrpt/******** directory=OGGD dumpfile=xpadb_20160125_02.dmp LOGFILE=xpadb_20160125_2.log TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE,BASE_BRCHBANKCTRL,BASE_CERTIFICATE,BASE_CESS,BASE_COREBANK,BASE_CURRENCY,BASE_DEPARTMENT,BASE_HOLIDAYCALENDAR,BASE_HOLIDAYDATE,BASE_INTEREST,BASE_INTERESTHIS,BASE_MAINAREA,BASE_MENU,BASE_PRODTYPECODE,BASE_RATE,BASE_ROLE,BASE_SYSLOG,BASE_SYSPARAM,BASE_TERMINALTELLER,BASE_USER,FINANCIAL_BANKPROFITLOG,FINANCIAL_DIVIDENDPLAN,FINANCIAL_FUNDPRICE,FINANCIAL_INTERESTRESET,FINANCIAL_ISSUE,FINANCIAL_ISSUEAUDIT,FINANCIAL_ISSUEAUDITHIS,FINANCIAL_ISSUEBRAND,FINANCIAL_ISSUECFL,FINANCIAL_ISSUECONTROL,FINANCIAL_ISSUEDIFFRATE,FINANCIAL_ISSUEDISCOUNT,FINANCIAL_ISSUEEXPD,FINANCIAL_ISSUEEXT,FINANCIAL_ISSUEFEE,FINANCIAL_ISSUEFORCUSTRISKLVL,FINANCIAL_ISSUEFUNDSTRANSFER,FINANCIAL_ISSUEOBSERV,FINANCIAL_ISSUEPAY,FINANCIAL_ISSUEPROFIT,FINANCIAL_ISSUEQTYSPLIT,FINANCIAL_ISSUESELLCTRL,FINANCIAL_ISSUESERIAL,FINANCIAL_ISSUEVARIABLE,FINANCIAL_ISSUEWORKTIME,FINANCIAL_LIQUIDATEACT,FINANCIAL_MESSAGEINFO,FINANCIAL_PERIOD,FINANCIAL_PRICE,FINANCIAL_PRICEHIS,FINANCIAL_REFERINDEX,FINANCIAL_POSITION,RICH_AUTOTRADE,RICH_CUSTACCOUNT,RICH_CUSTAUTOTRADE,RICH_CUSTAUTOTRADEHIS,RICH_CUSTCAPITAL,RICH_CUSTFAVORABLE,RICH_CUSTFREEZEUNIT,RICH_CUSTFUNDPROFIT,RICH_CUSTIMPAWN,RICH_CUSTKEEPBAL,RICH_CUSTOMERINFO,RICH_CUSTOMERINFOHIS,RICH_CUSTORDERTRADE,RICH_CUSTPAYAMOUNTLOG,RICH_CUSTPRODUCTBAL,RICH_CUSTPRODUCTBALQTY,RICH_CUSTPROFITDCCY,RICH_CUSTPROFITLOG,RICH_CUSTPROFITNORMAL,RICH_CUSTPROFITPAYMODE,RICH_CUSTPROFITPAYMODEHIS,RICH_CUSTRISKLVL,RICH_FUNDTRADELOG,RICH_NOPAYAMOUNT,RICH_NORMALPAY,RICH_ORDERTRADE,RICH_SMSCMDSIGN,RICH_SMSCMDTRADE,RICH_STARTBAL,RICH_STARTBALHIS,financial_positionhis,financial_positiontra,financial_positioncst,financial_positionacc,corp_stattemptab,corp_stattemptabacc,corp_stattemptabcst,FINANCIAL_ICCARDCODE,BASE_FINANCIALICCARD,FINANCIAL_ISSUESPECIFICATION,PA_RPT_PARAM,FINANCIAL_SALEBANK_HIS,R
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 7.606 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "XPADRPT"."RICH_CUSTPRODUCTBAL" 45.04 KB 367 rows
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_201408" 0 KB 0 rows
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_201409" 0 KB 0 rows
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_201410" 0 KB 0 rows
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_201411" 0 KB 0 rows
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_201412" 0 KB 0 rows
. . exported "XPADRPT"."RICH_TRADELOG_HIS":"P_999999" 0 KB 0 rows
ORA-39166: Object XPADRPT.RICH_CUSTPRODUCTBALHIS_ was not found.
Master table "XPADRPT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for XPADRPT.SYS_EXPORT_TABLE_01 is:
/gg/bkup/xpadb_20160125_02.dmp
Job "XPADRPT"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 17:11:30
資料備份完成後可以進行匯入操作，注意schema、tablespace的remap操作，以及表的操作，我這裡根據業務需求應該是刪除後重建，所以選擇replace：
oracle@ZT1XPADRDB1:/oracle$ impdp XPADRPT/xpadrpt DIRECTORY=OGGD DUMPFILE=xpadb_20160125_01.dmp LOGFILE=impdp.xpadb_20160125_01.log REMAP_SCHEMA=xpadb:xpadrpt REMAP_TABLESPACE=xpaddat:xpaddata table_exists_action=replace
Import: Release 11.2.0.3.0 - Production on Sat Jan 2 17:18:39 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "XPADRPT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "XPADRPT"."SYS_IMPORT_FULL_01": XPADRPT/******** DIRECTORY=OGGD DUMPFILE=xpadb_20160125_01.dmp LOGFILE=impdp.xpadb_20160125_01.log REMAP_SCHEMA=xpadb:xpadrpt REMAP_TABLESPACE=xpaddat:xpaddata table_exists_action=replace
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "XPADRPT"."RICH_CUSTPRODUCTBAL" 63.64 KB 582 rows
. . imported "XPADRPT"."RICH_CUSTOMERINFO" 616.9 KB 2596 rows
. . imported "XPADRPT"."RICH_CUSTACCOUNT" 11.33 MB 177757 rows
. . imported "XPADRPT"."FINANCIAL_MESSAGEINFO" 329.7 MB 3067896 rows
《《《《。。。。。。。。篇幅原因，有省略。。。。。。。。》》》》
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_201408" 0 KB 0 rows
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_201409" 0 KB 0 rows
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_201410" 0 KB 0 rows
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_201411" 0 KB 0 rows
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_201412" 0 KB 0 rows
. . imported "XPADRPT"."RICH_TRADELOG_HIS":"P_999999" 0 KB 0 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "XPADRPT"."SYS_IMPORT_FULL_01" successfully completed at 17:29:25
匯入成功，接下來啟動target端的REPLICAT程式：
GGSCI (ZT1XPADRDB1) 16> stop ggsrep
REPLICAT GGSREP is already stopped.
GGSCI (ZT1XPADRDB1) 17> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED
REPLICAT ABENDED GGSREP 33743:45:19 01:56:55
GGSCI (ZT1XPADRDB1) 18> info all
Program Status Group Lag Time Since Chkpt
MANAGER STOPPED
REPLICAT ABENDED GGSREP 33743:45:19 02:07:52
GGSCI (ZT1XPADRDB1) 19> start mgr
Manager started.
GGSCI (ZT1XPADRDB1) 20> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED GGSREP 33743:45:19 02:08:01
GGSCI (ZT1XPADRDB1) 21> start replicat ggsrep , aftercsn 12242466771468
Sending START request to MANAGER ...
REPLICAT GGSREP starting
GGSCI (ZT1XPADRDB1) 22> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 33716:13:56 00:00:02
GGSCI (ZT1XPADRDB1) 23> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 33216:43:48 00:00:04
GGSCI (ZT1XPADRDB1) 24> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 30818:03:37 00:00:05
GGSCI (ZT1XPADRDB1) 25> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 24194:29:09 00:00:02
GGSCI (ZT1XPADRDB1) 26> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 00:00:00 00:00:06
GGSCI (ZT1XPADRDB1) 27> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 00:00:00 00:00:08
GGSCI (ZT1XPADRDB1) 28> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 00:00:00 00:00:09
GGSCI (ZT1XPADRDB1) 29> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING GGSREP 00:00:00 00:00:06
可以看到target端的程式已經正常了。
一.4.4 驗證是否可以正常同步資料
當時忘記記錄日誌，經測試已經可以正常同步資料了，省略驗證過程。。。。。
一.5 故障處理總結
一.5.1 OGG-00446 Could not find archived log for sequence 53586 thread 1 under alternative destinations.
錯誤資訊：
OGG-00446 Could not find archived log for sequence 53586 thread 1 under alternative destinations. SQL <SELECT MAX(sequence#) FROM v$log WHERE thread# = :ora_thread>. Last alternative log tried /arch_cx/1_53586_776148274.arc., error retri
eving redo file name for sequence 53586, archived = 1, use_alternate = 0Not able to establish initial position for sequence 53586, rba
44286992.
處理辦法：
將缺失的歸檔日誌從備份中恢復出來。如果依舊找不到所需歸檔日誌，那麼只能重新實施資料初始化。
第一種辦法，會導致資料不一致，改變抽取程式的時間，如下執行：
GGSCI (HP-HP) 8> alter extract extl,begin now
第二種辦法：重新初始化
重新初始化過程如下：
---- source庫
SQL> col current_scn format 999999999999999
SQL> Select current_scn from v$database;
CURRENT_SCN
----------------
12242466771468
expdp XPADB/XPADB directory=DMP dumpfile=xpadb_20160125_01.dmp LOGFILE=xpadb_20160125.log TABLES=BASE_ACTIONPOWER,BASE_BANK FLASHBACK_SCN=12242466771468
--- target庫
impdp XPADRPT/xpadrpt DIRECTORY=OGGD DUMPFILE=xpadb_20160125_01.dmp LOGFILE=impdp.xpadb_20160125_01.log REMAP_SCHEMA=xpadb:xpadrpt REMAP_TABLESPACE=xpaddat:xpaddata table_exists_action=replace
start replicat ggsrep , aftercsn 12242466771468
到此所有的處理算是基本完畢，過程很簡單，但是不同的場景處理方式有很多種，我們應該學會靈活變通。
一.6 About Me
...........................................................................................................................................................................................
本文作者：小麥苗，只專注於資料庫的技術，更注重技術的運用
ITPUB BLOG：http://blog.itpub.net/26736162
本文地址：http://blog.itpub.net/26736162/viewspace-1982701/
本文pdf版：http://yunpan.cn/cdEQedhCs2kFz （提取碼：ed9b）
QQ：642808185 若加QQ請註明您所正在讀的文章標題
於 2016-01-26 10:00~ 2016-01-26 19:00 在中行完成
<版權所有，文章允許轉載，但須以連結方式註明源地址，否則追究法律責任!>
...........................................................................................................................................................................................
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-1982701/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【故障解決】ORA-06502錯誤解決
- VIM 常用錯誤解決
- sqldeveloper for windows 錯誤解決SQLDeveloperWindows
- OGG-00446的一次解決
- latex 錯誤以及解決方案
- ora-27504錯誤解決
- Datastore error in 'dirbdb'錯誤解決ASTError
- ORA-27054 錯誤解決
- mysql與php錯誤解決MySqlPHP
- mysql錯誤解決總結MySql
- NFS故障解決NFS
- 解決MySQL server has gone away錯誤的解決方案MySqlServerGo
- 【故障處理】Oracle10.2.0.3 ORA-3136 錯誤解決Oracle
- 【故障處理】修改maxuproc引數解決TNS-00519錯誤
- HTTP代理錯誤怎麼解決？HTTP
- undefined reference to錯誤的解決方法Undefined
- SAXParseException的錯誤解決之二Exception
- PHP curl error 60 錯誤解決PHPError
- ORA-04091錯誤解決
- ORA-3136 錯誤解決 .
- [Windows] 解決 COM Surrogate 錯誤提示Windows
- AFNetworkingErrorDomain 錯誤解決方法ErrorAI
- [Flashback]ORA-38760錯誤解決
- EXP-00091錯誤解決
- virtualbox 錯誤解決記錄
- INS-40904 錯誤解決
- Mac下面svn錯誤資訊解決Mac
- PHP錯誤“Thisfilehasexpired”的解決方法PHP
- SAP錯誤提示解決辦法
- ClamAV無法更新錯誤解決
- clamd socket找不到錯誤解決
- ora-00604錯誤解決
- vsftpd 錯誤：530 and 500 錯誤解決方法FTP
- 【故障處理】分散式事務ORA-01591錯誤解決分散式
- steam磁碟寫入錯誤怎麼解決 steam磁碟寫入錯誤解決方法大全
- dbfread報錯ValueError錯誤解決方法Error
- 故障解決法(摘抄)
- 寬頻連線錯誤678怎麼辦？ 寬頻連線錯誤678故障解決辦法