Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
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.4477Received on Mon Jul 31 2000 - 18:51:34 CDT
![]() |
![]() |