There could be lot of Archived files due to several
factors - Small size of redo logs, for one.
Anyway, to look at the Archived logs, I think you
could use Logminer available with version 8.1.x and I
believe you could also build the data dictionary in
version 8.0.x using 8.1.x scripts. Haven't used it
yet, but you could search Oracle docs or Metalink to
get more info.
- Deepak
- James Bullard <jbullard_at_onvia.com> wrote:
>
>
> -----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).
Oracle DBA,
Minneapolis, MN
USA
Received on Wed Aug 02 2000 - 13:27:53 CDT
