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: determining ARCHIVELOG sizes

Re: determining ARCHIVELOG sizes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 15 Jul 1999 20:03:48 +0800
Message-ID: <378DCE24.E91@yahoo.com>


Vick wrote:
>
> Hey everyone,
>
> On a WinNT4.0 with Oracle 7.3.4.4.0 DB that will probably end up with a
> whole lot of data (old DB used to be 42GB) about how much physical
> space should I allocate for Archivelogs?
> I know that once I do a cold backup I can delete the physical files and
> then once I restart I will archive again (LOG_ARCHIVE_START=TRUE in
> init.ora). I want to get an idea of how much space I might end up
> needing since I will only be able to cold backup once a month.
>
> And, could anyone suggest where to get the right agents to do batch
> mode tape backup to Cheyenne arcserve DLT tape drive in NT? I'm
> starting to really like the idea of daily, automatic, incremental
> backups... being a newbie can be fun. I just found out I can automate
> all this in OEM-- but only if I have the agents. Neat stuff...
>
> TIA,
> Vick
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Why not hot backup and remove your archive logs daily (or weekly or whatever frequency you need ????)

--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 15 1999 - 07:03:48 CDT

Original text of this message

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