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