RE: Recovery from noarchive db corrected

From: Arn Klammer <Arn.Klammer_at_austrac.gov.au>
Date: Thu, 05 Apr 2001 22:11:49 -0700
Message-ID: <F001.002E3810.20010405214025@fatcity.com>

The actual archiving of log files itself should not impact the performance of the insert jobs, unless the archiving process is slow enough to cause the database to pause while a log is archived so it can be reused. The only other reason why the developers wouldn't want it is if the space required to store the archived logs impinges on their development space; in that case, you'd have a case for getting more storage. Either way, the inability to recover a database due to the absence of logs is far worse!

-a
>>> sinardyxing_at_bcsis.com 6/4/2001 14:45:28 >>>This message has been scanned by

MAILSweeper.************************************************************The

developer application running huge batch inserting data into database,that is what they told me, if you are me what you will do?-----Original Message-----TestaSent: Friday, 6 April 2001 11:55 AMTo: Multiple recipients of list ORACLE-Lassuming you're the dba, since when does the developer dictaterecoverability to a DBA about a database.sounds like a role problem there.joeSinardy Xing wrote:>> Our Developer prefer the archive off, I can't change that anymore :(>> -----Original Message-----> Sent: Thursday, 5 April 2001 8:54 PM> To: LazyDBA mailing list>> Turn archiving on.>> > -----Original Message-----> > From: Sinardy Xing [<A
href="mailto:sinardyxing_at_bcsis.com]">mailto:sinardyxing_at_bcsis.com]>
> Sent: Thursday, April 05, 2001 4:57 AM> > To: LazyDBA mailing
list> > Subject: Recovery from noarchive db corrected> >> >> > Hi,> >> > My database is
noarchive mode, what should I do to prevent> > from lossing any> > transactions ?> > Like for example incresed the REDO buffer to ... (daily buffer)?> > Will this decrese the performance ?> > any technique to share ?> >> >
Sinardy> >> > --------> > 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: <A href="http://www.LAZYDBA.com/odbareadmail.pl">http://www.LAZYDBA.com/odbareadmail.pl>
> Tell yer mates about <A

href="http://www.farAwayJobs.com">http://www.farAwayJobs.com> >> >>> --------> 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: <A
href="http://www.LAZYDBA.com/odbareadmail.pl">http://www.LAZYDBA.com/odbareadmail.pl> Tell yer mates about <A
href="http://www.farAwayJobs.com">http://www.farAwayJobs.com>> --> Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com">http://www.orafaq.com> --> Author: Sinardy Xing> INET:
sinardyxing_at_bcsis.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).--Joe Testa <A
href="http://www.oracle-dba.com">http://www.oracle-dba.comPerforming Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com domain, its not going cheap but feel free toask :)--Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author: Joseph S. Testa INET: teci_at_oracle-dba.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

Lists--------------------------------------------------------------------To

REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Author: Sinardy Xing INET: sinardyxing_at_bcsis.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

Lists--------------------------------------------------------------------To

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

Received on Fri Apr 06 2001 - 00:11:49 CDT