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: Log Switching interval

Re: Log Switching interval

From: Fred Dinage <robby_at_robby.freeserve.co.uk>
Date: Fri, 8 Oct 1999 10:22:01 +0100
Message-ID: <7tkd5q$eo$1@pheidippides.axion.bt.co.uk>


Thanks for th reply. What we want to do is not switch unless anything has been written to the online log. The alert log just gives info after the switch.
"Reiner Neumann" <reiner.neumann_at_messe.de> wrote in message news:7tkavh$7kh$1_at_mail.messe.de...
> ... also , you have to build new redo-logs with different sizes,
> until you find out the size which is good for a 3-minutes-log-switch.
>
>
>
> Reiner Neumann <reiner.neumann_at_messe.de> schrieb in im Newsbeitrag:
> 7tkaaa$7ih$1_at_mail.messe.de...
> > Easy! Just look into the alert-file , usually in your
../bdump-dírectory.
> > Every log-switch is written down there.
> >
> > It looks like this :
> > Thread 1 advanced to log sequence 160664
> > Current log# 3 seq# 160664 mem# 0:
> > /home2/oracle73/oradata/DB73/redoDB7303.log
> >
> > Current log# 3 seq# 160664 mem# 1: /home7/oracle73/redoDB7303_02.log
> > Thread 1 advanced to log sequence 160665
> > Current log# 1 seq# 160665 mem# 0:
> > /home3/oracle73/oradata/DB73/redoDB7301.log
> >
> > Current log# 1 seq# 160665 mem# 1: /home7/oracle73/redoDB7301_02.log
> > Thread 1 advanced to log sequence 160666
> > Current log# 2 seq# 160666 mem# 0:
> > /home1/oracle73/oradata/DB73/redoDB7302.log
> >
> > Current log# 2 seq# 160666 mem# 1: /home7/oracle73/redoDB7302_02.log
> >
> > Hth,
> > Reiner
> >
> >
> > Fred Dinage <robby_at_robby.freeserve.co.uk> schrieb in im Newsbeitrag:
> > 7tk8s8$rur$1_at_pheidippides.axion.bt.co.uk...
> > > Is there any way in Oracle to check how much has been written to the
log
> > > files. We want to switch the logs every 3 minutes for a hot standby
> setup
> > > and we are currently just issuing an "alter system switch logfile"
> command
> > > every 3 mins.Ideally we would only like to switch logs every 3 minutes
> > when
> > > something has actually been written to the logs. How could we check
> this??
> > >
> > > Cheers
> > >
> > > Fred Dinage
> > >
> > >
> > >
> >
> >
>
>
Received on Fri Oct 08 1999 - 04:22:01 CDT

Original text of this message

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