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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,610 views