Oracle Redo Codes in table format.

Thanks to Jonathan Lewis

https://jonathanlewis.wordpress.com/2017/07/25/redo-op-codes/

And http://www.askmaclean.com/archives/redo-opcode-reference.html

I was able to create this table because of the links above.  It’s just an attempt to make it easier to find the codes.  If anybody reads this and is interested, I can post the spreadsheet that this based on.  Also I have a little tool that utilizes these codes to do some simple, but handy, parsing of a dumped redo log.  See my post here for more details:

https://wordpress.com/post/markadamsoracleandsqlserver.wordpress.com/48

 

Layer Layer.opcode   Description
Layer 1 Transaction Control – KCOCOTCT      
  1 .1 Opcode 1 KTZ ForMaT block – KTZFMT
  1 .2 Opcode 2 Transaction Z Redo Data Header – KTZRDH
  1 .3 Opcode 3 KTZ Allocate Record Callback – KTZARC
  1 .4 Opcode 4 KTZ REPlace record value – KTZREP
  1 .5 Opcode 5 KTZ Undo for RePlace – KTZURP
Layer 2 Transaction Read – KCOCOTRD      
Layer 3 Transaction Update – KCOCOTUP      
Layer 4 Transaction Block – KCOCOTBK [ktbcts.h]      
  4 .1 Opcode 1 Block cleanout opcode – KTBOPCLN
  4 .2 Opcode 2 physical cleanout opcode – KTBPHCLN
  4 .3 Opcode 3 single array change – KTBSARC
  4 .4 Opcode 4 Multiple changes to an array – KTBMARC
  4 .5 Opcode 5 format block – KTBOPFMB
  4 .6 Opcode 6 commit-time block cleanout opcode – KTBOPBCC
  4 .7 Opcode 7 ITL cleanout callback – KTBOPCLNL
  4 .8 Opcode 8 Transaction Block Redo Block Commit Cleanout – KTBOPBCCL
Layer 5 Transaction Undo – KCOCOTUN [ktucts.h]      
  5 .1 Opcode 1 Undo block or undo segment header – KTURDB
  5 .2 Opcode 2 Update rollback segment header – KTURDH
  5 .3 Opcode 3 Rollout a transaction begin – KTURBG
  5 .4 Opcode 4 Commit transaction (transaction table update) – KTURCM
– no undo record      
  5 .5 Opcode 5 Create rollback segment (format) – no undo record – KTUFMT
  5 .6 Opcode 6 Rollback record index in an undo block – KTUIRB
  5 .7 Opcode 7 Begin transaction (transaction table update) – KTUUBG
  5 .8 Opcode 8 Mark transaction as dead – KTURMR
  5 .9 Opcode 9 Undo routine to rollback the extend of a rollback segment – KTUUAE
  5 .10 Opcode 10 Redo to perform the rollback of extend of rollback segment – KTUREH
to the segment header.      
  5 .11 Opcode 11 Rollback DBA in transaction table entry – KTUBRB
  5 .12 Opcode 12 Change transaction state (in transaction table entry) – KTURST
  5 .13 Opcode 13 Convert rollback segment format (V6 -> V7) – KTURCT
  5 .14 Opcode 14 Change extent allocation parameters in a rollback segment – KTURUC
  5 .15 Opcode 15 Undo Redo ConverT transaction table – KTURCTS
  5 .16 Opcode 16 KTU – Redo for ConverT to Unlimited extents format – KTURCTU
  5 .17 Opcode 17 KTU Redo – Convert for extent Move in extent map in – KTURCTM
unlimited format to segment header      
  5 .18 Opcode 18 Transaction Undo segment Redo set Parent Xid – KTURPX
  5 .19 Opcode 19 Transaction start audit log record – KTUTSL
  5 .20 Opcode 20 Transaction continue audit log record – KTUTSC
  5 .21 Opcode 21 Transaction Control Redo ConverT undo seg Down to 8.0 format- KTURCVD
  5 .22 Opcode 22 Transaction Redo – PHysical Changes – KTURPHC
  5 .23 Opcode 23 Disable Block level Recovery – KTURDBR
  5 .24 Opcode 24 Kernel Transaction Undo Relog CHanGe – KTURLGU
  5 .25 Opcode 25 Join sub Transaction – KTURJT
  5 .26 Opcode 26 Undo STopper undo callback – KTUUST
  5 .27 Opcode 27 Transaction Control System Managed us Format – KTUSMFMT
  5 .28 Opcode 28 Undo Need To Propagate – KTUUNTP askmaclean.com
  5 .29 Opcode 29 big undo – KTUBDB
  5 .30 Opcode 30 change ondisk state for a distributed transaction – KTURCDTS
  5 .31 Opcode 31 Flashback Archive Txn Table Redo Callback – KTUFATTRC
  5 .32 Opcode 32 Flashback Archive Txn Table Redo Set – KTUFATTRS
  5 .33 Opcode 33 change notification commit marker – KTUCHNF
  5 .34 Opcode 34 NTP bit for change notfn – KTUQCNTTRC
  5 .35 Opcode 35 Flashback Archive Collect Txn Table Redo Set – KTUFACTTRS
Layer 6 Control File – KCOCODCF [tbs.h]      
  6 .1 Opcode 1 TaBleSpace Remove DataFile – TBSCRDF
  6 .2 Opcode 2 TaBleSpace Add DataFile – TBSCADF
  6 .3 Opcode 3 TaBleSpace OFfLine – TBSCOFL
  6 .4 Opcode 4 TaBleSpace ONLine – TBSCONL
  6 .5 Opcode 5 TaBleSpace ReaD-Write – TBSCRDW
  6 .6 Opcode 6 TaBleSpace ReaD-Only – TBSCRDO
  6 .7 Opcode 7 TaBleSpace Remove TableSpace – TBSCRTS
  6 .8 Opcode 8 TaBleSpace Add TableSpace – TBSCATS
  6 .9 Opcode 9 TaBleSpace Undo TsPitr – TBSCUTP
  6 .10 Opcode 10 TaBleSpace undo plugged datafile convert – TBSCUCV
  6 .11 Opcode 11 Tablespace Undo Rename – TBSCREN
Layer 10 INDEX – KCOCODIX [kdi.h]      
  10.1 Opcode 1 load index block (Loader with direct mode) – KDICPDO
  10.2 Opcode 2 Insert leaf row – KDICLIN
  10.3 Opcode 3 Purge leaf row – KDICLPU
  10.4 Opcode 4 Mark leaf row deleted – KDICLDE
  10.5 Opcode 5 Restore leaf row (clear leaf delete flags) – KDICLRE
  10.6 Opcode 6 Lock index block – KDICLOK
  10.7 Opcode 7 Unlock index block – KDICULO
  10.8 Opcode 8 Initialize new leaf block – KDICLNE
  10.9 Opcode 9 Apply Itl Redo – KDICAIR
  10.10 Opcode 10 Set leaf block next link – KDICLNX
  10.11 Opcode 11 Set leaf block previous link – KDICLPR
  10.12 Opcode 12 Init root block after split – KDICRSP
  10.13 Opcode 13 Make leaf block empty – KDICLEM
  10.14 Opcode 14 Restore block before image – KDICIMA
  10.15 Opcode 15 Branch block row insert – KDICBIN
  10.16 Opcode 16 Branch block row purge – KDICBPU
  10.17 Opcode 17 Initialize new branch block – KDICBNE
  10.18 Opcode 18 Update keydata in row – KDICLUP
  10.19 Opcode 19 Clear row’s split flag – KDICLCL
  10.20 Opcode 20 Set row’s split flag – KDICLSE
  10.21 Opcode 21 General undo above the cache (undo) – KDICUGE
  10.22 Opcode 22 Undo operation on leaf key above the cache (undo) – KDICULK
  10.23 Opcode 23 Restore block to b-tree – KDICREB
  10.24 Opcode 24 Shrink ITL (transaction entries) – KDICSIT
  10.25 Opcode 25 Format root block redo – KDICFRB
  10.26 Opcode 26 Undo of format root block (undo) – KDICUFB
  10.27 Opcode 27 Redo for undo of format root block – KDICUFR
  10.28 Opcode 28 Undo for migrating block – KDICUMG
  10.29 Opcode 29 Redo for migrating block – KDICMG
  10.30 Opcode 30 IOT leaf block nonkey update – KDICLNU
  10.31 Opcode 31 Direct load root redo – KDICDLR
  10.32 Opcode 32 Combine operation for insert and restore rows – KDICCOM
  10.33 Opcode 33 Temp index redo apply – KDICTIX askmaclean.com
  10.34 Opcode 34 Remove block from b-tree and empty block – KDICFRE
  10.35 Opcode 35 – KDICLCU
  10.36 Opcode 36 Supplemental logging – KDICLMN
  10.37 Opcode 37 Undo of non-key updates – KDICULN
  10.38 Opcode 38 Logical non-key update – KDICICU
  10.39 Opcode 39 Branch update range – KDICBUR
  10.40 Opcode 40 Branch DBA update – KDICBDU
Layer 11 Row Access – KCOCODRW [kdocts.h]      
  11.1 Opcode 1 Interpret Undo Record (Undo) – KDOIUR
  11.2 Opcode 2 Insert Row Piece – KDOIRP
  11.3 Opcode 3 Drop Row Piece – KDODRP
  11.4 Opcode 4 Lock Row Piece – KDOLKR
  11.5 Opcode 5 Update Row Piece – KDOURP
  11.6 Opcode 6 Overwrite Row Piece – KDOORP
  11.7 Opcode 7 Manipulate First Column (add or delete the 1st column) – KDOMFC
  11.8 Opcode 8 Change Forwarding address – KDOCFA
  11.9 Opcode 9 Change the Cluster Key Index – KDOCKI
  11.10 Opcode 10 Set Key Links- KDOSKL
Change the forward & backward key links on a cluster key      
  11.11 Opcode 11 Quick Multi-Insert (ex
  11.12 Opcode 12 Quick Multi-Delete – KDOQMD
  11.13 Opcode 13 Toggle Block Header flags – KDOTBF
  11.14 Opcode 14 KDODSC
  11.15 Opcode 15 KDOMBC
  11.16 Opcode 16 Logminer support – RM for rowpiece with only logminer columns – KDOLMN
  11.17 Opcode 17 Logminer support – RM for LOB id key information – KDOLLB
  11.18 Opcode 18 Logminer support – RM for LOB operation errors – KDOLBE
  11.19 Opcode 19 Logminer support – array updates – KDOURA
  11.20 Opcode 20 Logminer support – KDOSHK
  11.21 Opcode 21 Logminer support – KDOURP2
  11.22 Opcode 22 Logminer support – KDOCMP
  11.23 Opcode 23 Logminer support – KDODCU
  11.24 Opcode 24 Logminer support – KDOMRK
  11.25 Opcode 25 Logminer support – KDOAIR
Layer 12 Cluster – KCOCODCL [?]      
Layer 13 Transaction Segment – KCOCOTSG [ktscts.h]      
  13.1 Opcode 1 Data Segment Format – KTSDSF
  13.2 Opcode 2 format free list block – KTSFFB
  13.3 Opcode 3 redo for convert to unlimited extents format – KTSRCTU
  13.4 Opcode 4 fix segment header by moving its extent to ext 0 – KTSRFSH
  13.5 Opcode 5 format data block – KTSFRBFMT
  13.6 Opcode 6 set link value on block – KTSFRBLNK
  13.7 Opcode 7 freelist related fgroup/segheader redo – KTSFRGRP
  13.8 Opcode 8 freelist related fgroup/segheader undo – KTSFUGRP
  13.9 Opcode 9 undo for linking block to xnt freelist – KTSFUNLK
  13.10 Opcode 10 BITMAP – format segment header – KTSBSFO
  13.11 Opcode 11 BITMAP – format bitmap block – KTSBBFO
  13.12 Opcode 12 BITMAP – format bitmap index block – KTSBIFO
  13.12 Opcode 12 BITMAP – format bitmap index block – KTSBIFO
  13.13 Opcode 13 BITMAP – redo for bmb – KTSBBREDO
  13.14 Opcode 14 BITMAP – undo for BMB – KTSBBUNDO
  13.15 Opcode 15 BITMAP – redo for index map – KTSBIREDO
  13.16 Opcode 16 BITMAP – undo for index map – KTSBIUNDO
  13.17 Opcode 17 Bitmap Seg – format segment Header – KTSPHFO
  13.18 Opcode 18 Bitmap Seg – format First level bitmap block – KTSPFFO
  13.19 Opcode 19 Bitmap Seg – format Second level bitmap block – KTSPSFO
  13.20 Opcode 20 Bitmap Seg – format Third level bitmap block – KTSPTFO
  13.21 Opcode 21 Bitmap Seg – format data block – KTSPBFO
  13.22 Opcode 22 Bitmap Seg – Redo for L1 bmb – KTSPFREDO
  13.23 Opcode 23 Bitmap Seg – Undo for L1 BMB – KTSPFUNDO
  13.24 Opcode 24 Bitmap Seg – Redo for L2 bmb – KTSPSREDO
  13.25 Opcode 25 Bitmap Seg – Undo for L2 BMB – KTSPSUNDO
  13.26 Opcode 26 Bitmap Seg – Redo for L3 bmb – KTSPTREDO
  13.27 Opcode 27 Bitmap Seg – Undo for L3 BMB – KTSPTUNDO
  13.28 Opcode 28 Bitmap Seg – Redo for pagetable segment header block – KTSPHREDO
  13.29 Opcode 29 Bitmap Seg – Undo for pagetable segment header block – KTSPHUNDO
  13.30 Opcode 30 Bitmap Seg – format L1 BMB for LOB segments – KTSPLBFFO
  13.31 Opcode 31 Bitmap Seg – Shrink redo for L1 – KTSKFREDO
  13.32 Opcode 32 Bitmap Seg – Shrink redo for segment header – KTSKHREDO
  13.33 Opcode 33 Bitmap Seg – Shrink redo for extent map blk – KTSKEREDO
  13.34 Opcode 34 Bitmap Seg – Shrink undo for segment header – KTSKHUNDO
  13.35 Opcode 35 Bitmap Seg – Shrink undo for L1 – KTSKFUNDO
  13.36 Opcode 36 Bitmap Seg shrink related – KTSKSREDO
  13.37 Opcode 37 Bitmap Seg shrink related – KTSKSUNDO
  13.38 Opcode 38 Bitmap Seg shrink related – KTSKTREDO
  13.39 Opcode 39 Bitmap Seg shrink related – KTSKTUNDO
  13.40 Opcode 40 Bitmap Seg – Shrink redo for extent map blk – KTSKEUNDO
  13.41 Opcode 41 NGLOB format opcode Extent Header – KTSLEFREDO
  13.42 Opcode 42 NGLOB format opcode Persistent Undo – KTSLPFREDO
  13.43 Opcode 43 NGLOB format opcode Hash bucket – KTSLHFREDO
  13.44 Opcode 44 NGLOB format opcode Free SPace – KTSLFFREDO
  13.45 Opcode 45 NGLOB format opcode Segment Header – KTSLSFREDO
  13.46 Opcode 46 NGLOB format opcode data block – KTSLBFREDO
  13.47 Opcode 47 NGLOB block update Extent Header redo – KTSLEUREDO
  13.48 Opcode 48 NGLOB block update Extent Header undo – KTSLEUUNDO
  13.49 Opcode 49 NGLOB block update Hash Bucket redo – KTSLHUREDO
  13.50 Opcode 50 NGLOB block update Hash Bucket undo – KTSLHUUNDO
  13.51 Opcode 51 NGLOB block update Free Space redo – KTSLFUREDO
  13.52 Opcode 52 NGLOB block update Free Space undo – KTSLFUUNDO
  13.53 Opcode 53 NGLOB block update Persistent Undo redo – KTSLPUREDO
  13.54 Opcode 54 NGLOB block update Persistent Undo undo – KTSLPUUNDO
  13.55 Opcode 55 NGLOB block update Segment Header redo – KTSLSUREDO
  13.56 Opcode 56 NGLOB block update Segment Header undo – KTSLSUUNDO
 

Layer 14 Transaction Extent – KCOCOTEX [kte.h]

     
  14.1 Opcode 1 Unlock Segment Header – KTECUSH
  14.2 Opcode 2 Redo set extent map disk LocK – KTECRLK
  14.3 Opcode 3 redo for conversion to unlimited format – KTEFRCU
  14.4 Opcode 4 extent operation redo – KTEOPEMREDO
  14.5 Opcode 5 extent operation undo – KTEOPEUNDO
  14.6 Opcode 6 extent map format redo – KTEOPEFREDO
  14.7 Opcode 7 redo – KTECNV
  14.8 Opcode 8 undo for truncate ops, flush the object – KTEOPUTRN
  14.9 Opcode 9 undo for reformat of a ctl block – KTEFUCTL
  14.10 Opcode 10 redo to facilitate above undo – KTEFRCTL
  14.11 Opcode 11 redo to clean xids in seghdr/fgb – KTECRCLN
  14.12 Opcode 12 SMU-Retention
Layer 15 Table Space – KCOCOTTS [ktt.h]      
  15.1 Opcode 1 format save undo header – KTTFSU
  15.2 Opcode 2 add save undo record – KTTSUN
  15.3 Opcode 3 move to next block – KTTNBK
  15.4 Opcode 4 point to next save undo record – KTTNAS
  15.5 Opcode 5 update saveundo blk during save undo application – KTTUSB
Layer 16 Row Cache – KCOCOQRC      
Layer 17 Recovery (REDO) – KCOCORCV [kcv.h]      
  16.1 Opcode 1 End Hot Backup – KCVOPEHB
This operation clears the hot backup      
in-progress flags in the indicated list of files      
  16.2 Opcode 2 ENable Thread – KCVOPENT
This operation creates a redo record      
signalling that a thread has been enabled      
  16.3 Opcode 3 Crash Recovery Marker – KCVOPCRM
  16.4 Opcode 4 ReSiZeable datafiles – KCVOPRSZ
  16.5 Opcode 5 tablespace ONline – KCVOPONL
  16.6 Opcode 6 tablespace OFFline – KCVOPOFF
  16.7 Opcode 7 tablespace ReaD Write – KCVOPRDW
  16.8 Opcode 8 tablespace ReaD Only – KCVOPRDO
  16.9 Opcode 9 ADDing datafiles to database – KCVOPADD
  16.10 Opcode 10 tablespace DRoP – KCVOPDRP
  16.11 Opcode 11 Tablespace PitR – KCVOPTPR
  16.12 Opcode 12 PLUgging datafiles to database – KCVOPPLG_PRE10GR2
  16.13 Opcode 13 convert plugged in datafiles – KCVOPCNV
  16.14 Opcode 14 ADding dataFiles to database – KCVOPADF_PRE10GR2
  16.15 Opcode 15 heart-beat redo – KCVOPHBR
  16.16 Opcode 16 tablespace rename – KCVOPTRN
  16.17 Opcode 17 ENable Thread – KCVOPENT_10GR2
  16.18 Opcode 18 tablespace ONline – KCVOPONL_10GR2
  16.19 Opcode 19 tablespace OFFline – KCVOPOFF_10GR2
  16.20 Opcode 20 tablespace ReaD Write – KCVOPRDW_10GR2
  16.21 Opcode 21 tablespace ReaD Only – KCVOPRDO_10GR2
  16.22 Opcode 22 PLUgging datafiles to db – KCVOPPLG_10GR2
  16.23 Opcode 23 ADding dataFiles to database – KCVOPADF_10GR2
  16.24 Opcode 24 convert plugged in datafiles – KCVOPCNV_10GR2
  16.25 Opcode 25 Tablespace PitR – KCVOPTPR_10GR2
  16.26 Opcode 26 for file drop in tablespace – KCVOPFDP
  16.27 Opcode 27 for internal thread enable – KCVOPIEN
  16.28 Opcode 28 readable standby metadata flush – KCVOPMFL
  16.29 Opcode 29 database key creation (after bumping compatible to 11g) – KCVOPDBK
  16.30 Opcode 30 ADding dataFiles to database – KCVOPADF
  16.31 Opcode 31 PLUgging datafiles to db – KCVOPPLG
  16.32 Opcode 32 for modifying space header info – KCVOPSPHUPD
  16.33 Opcode 33 TSE Masterkey Rekey – KCVOPTMR
Layer 18 Hot Backup Log Blocks – KCOCOHLB [kcb.h] / [kcb2.h]      
  18.1 Opcode 1 Log block image – KCBKCOLB
  18.2 Opcode 2 Recovery testing – KCBKCORV
  18.3 Opcode 3 Object/Range reuse – KCBKCOREU
Layer 19 Direct Loader Log Blocks – KCOCODLB [kcbl.h]      
  19.1 Opcode 1 Direct block logging – KCBLCOLB
  19.2 Opcode 2 Invalidate range – KCBLCOIR
  19.3 Opcode 3 Direct block relogging – KCBLCRLB
  19.4 Opcode 4 Invalidate range relogging – KCBLCRIR
Layer 20 Compatibility Segment operations – KCOCOKCK [kck.h]      
  20.1 Opcode 1 Format compatibility segment – KCKFCS
  20.2 Opcode 2 Update compatibility segment – KCKUCS
  20.3 Opcode 3 Update Root Dba in controlfile and file header 1 – KCKURD
  20.4 Opcode 4 Set bit in a SQL Tuning Existence Bit Vector – KCK_INV_SQL_SIG
  20.5 Opcode 5 Invalidate an SQL Statement by Signature – KCK_INV_SQL_SIG
  20.6 Opcode 6 Unauthorize cursors after sys privilege revoke – KCK_UNAUTH_CUR
Layer 21 LOB segment operations – KCOCOLFS [kdl2.h]      
  21.1 Opcode 1 Write data into ILOB data block – KDLOPWRI
Layer 22 Tablespace bitmapped file operations – KCOCOTBF [ktfb.h]      
  22.1 Opcode 1 format space header – KTFBHFO
  22.2 Opcode 2 space header generic redo – KTFBHREDO
  22.3 Opcode 3 space header undo – KTFBHUNDO
  22.4 Opcode 4 space bitmap block format – KTFBBFO
  22.5 Opcode 5 bitmap block generic redo – KTFBBREDO
Layer 23 write behind logging of blocks – KCOCOLWR [kcbb.h]      
  23.1 Opcode 1 Dummy block written callback – KCBBLWR
  23.2 Opcode 2 log reads – KCBBLRD
  23.3 Opcode 3 log DirectWrites – KCBBLDWR
Layer 24 write behind logging of blocks – KCOCOLWR [kcbb.h]      
  24.1 Opcode 1 common portion of the ddl – KRVDDL
  24.2 Opcode 2 direct load redo – KRVDLR
  24.3 Opcode 3 lob related info – KRVLOB
  24.4 Opcode 4 misc info – KRVMISC
  24.5 Opcode 5 user info – KRVUSER
  24.6 Opcode 6 direct load redo 10i – KRVDLR10
  24.7 Opcode 7 logminer undo opcode – KRVUOP
  24.8 Opcode 8 xmlredo – doc or dif – opcode – KRVXML
  24.9 Opcode 9 PL/SQL redo – KRVPLSQL
  24.10 Opcode 10 Uniform Redo Unchained – KRVURU
  24.11 Opcode 11 txn commit marker – KRVCMT
  24.12 Opcode 12 supplog marker – KRVCFF
Layer 25 Queue Related – KCOCOQUE [kdqs.h]      
  25.1 Opcode 1 undo – KDQSUN
  25.2 Opcode 2 init – KDQSIN
  25.3 Opcode 3 enqueue – KDQSEN
  25.4 Opcode 4 update – KDQSUP
  25.5 Opcode 5 delete – KDQSDL
  25.6 Opcode 6 lock – KDQSLK
  25.7 Opcode 7 min/max – KDQSMM
Layer 26 Local LOB Related – KCOCOLOB [kdli3.h]      
  26.1 Opcode 1 generic lob undo – KDLIRUNDO
  26.2 Opcode 2 generic lob redo – KDLIRREDO
  26.3 Opcode 3 lob block format redo – KDLIRFRMT
  26.4 Opcode 4 lob invalidation redo – KDLIRINVL
  26.5 Opcode 5 lob cache-load redo – KDLIRLOAD
  26.6 Opcode 6 direct lob direct-load redo – KDLIRBIMG
  26.7 Opcode 7 dummy calibration redo – KDLIRCALI
Layer 27 Block Change Tracking – KCOCOBCT [krc2.h]      
  27.1 Opcode 1 op-code for bitmap switch – KRCPBSW

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s