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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Any way to look at data in archive log files?

Re: Any way to look at data in archive log files?

From: Cyril Thankappan <cyril_thank_at_india.com>
Date: Wed, 2 Aug 2000 14:53:43 -0400 (EDT)
Message-Id: <10577.113645@fatcity.com>


Hi!

rachel sorry for this, i in no way mean to contradict you. But fact is we have not been able to use it 'reliably'. 'cos sometimes the v$...contents.. view just shows no rows.

Any ideas on this?

I had tried it some time back .. .hence not able to recollect the view name..

One of my colleagues is working on it.. and is in touch with Oracle support on it..

However since 'my Oracle support' is this list only......

Thanks
------Original Message------
From: "Rachel Carmichael" <carmichr_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: August 2, 2000 7:07:52 PM GMT
Subject: Re: Any way to look at data in archive log files?

if you are running 8i -- logminer will look at the archive and redo logs

>From: Cherie_Machler_at_gelco.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Any way to look at data in archive log files?
>Date: Wed, 02 Aug 2000 06:07:31 -0800
>
>Listers,
>
>We've been having excessive redo logging of data on one of our databases
>that
>is making archives hard to control.
>The people who own the app can't figure out why so much information is
>being
>logged as they don't think the app
>should be changing that much data. They would like to actually look at the
>data
>in the archived redo logs.
>
>My boss has asked me if there is a way/tool to look at the archive logs. I
>don't know of one off the top
>of my head. Does anyone else know of a way?
>
>Any ideas would be appreciated.
>
>Thanks,
>
>Cherie
>
>
>--
>Author:
> INET: Cherie_Machler_at_gelco.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
Author: Rachel Carmichael
INET: carmichr_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


______________________________________________
Received on Wed Aug 02 2000 - 13:53:43 CDT

Original text of this message

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