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 OPinterested, 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 comment

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 )

Connecting to %s

%d bloggers like this: