Re: Recovery from noarchive db corrected

Sinardy,

what's your uptime requirement?
You're allowed a weekly cold shutdown for backup? what I'm asking is - when you are copying the datafiles to tape, its during a clean, cold shutdown, right?
Have you ever tested the recovery portion of your backup/recovery scheme?

If your 'copying files to tape' is from an open database, you'd be in for a real surprise when you attempt to restore the full set. You have no other recovery options than the full set - its zero datafiles or all of them.

If you create your batch loads so as to minimize the amount of redo, archivelog might not seem like such a performance hit. Give the system a dedicated channel and pair of drives (each) for both online and archived redo logs, and don't worry about the performance hit.

try it, you'll like it:

SVRMGR> startup mount pfile=<pfile_path>

SVRMGR> alter database archivelog;

SVRMGR> archive log start

SVRMGR> alter database open;

SVRMGR> alter database backup controlfile to trace;

SVRMGR> archive log list

Paul

Sinardy Xing wrote:
>
> 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
> ? ?
> ? ? --------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).