20160226_dsgzw_errror

72 阅读 0 评论 48 点赞

我是靠谱客的博主愉快大山，最近开发中收集的这篇文章主要介绍20160226_dsgzw_errror，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

dsgzw@shhp2[oratj]:/dsgzw$ mon_dt.sh

======================================================================================================================================================

Monitor Loader

==============

/dsgzw/zwfold1

--------------

--------------------------------------------------------------------------------

/dsgzw/zwfold2

--------------

--------------------------------------------------------------------------------

/dsgzw/zwfold3

--------------

dsgzw@shhp2[oratj]:/dsgzw$ cd zwfold2/log

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ ./qu.sh

sh: ./qu.sh: not found.

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ tail -f log.r0

: 0008E998.0008E998.05012353.0007 B2(IRP) --H-FL-- cc:23 len:202

: 0008E998.0008E998.05012353.0008 B2(IRP) --H-FL-- cc:23 len:198

: 0008E998.0008E998.05012353.0009 B2(IRP) --H-FL-- cc:23 len:206

: 0008E998.0008E998.05012353.000A B2(IRP) --H-FL-- cc:23 len:196

: 0008E998.0008E998.05012353.000B B2(IRP) --H-FL-- cc:23 len:192

: 0008E998.0008E998.05012353.000C B2(IRP) --H-FL-- cc:23 len:192

2662 transactions rollbacked (oci: 1400)

(UCR_PARAM.TD_M_DEPART -> UCR_PARAM.TD_M_DEPART) OCI Error -1 occurred at File xf1_to_oracle_ins_rid.c:1744.

ORA-01400: cannot insert NULL into ("UCR_PARAM"."TD_M_DEPART"."ORDER_NO")

fail to process /dsgzw/zwfold2/rmp/real0/682536.xf1 xf1_to_oracle.c:5310, retry it.fail to process /dsgzw/zwfold2/rmp/real0/682536.xf1 xf1_to_oracle.c:5310, retry it.

Loader: 682536.xf1 --- possibly data corrupted: len 3880, vlen 211

UCR_PARAM.TD_M_DEPART, Column 5 truncated: dlen 25, clen 1

position: vbuf-buf: 3652, pbuf-vbuf: 97

buf sample [ 64]: 0000 00C4 B200 08E9-9800 08E9 9805 0123 ...............#

4F00 232C 1700 0559-3030 3238 0008 4948 O.#,...Y0028..IH

3034 3634 3030 0018-28D7 F7B7 CF29 D5D0 046400..(....)..

C9CC D2F8 D0D0 28D2-F8D0 D0BB FAB9 B929 ......(........)

vbuf sample [ 129]: 0000 00D3 B200 08E9-9800 08E9 9805 0123 ...............#

5300 0C2C 1700 0533-3138 3931 0008 3547 S..,...31891..5G

3139 3136 3730 0012-28D7 F7B7 CF29 BADA 191670..(....)..

BAD3 C7FE B5C0 B2BF-C3C5 0003 3131 3300 ............113.

1E30 3030 3030 3231-3536 3232 3135 0000 .0000021562215..

00D4 B200 08E9 9800-08E9 9805 0123 6E00 .............#n.

192C 1700 0531 3236-3536 0008 3444 3039 .,...12656..4D09

3637 3732 0012 28D7-F7B7 CF29 CDAC BDAD 6772..(....)....

BC .

--- possibly data corrupted: len 3880, vlen 211

UCR_PARAM.TD_M_DEPART, Column 6 truncated: dlen 53033, clen 8

position: vbuf-buf: 3652, pbuf-vbuf: 124

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$./bin/xfview -h

Usage: xfview [options] [from_host:from_port:]xf1_file1 2 .. N

-h help

-v version number

-I case sensitive search

-c assemble chained rows

-dict file dictionary file for SQL/UNDO SQL presentation

(default: objn.xf1)

-show level of file contents listing (default:3)

1 display XF1 contained in short

2 display XF1 contained in detail

3 display SQL statements

4 display UNDO SQL statements

5 XF1 file statistics

6 CSV Format

-xfview_unzip Save unzip data to file

-objns list only save objn list data

-delobj Delete All OP of one OBJ#

-delpart Delete partition by objd#

-delrowid Delete rowid OP

xfview -delrowid objd dba slot

-delrowidr delete other rowid OP

xfview -delrowid objd dba slot

-deldup delete dup update

-delopc Delete opc data

-delseq Delete sequence data

-depart no# depart xf1 file into samller xf1 file, size<=5M

-o tofile output xf1 to a new file

-add_hd type add a xf1 header, type='s' (sync) or ='r' (real)

-bbtob2 tofile 0xBB to 0xB2

-usermap user mappings, in format of:

SourceUser TargetUser

<repeat> ......

-tablemap table mappins, in format of:

SourceUser.SourceTable TargetUser.TargetTable

<repeat> ......

-where select records which meet some conditions to view,

The format is regular SQL statement,

"select * from table-name where conditions"

Note: In conditions, you can use:

+ - * / % > >= = < <= !=

like in and or not

-target table target, in format of option:[-tablemap]

This is for select fields.

-process n How mang processes work concurrently

-delshow

Translate "UNKNOWN XF1" to 0x00.

-dir directory

-no startNo,endNo

-sql

-objnf file

-flist file

To gather statistics file.

-dir, -no is required.

-sql is optional, worked with -dict. It creates 'sql.txt' to store sql information.

-objnf is optional, it use 'objn.txt' to display table name.(exclusive from -dict)

-dict is optional, it use s_dict.xf1 to display table name.

if use -objnf, ignore -dict and -sql.

usage:./xfview -dir directory -no 0,90 [-dict s_dict.xf1 [-sql]|-objnf objn.txt]

./xfview -dir directory -flist file [-dict s_dict.xf1 [-sql]|-objnf objn.txt]

-delxf1

for deleting uncommited xf1 files.

usage:./xfview -delxf1 -dir directory -delobj objn -flist flist [-o ofile]

-verifycl

verify column data length for 0xB2,0xB3,0xB5,0xBB,0xBC,0xE2,0xE3,0xE5,0xEB.

support for char(n),varchar2(n).

Tips: How to dump REDO log files to SQL statement?

Step 1: Download dictionary from source database

xexp usr/pwd -to_file objn.xf1 -rows n -full y

Step 2: Dump redo log files to XF1 files

oaudit /oracle/dsg/redo11.log -show 5 -o t.xf1

Step 3: Dump it to SQL statements

xfview t.xf1 >t.sql

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ ./bin/xfview -delobj 584088 /dsgzw/zwfold2/rmp/real0/682536.xf1

CHECK_MEMLEAK is turned off

Deleted: IRP-678 URP-0 DRP-0 QMI-0 OTher-0

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ls /dsgzw/zwfold2/rmp/real0/682536.xf1

/dsgzw/zwfold2/rmp/real0/682536.xf1

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ls /dsgzw/zwfold2/rmp/real0/682536.xf1

/dsgzw/zwfold2/rmp/real0/682536.xf1 not found

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$tail -f log.r0

tail: cannot open input

error: No such file or directory on file log.r0

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$tail

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$pwd

/dsgzw/zwfold2

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ls

bin config elib fmp imp log rmp scripts vcfsa

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$tail -f log/log.r0

Loader: 682972.xf1 2016-02-26:09:16:39: (commit) SCN 0xd79035c.16310001, Time 2016-02-26 04:20:21

2016-02-26:09:16:39: 100-I 0-D 0-U 0-DDL(0 ms) (17778 s)

Loader: 682973.xf1 2016-02-26:09:16:39: (commit) SCN 0xd79035c.3a090001, Time 2016-02-26 04:20:30

2016-02-26:09:16:39: 0-I 0-D 1-U 0-DDL(0 ms) (17769 s)

###########

我们软件有一条交易记录错了。

../bin/xfview -h 可以删除 xf1里面对象的交易或者dml交易

dsgzw@shhp2[oratj]:/dsgzw/zwfold2/log$ tail -f log.r0

: 0008E998.0008E998.05012353.0007 B2(IRP) --H-FL-- cc:23 len:202

: 0008E998.0008E998.05012353.0008 B2(IRP) --H-FL-- cc:23 len:198

: 0008E998.0008E998.05012353.0009 B2(IRP) --H-FL-- cc:23 len:206

: 0008E998.0008E998.05012353.000A B2(IRP) --H-FL-- cc:23 len:196

: 0008E998.0008E998.05012353.000B B2(IRP) --H-FL-- cc:23 len:192

: 0008E998.0008E998.05012353.000C B2(IRP) --H-FL-- cc:23 len:192

2662 transactions rollbacked (oci: 1400)

(UCR_PARAM.TD_M_DEPART -> UCR_PARAM.TD_M_DEPART) OCI Error -1 occurred at File xf1_to_oracle_ins_rid.c:1744.

ORA-01400: cannot insert NULL into ("UCR_PARAM"."TD_M_DEPART"."ORDER_NO")

fail to process /dsgzw/zwfold2/rmp/real0/682536.xf1 xf1_to_oracle.c:5310, retry it.fail to process /dsgzw/zwfold2/rmp/real0/682536.xf1 xf1_to_oracle.c:5310, retry it.

Loader: 682536.xf1 --- possibly data corrupted: len 3880, vlen 211

UCR_PARAM.TD_M_DEPART, Column 5 truncated: dlen 25, clen 1

处理办法

./bin/xfview -delobj 584088 /dsgzw/zwfold2/rmp/real0/682536.xf1

584088 10进制钻换成16进制是8E998

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26179376/viewspace-2096489/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26179376/viewspace-2096489/