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: Sais, Gene <gsais_at_qode.com>
Date: Wed, 2 Aug 2000 13:26:10 -0400
Message-Id: <10577.113630@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFFCA6.C3B6C3EE
Content-Type: text/plain;

        charset="iso-8859-1"

i am sure there are tools out there, but a quick and dirty way is to run strings against it.

strings filename.arc

-----Original Message-----
From: James Bullard [mailto:jbullard_at_onvia.com] Sent: Wednesday, August 02, 2000 1:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Any way to look at data in archive log files?

-----Original Message-----
Sent: Wednesday, August 02, 2000 7:08 AM To: Multiple recipients of list ORACLE-L

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)..
-- 
Author: James Bullard
  INET: jbullard_at_onvia.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).

------_=_NextPart_001_01BFFCA6.C3B6C3EE
Content-Type: text/html;
	charset="iso-8859-1"


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Any way to look at data in archive log files?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>i am sure there are tools out there, but a quick and dirty way is to run strings against it.</FONT>
</P>

<P><FONT SIZE=2>strings filename.arc</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: James Bullard [<A HREF="mailto:jbullard_at_onvia.com">mailto:jbullard_at_onvia.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, August 02, 2000 1:55 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: Any way to look at data in archive log files?</FONT>
</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, August 02, 2000 7:08 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

<P><FONT SIZE=2>Listers,</FONT>
</P>

<P><FONT SIZE=2>We've been having excessive redo&nbsp; logging of data on one of our databases</FONT>
<BR><FONT SIZE=2>that</FONT>
<BR><FONT SIZE=2>is making archives hard to control.</FONT>
<BR><FONT SIZE=2>The people who own the app can't figure out why so much information is being</FONT>
<BR><FONT SIZE=2>logged as they don't think the app</FONT>
<BR><FONT SIZE=2>should be changing that much data.&nbsp; They would like to actually look at the</FONT>
<BR><FONT SIZE=2>data</FONT>
<BR><FONT SIZE=2>in the archived redo logs.</FONT>
</P>

<P><FONT SIZE=2>My boss has asked me if there is a way/tool to look at the archive logs.&nbsp; I</FONT>
<BR><FONT SIZE=2>don't know of one off the top</FONT>
<BR><FONT SIZE=2>of my head.&nbsp; Does anyone else know of a way?</FONT>
</P>

<P><FONT SIZE=2>Any ideas would be appreciated.</FONT>
</P>

<P><FONT SIZE=2>Thanks,</FONT>
</P>

<P><FONT SIZE=2>Cherie</FONT>
</P>
<BR>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2>&nbsp; INET: Cherie_Machler_at_gelco.com</FONT>
</P>

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

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
Received on Wed Aug 02 2000 - 12:26:10 CDT

Original text of this message

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