Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extract contents of archive logs
Hi
You could try and use the command
SVRMGR> connect internal
SVRMGR> alter system dump logfile <logfile name> <options>.
You can find the files to dump from
select * from v$loghist;
dumping the log will create a trace file in the trace directory. If you are looking for DML against a specific object
you can find the object id with
select obj# from obj$
where name='OBJECT_NAME' and type# = <THE OBJECT TYPE NUMBER>
/
I.E. the type number for a table is 2.
Then you can search the trace file, each transaction has a small header and the object number is identified by "obj" in Oracle 7. The trace is very verbose but you can extract the values from it that were inserted or updated, etc.
The DML is not easily readable but it should be possible to re-construct it as the log is a complete representation of each transaction.
Sorry i am not aware of any third part tools, but if you find any i would be interested in reading about them.
cheers
Pete Finnigan
www.pentest-limited.com
In article <6351e3a5.0111160811.5ac3013c_at_posting.google.com>, Andrew
Schexnaydre <aschexnaydre_at_phihelico.com> writes
>I have a 7.3.4.3 database and I am trying to extact the DML statements
>in the archive logs. How can I go about doing this? Is there any 3rd
>party tools that can help with this?
-- Pete Finnigan IT Security Consultant PenTest Limited Office 01565 830 990 Fax 01565 830 889 Mobile 07974 087 885 pete.finnigan_at_pentest-limited.com www.pentest-limited.comReceived on Fri Nov 16 2001 - 10:50:15 CST