kalau yg dimaksud mau mencari data redo, mungkin begini caranya:
create table t1 (a number,b number, c varchar2(10)) tablespace users;
select extent_id,block_id,blocks from dba_extents where segment_name='T1';
select file_id,file_name from dba_data_files where tablespace_name='USERS';
insert into t1 values (1,1,'A');
insert into t1 values (1,1,'B');
insert into t1 values (1,1,'ABC');
insert into t1 values (1,2,'ABCD');
insert into t1 values (1,2,'ABCDE');
commit;
select * from v$log where status='CURRENT';
select group#,member from v$logfile;
-- syntak dump data di archivelog / redulog
ALTER SYSTEM DUMP LOGFILE 'filename'
DBA MIN fileno . blockno
DBA MAX fileno . blockno;
ALTER SYSTEM DUMP LOGFILE 'E:\ORACLE\ORADATA\ORCL\REDO03.LOG' DBA MIN
4 969 DBA MAX 4 973;
lfdba: CHANGE #10 TYP:0 CLS: 1 AFN:4 DBA:0x010003d0
SCN:0x0000.00141b6f SEQ: 1 OP:11.2
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x000e.001.0000029c uba: 0x0700057e.00ce.30
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010003d0 hdba: 0x010003cb
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) size/delt: 11
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 02
col 1: [ 2] c1 02
col 2: [ 1] 41
CHANGE #11 TYP:0 CLS:43 AFN:28 DBA:0x07000019 SCN:0x0000.00141b67 SEQ: 2 OP:5.2
ktudh redo: slt: 0x0001 sqn: 0x0000029c flg: 0x0012 siz: 104 fbi: 0
uba: 0x0700057e.00ce.30 pxid: 0x0000.000.00000000
CHANGE #12 TYP:0 CLS: 1 AFN:4 DBA:0x010003d0 SCN:0x0000.00141b6f SEQ: 2 OP:11.2
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x0700057e.00ce.31
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010003d0 hdba: 0x010003cb
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) size/delt: 11
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 02
col 1: [ 2] c1 02
col 2: [ 1] 42
CHANGE #13 TYP:0 CLS: 1 AFN:4 DBA:0x010003d0 SCN:0x0000.00141b6f SEQ: 3 OP:11.2
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x0700057e.00ce.32
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010003d0 hdba: 0x010003cb
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) size/delt: 13
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 02
col 1: [ 2] c1 02
col 2: [ 3] 41 42 43
CHANGE #14 TYP:0 CLS: 1 AFN:4 DBA:0x010003d0 SCN:0x0000.00141b6f SEQ: 4 OP:11.2
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x0700057e.00ce.33
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010003d0 hdba: 0x010003cb
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3) size/delt: 14
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 02
col 1: [ 2] c1 03
col 2: [ 4] 41 42 43 44
kalau kita decode pada bagian ini:
--create table t1 (a number,b number, c varchar2(10)) tablespace users;
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) size/delt: 11
fb: --H-FL-- lb: 0x1 cc: 3
null: ---
col 0: [ 2] c1 02 << 1 decimal
col 1: [ 2] c1 02 << 1 decimal
col 2: [ 1] 41 << 65 decimal = A di table ascii
--
thanks and regards
ujang | oracle dba | mysql dba
http://ora62.wordpress.com
On Mon, Mar 30, 2009 at 10:39 AM, deded syafril <[email protected]> wrote:
> Hi,
> ada yang pernah bisa baca dan ekstrak sebuah file redulog ?
>
> tks
>
> Deded
>
>
