RE: Recovery from noarchive db corrected

[Arn Klammer]

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 >>> [EMAIL PROTECTED] 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----- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy 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 [mailto:[EMAIL PROTECTED]] > > 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 > > [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > Tell yer mates about 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 [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing >   INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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  http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa   INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing   INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). ********************************************************************** 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 **********************************************************************