| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE:
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFFBD0.464B6EC2
Content-Type: text/plain;
charset="iso-8859-1"
also, i would add space to your archive log disk.
-----Original Message-----
From: Sandeep Kurliye [mailto:Sandeep.Kurliye_at_almarai.com]
Sent: Tuesday, August 01, 2000 2:41 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Well.,.. It all depends on your backup strategy.
How about increasing redo logfile size?
Sandeep.
-----Original Message----- From: Sandy Ocheltree [SMTP:ora_dba_at_hotmail.com] Sent: Tuesday, August 01, 2000 12:03 AM To: Multiple recipients of list ORACLE-L Subject: 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 athttp://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: Sandeep Kurliye INET: Sandeep.Kurliye_at_almarai.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Tue Aug 01 2000 - 10:50:48 CDT
--------------------------------------------------------------------
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).
------_=_NextPart_001_01BFFBD0.464B6EC2
Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"> <TITLE>RE: </TITLE> </HEAD> <BODY> <P><FONT SIZE=2>also, i would add space to your archive log disk.</FONT> </P> <P><FONT SIZE=2>-----Original Message-----</FONT> <BR><FONT SIZE=2>From: Sandeep Kurliye [<A HREF="mailto:Sandeep.Kurliye_at_almarai.com">mailto:Sandeep.Kurliye_at_almarai.com</A>]</FONT> <BR><FONT SIZE=2>Sent: Tuesday, August 01, 2000 2:41 AM</FONT> <BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=2>Subject: RE: </FONT> </P> <BR> <BR> <P><FONT SIZE=2>Well.,.. It all depends on your backup strategy.</FONT> </P> <P><FONT SIZE=2>How about increasing redo logfile size?</FONT> </P> <P><FONT SIZE=2>Sandeep.</FONT> </P> <BR> <P> </P> <P> <FONT SIZE=2>-----Original Message-----</FONT> <BR> <FONT SIZE=2>From: Sandy Ocheltree [SMTP:ora_dba_at_hotmail.com]</FONT> <BR> <FONT SIZE=2>Sent: Tuesday, August 01, 2000 12:03 AM</FONT> <BR> <FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT> <BR> <FONT SIZE=2>Subject: </FONT> </P> <P> <FONT SIZE=2>We've recently had a lot of problems with our archive log directory</FONT> <BR><FONT SIZE=2>filling</FONT> <BR> <FONT SIZE=2>and the database freezing. Now that I've mastered how to fix this</FONT> <BR><FONT SIZE=2>quickly,</FONT> <BR> <FONT SIZE=2>I'm wondering why I have to fix it so often. Is there some sort of</FONT> <BR> <FONT SIZE=2>optimal/minimum size for an archive log directory? We are running a</FONT> <BR><FONT SIZE=2>1</FONT> <BR> <FONT SIZE=2>terabyte db with varying amounts of activity, and the archive log</FONT> <BR><FONT SIZE=2>directory</FONT> <BR> <FONT SIZE=2>can hold up to 11G. The archived logs are being written to tape</FONT> <BR><FONT SIZE=2>every 4 hrs,</FONT> <BR> <FONT SIZE=2>but this often isn't fast enough--sometimes the directory fills in</FONT> <BR><FONT SIZE=2>an hour.</FONT> <BR> <FONT SIZE=2>Should I just increase the frequency that the logs are written to</FONT> <BR><FONT SIZE=2>tape? Add</FONT> <BR> <FONT SIZE=2>space? Any advice would be appreciated.</FONT> </P> <P> <FONT SIZE=2>Thanks,</FONT> <BR> <FONT SIZE=2>Sandy</FONT> </P> <P> <BR><FONT SIZE=2>________________________________________________________________________</FONT> <BR> <FONT SIZE=2>Get Your Private, Free E-mail from MSN Hotmail at</FONT> <BR><FONT SIZE=2>http://www.hotmail.com</FONT> </P> <P> <FONT SIZE=2>-- </FONT> <BR> <FONT SIZE=2>Author: Sandy Ocheltree</FONT> <BR> <FONT SIZE=2> INET: ora_dba_at_hotmail.com</FONT> </P> <P> <FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR> <FONT SIZE=2>San Diego, California -- Public Internet access / Mailing</FONT> <BR><FONT SIZE=2>Lists</FONT> <BR> <FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR> <FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR> <FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR> <FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR> <FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR> <FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT SIZE=2>-- </FONT> <BR><FONT SIZE=2>Author: Sandeep Kurliye</FONT> <BR><FONT SIZE=2> INET: Sandeep.Kurliye_at_almarai.com</FONT> </P> <P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT SIZE=2>--------------------------------------------------------------------</FONT> <BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
 |
 |