Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01013: user requested cancel of current operation

GeetaMOct 9 2012 — edited Oct 9 2012
Hi

I got below alert message - query error, ORA-01013: user requested cancel of current operation
can anyone give me the fix/reason for this error message -

Below is the alert log - 
"Errors in file /u00/app/oracle/diag/rdbms/***/***1/trace/***1_ora_7088.trc:
ORA-01013: user requested cancel of current operation
Errors in file /u00/app/oracle/diag/rdbms/***/***1/trace/***1_ora_7088.trc:
ORA-01013: user requested cancel of current operation
Tue Oct 09 05:00:34 2012
Index CM.XBM_PCF_CUSTOMER_ACCOUNT_KEY or some [sub]partitions of the index have been marked unusable
Index CM.XBM_PCF_SITE_ID or some [sub]partitions of the index have been marked unusable
Tue Oct 09 05:01:06 2012
Index CM.XNU_SEUF_CALENDAR_KEY or some [sub]partitions of the index have been marked unusable
Index CM.XNU_SEUF_TYPE or some [sub]partitions of the index have been marked unusable
Index CM.XBM_SEUF_ACCOUNT_NBR or some [sub]partitions of the index have been marked unusable
Index CM.XBM_SEUF_SITE_ID or some [sub]partitions of the index have been marked unusable
Index CM.XNU_SEUF_CUSTOMER_ACCOUNT_KEY or some [sub]partitions of the index have been marked unusable"
Below is the trace file -
“*** | ***1 | /u00/app/oracle/diag/rdbms/***/***1/trace

cat /u00/app/oracle/diag/rdbms/***/***1/trace/***1_ora_7088.trc
Trace file /u00/app/oracle/diag/rdbms/***/***1/trace/***1_ora_7088.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
and Data Mining options
ORACLE_HOME = /u00/app/oracle/product/11.2.0/DB
System name:    Linux
Node name:      ***.corp.cox.com
Release:        2.6.18-308.1.1.el5
Version:        #1 SMP Fri Feb 17 16:51:01 EST 2012
Machine:        x86_64
Instance name: ***1
Redo thread mounted by this instance: 1
Oracle process number: 260
Unix process pid: 7088, image: oracle@***.corp.cox.com
*** 2012-09-25 15:19:34.401
*** SESSION ID:(772.25371) 2012-09-25 15:19:34.401
*** CLIENT ID:() 2012-09-25 15:19:34.401
*** SERVICE NAME:(***_CAMPMGT_APP) 2012-09-25 15:19:34.401
*** MODULE NAME:(unica_acsvr@dukeunpd03.corp.cox.com (TNS V1-V3)) 2012-09-25 15:19:34.401
*** ACTION NAME:() 2012-09-25 15:19:34.401
kdpurtab: err=604 goc1=604 goc2=54 goc3=0
Trace file /u00/app/oracle/diag/rdbms/***/***1/trace/***1_ora_7088.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
and Data Mining options
ORACLE_HOME = /u00/app/oracle/product/11.2.0/DB
System name:    Linux
Node name:      ***.corp.cox.com
Release:        2.6.18-308.1.1.el5
Version:        #1 SMP Fri Feb 17 16:51:01 EST 2012
Machine:        x86_64
Instance name: ***1
Redo thread mounted by this instance: 1
Oracle process number: 48
Unix process pid: 7088, image: oracle@***.corp.cox.com
*** 2012-10-09 04:35:57.659
*** SESSION ID:(23.19209) 2012-10-09 04:35:57.659
*** CLIENT ID:() 2012-10-09 04:35:57.659
*** SERVICE NAME:(SYS$USERS) 2012-10-09 04:35:57.659
*** MODULE NAME:() 2012-10-09 04:35:57.659
*** ACTION NAME:() 2012-10-09 04:35:57.659

kcbzib: dump suspect buffer
buffer tsn: 13 rdba: 0x08e6c2f3 (35/2540275)
scn: 0x09d4.12c642dd seq: 0x01 flg: 0x04 tail: 0x42dd2301
frmt: 0x02 chkval: 0x96e4 type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000BE49A000 to 0x00000000BE49C000
0BE49A000 0000A223 08E6C2F3 12C642DD 040109D4  [#........B......]
0BE49A010 000096E4 00000000 00000000 00000000  [................]
0BE49A020 00000000 00000001 00000008 00000A9C  [................]
0BE49A030 00000000 00000003 00000008 08E6C2F4  [................]
0BE49A040 00000000 00000000 00000000 00000000  [................]
0BE49A050 001F000C 001DE739 00000001 00000000  [....9...........]
0BE49A060 00000003 00000008 08E6C2F4 00000000  [................]
0BE49A070 00000000 00000000 00000000 08E6C2F1  [................]
0BE49A080 08E6C2F1 00000000 00000000 00000000  [................]
0BE49A090 00000000 00000000 00000000 00000000  [................]
        Repeat 3 times
0BE49A0D0 00000001 00002000 00000000 00001434  [..... ......4...]
0BE49A0E0 00000000 08E6C2F2 00000001 08E6C2F1  [................]
0BE49A0F0 08E6C2F2 00000000 00000000 00000000  [................]
0BE49A100 00000000 00000000 00000001 00000000  [................]
0BE49A110 00B8C1F7 10000000 08E6C2F1 00000008  [................]
0BE49A120 00000000 00000000 00000000 00000000  [................]
        Repeat 152 times
0BE49AAB0 08E6C2F1 08E6C2F4 00000000 00000000  [................]
0BE49AAC0 00000000 00000000 00000000 00000000  [................]
        Repeat 151 times
0BE49B440 00000000 00000000 08E6C2F2 00000000  [................]
0BE49B450 00000000 00000000 00000000 00000000  [................]
        Repeat 185 times
0BE49BFF0 00000000 00000000 00000000 42DD2301  [.............#.B]
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 1      #blocks: 8
                  last map  0x00000000  #maps: 0      offset: 2716
      Highwater::  0x08e6c2f4  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
      Disk Lock:: Locked by xid:  0x000c.01f.001de739
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x08e6c2f4  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
  Level 1 BMB for High HWM block: 0x08e6c2f1
  Level 1 BMB for Low HWM block: 0x08e6c2f1
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x08e6c2f2
  Last Level 1 BMB:  0x08e6c2f1
  Last Level II BMB:  0x08e6c2f2
  Last Level III BMB:  0x00000000
     Map Header:: next  0x00000000  #extents: 1    obj#: 12108279 flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x08e6c2f1  length: 8

  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x08e6c2f1 Data dba:  0x08e6c2f4
  --------------------------------------------------------

   Second Level Bitmap block DBAs
   --------------------------------------------------------
   DBA 1:   0x08e6c2f2

Dump of buffer cache at level 8 for tsn=13, rdba=149340915
BH (0xbfdbdfb8) file#: 35 rdba: 0x08e6c2f3 (35/2540275) class: 4 ba: 0xbe49a000
  set: 33 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
  dbwrid: 0 obj: 12095363 objn: -1 tsn: 13 afn: 35 hint: f
  hash: [0x223e2e048,0x4264e7720] lru: [0xc7e1cdd8,0x169e55988]
  ckptq: [NULL] fileq: [NULL] objq: [NULL] objaq: [NULL]
  use: [0x426957060,0x426957060] wait: [NULL]
  st: CR md: EXCL tch: 0 le: (nil)
  cr: [scn: 0x9d4.12c64ca8],[xid: 0x0.0.0],[uba: 0x0.0.0],[cls: 0x9d4.12c64ca8],[sfl: 0x0],[lc: 0x0.0]
  flags: reading_as_CR only_sequential_access
  cr pin refcnt: 0 sh pin refcnt: 0
  Using State Objects
    ----------------------------------------
    SO: 0x426956fe0, type: 38, owner: 0x3fb09fb88, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
     proc=0x43cb5e180, name=buffer handle, file=kcb2.h LINE:2629, pg=0
    (buffer) (CR) PR: 0x43cb5e180 FLG: 0x0
    lock rls: (nil), class bit: 0x0
     cr[5]: [0x42cad0028, 0] [0x428f6eb60, 3] [0x428f5e6a0, 5] [0x428f5bca0, 6] [0x42a94ae60, 7]
     sh[0]:
    kcbbfbp: [BH: 0xbfdbdfb8, LINK: 0x426957060]
    type: normal pin
    where: ktewh25: kteinicnt, why: 0
GLOBAL CACHE ELEMENT DUMP (address: 0x1bffcf2c8):
  id1: 0x26c2f3 id2: 0x23 pkey: OBJ#12095363 block: (35/2540275)
  lock: C rls: 0x0 acq: 0x0 latch: 6
  flags: 0x21 fair: 0 recovery: 0 fpin: 'ktewh25: kteinicnt'
  bscn: 0x9d4.1f3ca24 bctx: (nil) write: 0 scan: 0x0
  lcp: (nil) lnk: [NULL] lch: [0x428f7fa70,0x243f54de8]
  seq: 1415 hist: 329 144:6 289 7 352 197 51 39 74:2 334 297
 GCS CLIENT 0x1bffcf340,156 resp[(nil),0x26c2f3.23] pkey 12095363.0
   grant 0 cvt 0 mdrole 0x0 st 0x0 lst 0x20 GRANTQ rl LOCAL
   master 2 owner 1 sid 0 remote[(nil),0] hist 0x47824b07180458d
   history 0xd.0xb.0x1.0xc.0x7.0x16.0x9.0x3c.0x4.0x0.
   cflag 0x0 sender 2 flags 0x0 replay# 0 abast (nil).x0.1 dbmap (nil)
   disk: 0x0000.00000000 write request: 0x0000.00000000
   pi scn: 0x0000.00000000 sq[(nil),(nil)]
   msgseq 0x0 updseq 0x0 reqids[175,0,0] infop (nil) lockseq x75f7
   pkey 12095363.0
   hv 101 [stat 0x0, 2->2, wm 32768, RMno 0, reminc 30, dom 0]
   kjga st 0x4, step 0.0.0, cinc 30, rmno 16556, flags 0x0
   lb 0, hb 0, myb 219230, drmb 219230, apifrz 0
 GCS CLIENT END
BH (0x223e2df98) file#: 35 rdba: 0x08e6c2f3 (35/2540275) class: 4 ba: 0x222e22000
  set: 45 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
  dbwrid: 0 obj: 12095363 objn: 1688026 tsn: 13 afn: 35 hint: f
  hash: [0x4264e7720,0xbfdbe068] lru: [0x355d91558,0x275e88e90]
  lru-flags: moved_to_tail on_auxiliary_list
  ckptq: [NULL] fileq: [NULL] objq: [NULL] objaq: [NULL]
  st: FREE md: NULL tch: 0 lfb: 33 le: (nil)
  flags:
  cr pin refcnt: 0 sh pin refcnt: 0
GLOBAL CACHE ELEMENT DUMP (address: 0x1bffcf2c8):
  id1: 0x26c2f3 id2: 0x23 pkey: OBJ#12095363 block: (35/2540275)
  lock: C rls: 0x0 acq: 0x0 latch: 6
  flags: 0x21 fair: 0 recovery: 0 fpin: 'ktewh25: kteinicnt'
  bscn: 0x9d4.1f3ca24 bctx: (nil) write: 0 scan: 0x0
  lcp: (nil) lnk: [NULL] lch: [0x428f7fa70,0x243f54de8]
  seq: 1415 hist: 329 144:6 289 7 352 197 51 39 74:2 334 297
 GCS CLIENT 0x1bffcf340,156 resp[(nil),0x26c2f3.23] pkey 12095363.0
   grant 0 cvt 0 mdrole 0x0 st 0x0 lst 0x20 GRANTQ rl LOCAL
   master 2 owner 1 sid 0 remote[(nil),0] hist 0x47824b07180458d
   history 0xd.0xb.0x1.0xc.0x7.0x16.0x9.0x3c.0x4.0x0.
   cflag 0x0 sender 2 flags 0x0 replay# 0 abast (nil).x0.1 dbmap (nil)
   disk: 0x0000.00000000 write request: 0x0000.00000000
   pi scn: 0x0000.00000000 sq[(nil),(nil)]
   msgseq 0x0 updseq 0x0 reqids[175,0,0] infop (nil) lockseq x75f7
   pkey 12095363.0
   hv 101 [stat 0x0, 2->2, wm 32768, RMno 0, reminc 30, dom 0]
   kjga st 0x4, step 0.0.0, cinc 30, rmno 16556, flags 0x0
   lb 0, hb 0, myb 219230, drmb 219230, apifrz 0
 GCS CLIENT END
DUMP REDO
 Opcodes *.*
 DBAs (file#, block#):
 (35, 2540275) .
 SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
 **NOTE: Only Dumping Redo less then 12 hours**
 Times: 10/08/2012 16:35:57 thru eternity
Initial buffer sizes: read 1024K, overflow 832K, change 805K

*** 2012-10-09 04:36:08.881
 SCN Start Scan Point: scn: 0x09d4.0eccd5dc (10806386021852)
Initial buffer sizes: read 1024K, overflow 832K, change 805K
Initial buffer sizes: read 1024K, overflow 832K, change 805K
 INCARNATION:
  START: scn: 0x09ce.ae8e1562 (10783296460130) Timestamp:  08/08/2012 15:44:20
  END: scn: 0xffff.ffffffff

*** 2012-10-09 04:36:09.890
 descrip:"Thread 0001, Seq# 0000014678, SCN 0x09d40eccd5dc-0x09d40ece65c8"

*** 2012-10-09 04:36:10.660
 descrip:"Thread 0002, Seq# 0000015049, SCN 0x09d40ecccd67-0x09d40ece2828"

REDO RECORD - Thread:1 RBA: 0x003956.00000014.00d4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0eccdc28 SUBSCN:  1 10/09/2012 00:00:50
(LWN RBA: 0x003956.00000013.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0eccdc25)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=7922030

REDO RECORD - Thread:2 RBA: 0x003ac9.000001d5.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd0027 SUBSCN:  1 10/09/2012 00:01:37
(LWN RBA: 0x003ac9.000001d5.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd0026)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12105691

REDO RECORD - Thread:1 RBA: 0x003956.00000649.00d4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd0cb0 SUBSCN:  1 10/09/2012 00:01:42
(LWN RBA: 0x003956.00000648.0010 LEN: 0004 NST: 04d SCN: 0x09d4.0ecd0cab)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12105692

REDO RECORD - Thread:2 RBA: 0x003ac9.00000300.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd0e45 SUBSCN:  1 10/09/2012 00:01:42
(LWN RBA: 0x003ac9.00000300.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd0e42)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014033

REDO RECORD - Thread:1 RBA: 0x003956.00000665.008c LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd0f3e SUBSCN:  1 10/09/2012 00:01:43
(LWN RBA: 0x003956.00000665.0010 LEN: 0004 NST: 04d SCN: 0x09d4.0ecd0f3a)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014643

REDO RECORD - Thread:2 RBA: 0x003ac9.000004b4.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd2235 SUBSCN:  1 10/09/2012 00:01:47
(LWN RBA: 0x003ac9.000004b4.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd2232)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014647

REDO RECORD - Thread:1 RBA: 0x003956.00000997.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd22a2 SUBSCN:  1 10/09/2012 00:01:47
(LWN RBA: 0x003956.00000997.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd229f)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014663

REDO RECORD - Thread:2 RBA: 0x003ac9.000004c5.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd23c0 SUBSCN:  1 10/09/2012 00:01:47
(LWN RBA: 0x003ac9.000004c5.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd23be)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014648

REDO RECORD - Thread:1 RBA: 0x003956.000009bc.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd24a4 SUBSCN:  1 10/09/2012 00:01:47
(LWN RBA: 0x003956.000009bc.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd24a2)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014674

REDO RECORD - Thread:2 RBA: 0x003ac9.000004f5.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd25fb SUBSCN:  1 10/09/2012 00:01:47
(LWN RBA: 0x003ac9.000004f5.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd25f6)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014652

REDO RECORD - Thread:1 RBA: 0x003956.000009e2.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd27c1 SUBSCN:  1 10/09/2012 00:01:48
(LWN RBA: 0x003956.000009e2.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd27ba)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12105694

REDO RECORD - Thread:1 RBA: 0x003956.000009e2.0084 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd27c2 SUBSCN:  1 10/09/2012 00:01:48
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014676

REDO RECORD - Thread:2 RBA: 0x003ac9.000005a9.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd291b SUBSCN:  1 10/09/2012 00:01:48
(LWN RBA: 0x003ac9.000005a9.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd291b)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014656

REDO RECORD - Thread:1 RBA: 0x003956.00000a02.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd2943 SUBSCN:  1 10/09/2012 00:01:48
(LWN RBA: 0x003956.00000a02.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd2940)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014789

REDO RECORD - Thread:2 RBA: 0x003ac9.000005db.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd2c66 SUBSCN:  1 10/09/2012 00:01:49
(LWN RBA: 0x003ac9.000005db.0010 LEN: 0005 NST: 04d SCN: 0x09d4.0ecd2c64)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014783

REDO RECORD - Thread:1 RBA: 0x003956.00000a2c.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd2e59 SUBSCN:  1 10/09/2012 00:01:49
(LWN RBA: 0x003956.00000a2c.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd2e58)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014666

REDO RECORD - Thread:1 RBA: 0x003956.00000a78.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd30f9 SUBSCN:  1 10/09/2012 00:01:50
(LWN RBA: 0x003956.00000a78.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd30f9)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014679

REDO RECORD - Thread:2 RBA: 0x003ac9.000005ff.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd3176 SUBSCN:  1 10/09/2012 00:01:50
(LWN RBA: 0x003ac9.000005ff.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd3172)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014664

REDO RECORD - Thread:2 RBA: 0x003ac9.0000060e.00c4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd327f SUBSCN:  1 10/09/2012 00:01:50
(LWN RBA: 0x003ac9.0000060d.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd327b)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014665

REDO RECORD - Thread:1 RBA: 0x003956.00000b39.00c4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd32cf SUBSCN:  1 10/09/2012 00:01:50
(LWN RBA: 0x003956.00000b38.0010 LEN: 0003 NST: 04d SCN: 0x09d4.0ecd32cc)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014781

REDO RECORD - Thread:1 RBA: 0x003956.00000bc3.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd34c0 SUBSCN:  1 10/09/2012 00:01:51
(LWN RBA: 0x003956.00000bc3.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd34c0)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014680

REDO RECORD - Thread:2 RBA: 0x003ac9.00000623.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd34e3 SUBSCN:  1 10/09/2012 00:01:51
(LWN RBA: 0x003ac9.00000623.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd34e3)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014782

REDO RECORD - Thread:1 RBA: 0x003956.00000c2e.00c4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd40b1 SUBSCN:  1 10/09/2012 00:01:52
(LWN RBA: 0x003956.00000c2d.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd40ae)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014681

REDO RECORD - Thread:2 RBA: 0x003ac9.000006ae.00c4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd436a SUBSCN:  1 10/09/2012 00:01:53
(LWN RBA: 0x003ac9.000006ad.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd4367)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014685

REDO RECORD - Thread:1 RBA: 0x003956.00000c5f.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd449c SUBSCN:  1 10/09/2012 00:01:54
(LWN RBA: 0x003956.00000c5f.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd449c)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014720

REDO RECORD - Thread:2 RBA: 0x003ac9.000006c0.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd44da SUBSCN:  1 10/09/2012 00:01:54
(LWN RBA: 0x003ac9.000006c0.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd44da)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014728

REDO RECORD - Thread:1 RBA: 0x003956.00000c7b.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd455b SUBSCN:  1 10/09/2012 00:01:54
(LWN RBA: 0x003956.00000c7b.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd455b)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014725

REDO RECORD - Thread:1 RBA: 0x003956.00000cbb.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd557a SUBSCN:  1 10/09/2012 00:01:56
(LWN RBA: 0x003956.00000cbb.0010 LEN: 0007 NST: 04d SCN: 0x09d4.0ecd557a)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014738

REDO RECORD - Thread:2 RBA: 0x003ac9.00000791.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd5b8a SUBSCN:  1 10/09/2012 00:01:56
(LWN RBA: 0x003ac9.00000791.0010 LEN: 0006 NST: 04d SCN: 0x09d4.0ecd5b85)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014729

REDO RECORD - Thread:1 RBA: 0x003956.00000cfa.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd7fe3 SUBSCN:  1 10/09/2012 00:01:58
(LWN RBA: 0x003956.00000cfa.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd7fe3)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014739

REDO RECORD - Thread:2 RBA: 0x003ac9.00000899.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd8c3e SUBSCN:  1 10/09/2012 00:02:01
(LWN RBA: 0x003ac9.00000899.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd8c3e)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014736

REDO RECORD - Thread:1 RBA: 0x003956.00000d97.00c4 LEN: 0x0048 VLD: 0x01
SCN: 0x09d4.0ecd9042 SUBSCN:  1 10/09/2012 00:02:02
(LWN RBA: 0x003956.00000d96.0010 LEN: 0004 NST: 04d SCN: 0x09d4.0ecd903f)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014724

REDO RECORD - Thread:1 RBA: 0x003956.00000da7.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd9133 SUBSCN:  1 10/09/2012 00:02:02
(LWN RBA: 0x003956.00000da7.0010 LEN: 0002 NST: 04d SCN: 0x09d4.0ecd9133)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014675

REDO RECORD - Thread:1 RBA: 0x003956.00000db6.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd9243 SUBSCN:  1 10/09/2012 00:02:03
(LWN RBA: 0x003956.00000db6.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd9243)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014677

REDO RECORD - Thread:1 RBA: 0x003956.00000dc6.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd935f SUBSCN:  1 10/09/2012 00:02:03
(LWN RBA: 0x003956.00000dc6.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd935d)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=17 objd=12014668

REDO RECORD - Thread:2 RBA: 0x003ac9.00000919.0010 LEN: 0x0074 VLD: 0x05
SCN: 0x09d4.0ecd9488 SUBSCN:  1 10/09/2012 00:02:03
(LWN RBA: 0x003ac9.00000919.0010 LEN: 0001 NST: 04d SCN: 0x09d4.0ecd9487)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry”
Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2012
Added on Oct 9 2012
#database, #dba, #general-database-discussions
6 comments
1,690 views