GGSCI (dg1) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EORCL 09:46:00 01:54:10
EXTRACT RUNNING PORCL 00:00:00 00:00:05
GGSCI (dg1) 2>
2022-07-05 07:47:59 INFO OGG-01517 Position of first record processed Sequence 87405,
RBA 46520848, SCN 2.650811534, Jul 4, 2022 10:01:59 PM.
Source Context :
SourceModule : [er.redo.ora.sr]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/redo/oracle/redoorasr.c]
SourceFunction : [get_subrec]
SourceLine : [6187]
ThreadBacktrace : [11] elements
: [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f4a0f02070e]]
: [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f4a0f0196ac]]
: [/ogg/libgglog.so(_MSG_ERR_ER_GENERIC_FAILURE(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7f4a0f0
04849]]
: [/ogg/extract() [0x6ffe25]]
: [/ogg/extract(REDOORASR_get_all_subrecs(int, objectpool*, unsigned char*, subrec_info_t*, redo_thread_t*, log_context_t*)+0x92) [
0x7000a2]]
: [/ogg/extract(REDO_read(char*, int*, long*, char*, short*, int, char*)+0x7e7) [0x69d895]]
: [/ogg/extract(READ_EXTRACT_RECORD(chkpt_context_t*, short, char*, __std_rec_hdr*, int*, int*, long*, short, short, char*, short*,
char*, short*, long*, char*)+0x19b) [0x4f5e1b]]
: [/ogg/extract(process_extract_loop()+0x802) [0x561302]]
: [/ogg/extract(main+0x5d9) [0x573ab9]]
: [/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f4a0b5a4555]]
: [/ogg/extract(__gxx_personality_v0+0x38a) [0x4edaba]]
2022-07-05 07:47:59 ERROR OGG-01028 Object with object number 231445 is compressed. Table compression is not supported.
***********************************************************************
* ** Run Time Statistics ** *
2022-07-05 07:47:59 ERROR OGG-01028 Object with object number 231445 is compressed.
Table compression is not supported.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
select table_name,owner from dba_tables where COMPRESSION='ENABLED' and OWNER in ('CFPSNG','BYCS');
Report at 2022-07-05 07:47:59 (activity since 2022-07-05 07:47:58)
Output to /ogg/dirdat/eorcl/ex:
DDL replication statistics:
Operations: 0
Mapped operations: 0
Unmapped operations: 0
Other operations: 0
Excluded operations: 0
No records extracted.
2022-07-05 07:47:59 ERROR OGG-01668 PROCESS ABENDING.
查询如下信息
col owner for a12
col object_name for a26
select owner,object_name ,object_type from dba_objects where object_id=231445;
SQL> select owner,object_name ,object_type from dba_objects where object_id=231445;
OWNER OBJECT_NAME OBJECT_TYPE
------------ -------------------------- -------------------
CFPSNG DBMS_TABCOMP_TEMP_CMP TABLE
处理方法如下:
增加如下参数配置到eorcl进程。
TABLEEXCLUDE CFPSNG.DBMS_TABCOMP_TEMP_CMP
TABLEEXCLUDE CFPSNG.DBMS_TABCOMP_TEMP_UNCMP
重启进程
GGSCI (dg1) 5> start eorcl
Sending START request to MANAGER ...
EXTRACT EORCL starting
GGSCI (dg1) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORCL 11:48:54 00:00:01
EXTRACT RUNNING PORCL 00:00:00 00:00:00