Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to make archivlog human readable ?

Re: How to make archivlog human readable ?

From: Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com>
Date: Mon, 20 Dec 1999 08:37:15 -0600
Message-ID: <83leuc$b75@news.abbott.com>

Michael Keppler wrote in message <83kssq$q0j_at_TGZ3>...
>Hello everybody !
>
>We are just hunting some kind of bug in one of our database
>applications. And it would be very nice if we could say what happend to
>some records at a known time two days ago. So my question is: How can we
>get the (binary) archive log into something human readable? Is it
>possible to make a query on the log to get all changes between the times
>x and y ?
>
>Ciao and Thanks, Michael.
>
>--
>Michael Keppler, MCSE, MCP+I
>IT logic GbR
>Michael.Keppler_at_gmx.de
>

SVRMGR> alter system dump logfile '<logfilename>';

HTH Graham

--
Empowerment - delegating the responsibility but not the authority.


Opinions expressed do not necessarily reflect those of Abbott Laboratories. Received on Mon Dec 20 1999 - 08:37:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US