RE: Recovery from noarchive db corrected

Currently the application insert data from batch localy and a bit from online insertion. We have clustering for our database. noarchive, I do export tables after run batch (daily), weakly copy out all dbf files and ctl and redo log files. and copy them to tape. It's that true once the redo log switch, oracle will write redo log changes to dbf ?
Do you have any recomendation for better backup strategy ?

-----Original Message-----
Pather
Sent: Friday, 6 April 2001 1:30 PM
To: Multiple recipients of list ORACLE-L

Sinardy,

Who will recover the database in case of a failure?

Turing on archiving would not hinder performance so much. Proper planning of your backup strategy and db setup will have little overhead
on performance of your database.

You cannot sacrifice backups for a marginal increase in performance especially if
your db is a high transaction processing system.

Regards
Suhen

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: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: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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