Re: Recovery from noarchive db corrected

Sinardy Xing wrote:
>
> The developer application running huge batch inserting data into database,
> that is what they told me, if you are me what you will do?
Sinardy,

You definitely want to turn archiving on.

Without it, your recovery options are limited to the last offline backup of the database. If you do an offline backup of the development DB every night, then the most that would be lost is one day's worth of development. Depending on how and where the developers write and store their code, the least that would be lost is one day's worth of transactions in the development DB.

Beyond that however, is the fact that you are a developer in a sense as well. Tuning databases to avoid the kind of contention the developers are worried about is part of what you do for a living. If the developer's fears are correct, and archiving causes their database to respond poorly, what will happen when their code goes into an archived production database? There are many parameters you can alter and steps you can take to reduce, minimize, or eliminate this type of contention. Combinations of things like adding redo logs, increasing the size of the log buffer, altering checkpoints, looking at v$latch and making appropriate adjustments to log_small_entry_max_size or log_simultaneous_copies are just a few of the options available to you as the DBA. Examining the code processing the batch is another.

Tuning is like detective work, and is probably my favorite part of being a DBA. Start with one of the tuning manuals off OTN, then pick up (and read) Steve Adam's "Oracle 8i Internal Services" from O'Reilly.

You'll be a better DBA, and who knows, you might even be able to teach the developers a trick or two.

Good Luck.

David A. Barbour
Oracle DBA

>
> -----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: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: 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 oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > 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: 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 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: teci_at_oracle-dba.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).
>
> --
> Please see the official ORACLE-L FAQ: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: dbarbour_at_nucentrix.net

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).