RE: determinie contents of log files

RE: determinie contents of log files

 

  

Yeah it was introduced in 8.1 but I think it will analyze the redos of
7.3 .. Let us see if your Friend who has 7.3 can try it.

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================


-----Original Message-----
From: Ankur Shah [mailto:[Email Address Removed]
Sent: Thursday, May 30, 2002 11:02 PM
To: LazyDBA.com Discussion
Subject: Re: determinie contents of log files


Ganesh -

I have'nt worked extensively on 7.3 - but it seems that
Log miner was intriduced with 8.1 as per this Metalink
Doc

========================================

PURPOSE
This paper details the mechanics of what LogMiner does, as well as
detailing
the commands and environment it uses.

SCOPE & APPLICATION
For DBAs requiring further information about LogMiner.

The ability to provide a readable interface to the redo logs has
been asked
for by customers for a long time. The ALTER SYTSTEM DUMP LOGFILE
interface
has been around for a long time, though its usefulness outside
Support is
limited. There have been a number of third party products, e.g.
BMC's PATROL
DB-Logmaster (SQL*Trax as was), which provide some functionality in
this
area. With Oracle release 8.1 there is a facility in the Oracle
kernel to do
the same. LogMiner allows the DBA to audit changes to data and
performs
analysis on the redo to determine trends, aid in capacity planning,

Point-in-time Recovery etc.

=====================================


Regards

Ankur Shah
Oracle DBA
DHR-GA



Oracle LazyDBA home page