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: Displaying redo log file content

Re: Displaying redo log file content

From: Mehul Zaveri <mehulzaveri_at_hotmail.com>
Date: Thu, 23 Sep 1999 19:46:04 +0400
Message-ID: <7sdhmk$sa015@news.emirates.net.ae>


I think you can use some event level.
I read this info somewhere on www.solveit.net (I hope I am correctly redirecting you...)

Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com> wrote in message news:7sd87e$43i7_at_news.abbott.com...
> Uwe Schneider wrote in message <37E9E5AB.94188F11_at_xlink.net>...
> >Hi experts,
> >
> >is there a way to display the content of redo log files/archives (Oracle
> >7.3 WG server, Solaris) other than browsing the binary content?
> >
> >I am very interested in the operations which led to a huge amount of log
> >archives over night.
> >
> >Best regards!
> >--
> >uwe.schneider_at_xlink.net
>
> You can use this command:
>
> SVRMGR> alter system dump logfile 'DUA2:[ORACLE7.MYDB]ORA_LOG4A.RDO';
>
> Then look in the trace directory for the dumped file.
>
> Hope that helps
>
> Graham
>
>
> --
> Empowerment - delegating the responsibility but not the authority.
> -------------------------------
>
> Opinions expressed do not necessarily reflect those of Abbott
Laboratories.
>
>
Received on Thu Sep 23 1999 - 10:46:04 CDT

Original text of this message

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