www.eygle.com

---

November 22, 2006

EMC Cx500 ATA盘损坏

作者:eygle

出处:http://blog.eygle.com

EMC Cx500已经安静了很长一段时间，上午和朋友谈起最近很少坏盘了，中午就发现坏了一块。

看来真的经不起念叨，而且这次坏的是一块ATA硬盘，320G的。

bash-2.03# navicli -h 172.16.9.5 getdisk 0_3_8
Bus 0 Enclosure 3 Disk 8
State: Removed

报了故障之后，EMC很快就派工程师前来更换，不过Rebuilding 320G的一块硬盘，需要相当长的时间:

bash-2.03# navicli -h 172.16.9.5 getdisk 0_3_8
Bus 0 Enclosure 3 Disk 8
Vendor Id: ATA-MXTR
Product Id: 5A320J0 CLAR320
Product Revision: WV
Lun: 36 37 38 39 40 41 42
Type: 36: RAID5 37: RAID5 38: RAID5 39: RAID5 40: RAID5 41: RAID5 42: RAID5
State: Rebuilding
Hot Spare: 36: NO 37: NO 38: NO 39: NO 40: NO 41: NO 42: NO
Prct Rebuilt: 36: 0 37: 0 38: 0 39: 0 40: 4 41: 0 42: 0
Prct Bound: 36: 100 37: 100 38: 100 39: 100 40: 100 41: 100 42: 100
Serial Number: A82P27KE
Sectors: 498073600 (243200)
Capacity: 304169
Private: 36: 69760 37: 1048645760 38: 1468076160 39: 2726367360
40: 2936082560 41: 3040940160 42: 3355512960
Bind Signature: 0xffff, 3, 8
Hard Read Errors: 0
Hard Write Errors: 0
Soft Read Errors: 0
Soft Write Errors: 0
Read Retries: N/A
Write Retries: N/A
Remapped Sectors: N/A
Number of Reads: 30918811
Number of Writes: 33292798
Number of Luns: 7
Raid Group ID: 18
Clariion Part Number: DG118032260
Request Service Time: N/A
Read Requests: 30918811
Write Requests: 33292798
Kbytes Read: 1919788807
Kbytes Written: 2093549644
Stripe Boundary Crossing: 0

最近硬件故障十分频繁，看来应该是年关临近的缘故。

-The End-

Posted by eygle at 4:32 PM | Comments (1)

---

如何在sqlldr中倒入多字符分隔符文件

作者:eygle

出处:http://blog.eygle.com

今天有朋友询问：
我们...应用系统很多，它们之间要交换很多数据，目前是以文本方式交换，问题是文本的分隔符号是（|+|），为三个字符，主要是避免数据的混淆.....

这样的文件能够用sqlldr导入么?

我测试了一下，试验证明是可以的，sqlldr支持多字符分隔符文件导入。
首先看我的数据文件和控制文件:

[oracle@jumper tmp]$ cat data.ctl
load data
into table TEST
fields terminated by "|+|"
(
T_ID,
T_VOL
)
[oracle@jumper tmp]$ cat data.txt
20021228000000|+|00120000
20021228000000|+|00130000
20021228000000|+|00140000
20021||8000000|+|00140000
20021++8000000|+|00140000

创建测试表:

[oracle@jumper tmp]$ sqlplus eygle/eygle

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 21 13:21:16 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> create table test
2 (T_ID varchar2(20),
3 T_VOL varchar2(20)
4 );

Table created.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

加载数据:

[oracle@jumper tmp]$ sqlldr eygle/eygle control=data.ctl data=data.txt

SQL*Loader: Release 9.2.0.4.0 - Production on Tue Nov 21 13:23:53 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Commit point reached - logical record count 5
[oracle@jumper tmp]$ sqlplus eygle/eygle

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 21 13:23:57 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> select * from test;

T_ID T_VOL
-------------------- --------------------
20021228000000 00120000
20021228000000 00130000
20021228000000 00140000
20021||8000000 00140000
20021++8000000 00140000

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

只作了简单验证，不知道复杂情况会不会有问题。

-The End-

Posted by eygle at 1:26 PM | Comments (4)

---