Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Archived logs Miss Rate?
When they are not in the archive log destination they are seen as missing by backup, at least by rman. Maybe that is why is seemed like there was such a high % of missing files. But I would still ask for an explanation from the DBA who did the analysis.
HTH,
Ruth
----- Original Message -----
To: "LazyDBA mailing list" <oracledba_at_lazydba.com>
Sent: Thursday, May 10, 2001 12:16 PM
>
> Here is our archivelog house keeping strategy:
> Archived logs are backed up approximately every 30 minutes and are then
> moved to a different filesystem ARCDATA. A Unix shell script verfies
> the ARCDATA filesystem to make sure it does not run out of space by using
> a filesystem high water mark (90%). If the filesystem which contains
ARCDATA has reached
> the high water mark, it will delete the archived redo logs from ARCDATA.
>
> Sergio
>
>
> "Hately, Mike" <mzh27061_at_GlaxoWellcome.co.uk> wrote:
> That's all I could think of too, Jay but the 'percentage' of misses is
> fairly immaterial isn't it?
> If you overwrite one log file before copying it then you may as well throw
> them all away because you're scuppered.
>
> Cheers,
> Mike
>
> > -----Original Message-----
> > From: Jay Weinshenker [SMTP:jweinshe_at_concentric.net]
> > Sent: 10 May 2001 16:46
> > To: Hately, Mike; LazyDBA mailing list
> > Subject: RE: Archived logs Miss Rate?
> >
> > Sounds to me like they are saying you are creating archive logs, but
that
> > you may be deleting the archive logs before backing them up to tape or
> > such...
> >
> > that would cause you to have to revisit each transaction since the last
> > good backup, as you would be missing archive logs...
> >
> > J
> >
>
> --------
> Think you know someone who can answer the above question? Forward it to
them!
> To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Auctions - Click and bid on cool stuff like Dave Matthews Band
Tickets & more!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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).Received on Thu May 10 2001 - 12:23:18 CDT