RE: Undo/Redo Block Dumps

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sun, 26 Nov 2000 07:29:13 +1000
Message-Id: <10691.122887@fatcity.com>

Hello San,

Maybe. I read a lot of dumps, and it does "waste" time. But the knowledge that it gives me often saves time during crises when there is no time to waste.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: aaaa wwwwww [mailto:krisibm_at_lycos.com] Sent: Saturday, 25 November 2000 13:31
To: Multiple recipients of list ORACLE-L Subject: Re: Undo/Redo Block Dumps

U R wasting UR time

San

--

On Fri, 24 Nov 2000 02:35:37
 K Gopalakrishnan wrote:


>Hi !

>

>This is definitely not a week end question...:)

>

>I have dumped some redo blocks and undo blocks for a

>transaction.. Now the part 2. How do i decrypt ?

>

>Any one there to help us?

>

>-----------------------------

>index undo for leaf key operations

>KTB Redo

>op: 0x02  ver: 0x01

>op: C  uba: 0x00800801.0059.67

>Dump kdilk : itl=2, kdxlkflg=0x1 sdc=426409604

>indexid=0x40012b block=0x0040668c

>mark leaf row deleted

>key :(9):  04 c3 03 0f 44 03 c2 11 51

>keydata/bitmap : (6):  00 40 66 79 00 8f

>*-----------------------------

>* Rec #0x2  slt: 0x61  objn: 64(0x00000040)  objd: 64

>tblspc: 0(0x00000000)

>*       Layer:  11 (Row)   opc: 1   rci 0x01

>Undo type:  Regular undo   Last buffer split:  No

>Temp Object:  No

>Tablespace Undo:  No

>rdba: 0x00000000

>*-----------------------------

>KDO undo record:

>KTB Redo

>op: 0x02  ver: 0x01

>op: C  uba: 0x00800801.0059.68

>KDO Op code: DRP  xtype: XA  bdba: 0x00406754  hdba:

>0x004000cf

>itli: 1  ispac: 0  maxfr: 4863

>tabn: 0 slot: 333(0x14d)

>*-----------------------------

>* Rec #0x3  slt: 0x61  objn: 109(0x0000006d)  objd:

>109  tblspc: 0(0x00000000)

>*       Layer:  10 (Index)   opc: 22   rci 0x02

>Undo type:  Regular undo   Last buffer split:  No

>Temp Object:  No

>Tablespace Undo:  No

>rdba: 0x00000000

>------------------------------

>

>

>

>

>=====

>Have a nice day !!

>------------------------------------------------------------

>Best Regards,

>K Gopalakrishnan,

>Bangalore, INDIA.

>

>__________________________________________________

>Do You Yahoo!?

>Yahoo! Shopping - Thousands of Stores. Millions of Products.

>http://shopping.yahoo.com/

>--

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>--

>Author: K Gopalakrishnan

>  INET: kaygopal_at_yahoo.com

>

>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

>San Diego, California        -- Public Internet access / Mailing Lists

>--------------------------------------------------------------------

>To REMOVE yourself from this mailing list, send an E-Mail message

>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

>the message BODY, include a line containing: UNSUB ORACLE-L

>(or the name of mailing list you want to be removed from).  You may

>also send the HELP command for other information (like subscribing).

>



Get FREE Email/Voicemail with 15MB at Lycos Communications at
http://comm.lycos.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: aaaa wwwwww
  INET: krisibm_at_lycos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Sat Nov 25 2000 - 15:29:13 CST