25847 oracle,Oracle 10g LOGMNR挖掘日志

136

SQL> select sql_redo from v$logmnr_contents;

SQL_REDO

------------------------------------------------------------------------------------------------------------------------

set transaction read write;

insert into

"SYS"."OBJ$"("OBJ#","DATAOBJ#","OWNER#","NAME","NAMESPACE","SUBNAME","TYPE#","CTIME","MTIME","STIME","STATUS

","REMOTEOWNER","LINKNAME","FLAGS","OID$","SPARE1","SPARE2","SPARE3","SPARE4","SPARE5","SPARE6")

values ('25847','25847'

,'31','EYGLE','1',NULL,'2',TO_DATE('01-JUL-09',

'DD-MON-RR'),TO_DATE('01-JUL-09', 'DD-MON-RR'),TO_DATE('01-JUL-09',

'DD-

MON-RR'),'1',NULL,NULL,'0',NULL,'6','1',NULL,NULL,NULL,NULL);

set transaction read write;

update "SYS"."CON$" set "CON#" = '10823' where "CON#" = '10822' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

SQL_REDO

------------------------------------------------------------------------------------------------------------------------

update "SYS"."CON$" set "CON#" = '10824' where "CON#" = '10823' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

update "SYS"."CON$" set "CON#" = '10825' where "CON#" = '10824' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

update "SYS"."CON$" set "CON#" = '10826' where "CON#" = '10825' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

update "SYS"."CON$" set "CON#" = '10827' where "CON#" = '10826' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

update "SYS"."CON$" set "CON#" = '10828' where "CON#" = '10827' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

set transaction read write;

update "SYS"."CON$" set "CON#" = '10829' where "CON#" = '10828' and

ROWID = 'AAAAAcAABAAAACqAAM';

commit;

create table eygle as select * from dba_users;

set transaction read write;

Unsupported

update "SYS"."TSQ$" set "TS#" = '0', "GRANTOR#" = '43080', "BLOCKS"

= '0', "MAXBLOCKS" = '0', "PRIV1" = '0', "PRIV2" = '

0' where "TS#" = '0' and "GRANTOR#" = '43072' and "BLOCKS" = '0'

and "MAXBLOCKS" = '0' and "PRIV1" = '0' and "PRIV2" = '

0' and ROWID = 'AAAAAKAABAAAABbAAF';

commit;

set transaction read write;

SQL> exec dbms_logmnr.end_logmnr

PL/SQL procedure successfully completed.