Wednesday, October 01, 2008

DB Dump cdmp_* after shink table

I checked my Database and then shrunk TABLES.

After I shrunk some tables; I found many cdmp_* on bdump path (diag process generate them) when run TRANSFER_DATA(scheduler name) Scheduler Job.

Something Wrong on some objects:

I began to check alert log file:

Wed Oct 1 07:49:00 2008
Errors in file /.../admin/DB/bdump/DB1_j001_8217.trc:
Wed Oct 1 07:49:01 2008
Trace dumping is performing id=[cdmp_20081001081411]


I should investigate /...//admin/DB/bdump/DB1_j001_8217.trc file as well:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /.../10.2.0/db
System name: Linux
Node name: DB01
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:32:02 EDT 2006
Machine: x86_64
Instance name: DB1
Redo thread mounted by this instance: 1
Oracle process number: 81
Unix process pid: 8217, image: oracle@DB01(J001)

*** 2008-10-01 07:49:00.047
*** ACTION NAME:(TRANSFER_DATA) 2008-10-01 07:49:00.046
*** MODULE NAME:(DBMS_SCHEDULER) 2008-10-01 07:49:00.046
*** SERVICE NAME:(SV) 2008-10-01 07:49:00.046
*** CLIENT ID:(SYSMAN@IP@Mozilla/5.0 (Windows; U; Windows NT 5.1; en) 2008-10-01 07:49:00.046
*** SESSION ID:(502.27106) 2008-10-01 07:49:00.046
oer 8102.2 - obj# 227780, rdba: 0x18001eef(afn 96, blk# 7919)
kdk key 8102.2:
ncol: 3, len: 18
key: (18): 07 78 6c 0a 01 03 22 1a 02 c1 02 06 16 80 3c dd 00 01
mask: (4096): ....................................

A trace file told me about object_id=227780, and then check in Database:

select owner, object_name,subobject_name,object_type from dba_objects where object_id=227780;

OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE
------- --------------- -------------------- -------------------------
TMPUSER TABLE_INDX01 TABLE_INDX01_PART1 INDEX PARTITION

We found "index partition" object; So rebuilt it:

ALTER INDEX TMPUSER.TABLE_INDX01 REBUILD PARTITION TABLE_INDX01_PART1;

After rebuilt it, It's OK...

No comments: