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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle archive redo log question

Re: Oracle archive redo log question

From: Sathish B <SathishRani_at_home.com>
Date: Sat, 12 May 2001 16:14:48 GMT
Message-ID: <YjdL6.7931$R5.985447@news1.rdc1.va.home.com>

Does LogMiner Tool work on an archive redo log of DB1 on DB2 ? I doubt if it will work .

"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 - 11:14:48 CDT

Original text of this message

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