Re: Oracle archive redo log question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 13 May 2001 09:30:59 +1000
Message-ID: <3afdc7ba$1@news.iprimus.com.au>

Yes it does. And you can even mine the Logs of a version 8.0 database, even though it was only released with 8.1.5. And the log can be offline or online, hot or cold, big or small.

Regards
HJR

--


"Sathish B" <SathishRani_at_home.com> wrote in message
news:YjdL6.7931$R5.985447_at_news1.rdc1.va.home.com...


> Does LogMiner Tool work on an archive redo log of DB1 on DB2 ?

> I doubt if it will work .

>

> - Sathish B

>

> "Paul Drake" <paled_at_home.com> wrote in message

> news:3AFD54F8.A61753F8_at_home.com...

> > angry_garden_salad_at_yahoo.com wrote:

> > >

> > > HI,

> > > What the heck is in these archive redo logs

> > > anyway?  A bunch of overhead junk?  I thought the redo log switch did

 not happen


> > > until the redo log filled up.  Doesn't say inserting 100M of data into

 a


> > > database produce 100M of redo log information?  Or does 100M of

 inserts
 produce


> > > 1 GB of redo log information.  Is there a parameter I have messed up

 somewhere?


> > > I'm not having any database problems, but it looks like I'm just gonna

 need a


> > > lot of tapes.  thanks in advance....

> >

> > fire up LogMiner, and look at the archived redo log contents for

> > yourself.

> > You can even use it on a non-production database to examine logs from

> > your production db.

> >

> > have fun.

> >

> > Paul

>

>

Received on Sat May 12 2001 - 18:30:59 CDT