Re:

Sandy,

Based on the size of this database and the amount of data being loaded, I am assuming that this in a data wharehouse.

Well, here are 4 choices that I can think of.

1. If you have disk space to spare, then definitely give your archive log destination more space. I would think that would be the easiest..
2. Backup to tape more frequently, every 2 hours instead of 4.
3. Increase the size of your redo logs so you do not switch as often. Then your archive logs will be larger of course and you may run into the problem of archive log space on disk.
4. Maybe you do not need to perform logging on every table that you are loading data into. I am not sure that this is a good option, but if you take hot backups after data loads, then you would not need so much archive log space.

My $0.02.

Tammy

Zhong Hong wrote:

> It's important to know your backup/recovery strategy for someone to really
> say anything. Would you be able to provide some info?
>
> Zhong
> It's another beautiful day!
>
> -----Original Message-----
> Sent: Monday, July 31, 2000 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
> We've recently had a lot of problems with our archive log directory filling
> and the database freezing. Now that I've mastered how to fix this quickly,
> I'm wondering why I have to fix it so often. Is there some sort of
> optimal/minimum size for an archive log directory? We are running a 1
> terabyte db with varying amounts of activity, and the archive log directory
> can hold up to 11G. The archived logs are being written to tape every 4 hrs,
> but this often isn't fast enough--sometimes the directory fills in an hour.
> Should I just increase the frequency that the logs are written to tape? Add
> space? Any advice would be appreciated.
>
> Thanks,
> Sandy
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Sandy Ocheltree
> INET: ora_dba_at_hotmail.com
>
> 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).
> --
> Author: Zhong Hong
> INET: zhong_at_cantametrix.com
>
> 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).

--
--------------------------------------
Tammy Bednar
Backup & Recovery Product Manager
Data Storage Technologies    phone:  650.506.4780
Server Technologies      fax:    509.461.4477