Re: How about tailredo?

From: <stevedhoward_at_gmail.com>
Date: 11 May 2006 07:12:02 -0700
Message-ID: <1147356722.524245.89990@g10g2000cwb.googlegroups.com>

AnySQL (d.c.b.a) wrote:
> The next step will be extract some information from the operation layer
> (5.1), which contains the segment header or object id, rowid
> information.
>
>
> AnySQL.net
> ==================
> http://www.anysql.net/en

As much as I like stuff like this (and believe me, I do), I can't ever see a need for it in practicality. The internals knowledge you gain would be extraordinary, but as Brian noted, I can never see a need for it.

Are you aware you can dump a logfile if necessary?

/****************************************************************

SQL> alter session set nls_date_format='YYYY_MM_DD HH24:MI:SS';

Session altered.

SQL> select sysdate from dual;

SYSDATE

---

2006_05_11 10:04:05

SQL> insert into t0511 values('steve foo foo');

1 row created.

SQL> commit;

Commit complete.

SQL> select ((sysdate- 1/1440)-
to_date('1988_01_01','YYYY_MM_DD'))*24*60*60 start_seconds from dual;

START_SEC

---

579348202

SQL> ALTER SYSTEM DUMP LOGFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST10G2\REDO01.LOG' TIME MIN 579348202;

System altered.

****************************************************************/

..EXTRACT FROM DUMPED LOG FILE... REDO RECORD - Thread:1 RBA: 0x000031.0000656f.0010 LEN: 0x0220 VLD: 0x0d
SCN: 0x0000.0051781e SUBSCN: 1 05/11/2006 10:04:14 CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x010041bd OBJ:50518 SCN:0x0000.00517705 SEQ: 1 OP:11.2
KTB Redo
op: 0x11 ver: 0x01
op: F xid: 0x0001.00f.000004e7 uba: 0x0080e420.02c4.1c Block cleanout record, scn: 0x0000.0051781c ver: 0x01 opt: 0x02, entries follow...
  itli: 1 flg: 2 scn: 0x0000.00516fa8
  itli: 2 flg: 2 scn: 0x0000.00517705
KDO Op code: IRP row dependencies Disabled   xtype: XA flags: 0x00000000 bdba: 0x010041bd hdba: 0x010041bb itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) size/delt: 17
fb: --H-FL-- lb: 0x1 cc: 1
null: -
col 0: [13] 73 74 65 76 65 20 66 6f 6f 20 66 6f 6f --added by me - steve foo foo

---

This I *have* had to use. I used it to show Oracle a bug in their code with LOB's and standby's about a month ago.

Like I said, cool stuff you are doing, but I can't see a need for it in practicality.

Regards,

Steve Received on Thu May 11 2006 - 09:12:02 CDT