why do you do a cold backup? why not just use RMAN?
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, January 09, 2004 4:34 PM
> Mohammed - When is this database updated? Once/week? Daily? Continuously?
If
> there is a failure, what is the consequence of returning to the last
backup?
> How much critical data will be lost? How will recovery times be affected
> with/without archive logging? How much does your sys admin know about
> Oracle?
> We have a data warehouse that gets updated weekly. The day after the
load
> we perform a cold backup. We don't use archive logging.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Friday, January 09, 2004 3:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Have a question on backups in a DW environment.
>
> Our DW is somewhat small at the moment but projected
> to grow. I seem to be having a hard time trying to
> convince the sys admin that I don't want archive
> logging turned on. To me, it does'nt make much sense.
>
> He's proposed using EMC BCV's which I've agreed to
> (and also sounds like a good idea) but also wants to
> turn on archiving. My thinking is why turn on
> archiving if I can restore my DB from last night's
> BCV's and then bring it up to date by re-loading any
> data that was loaded after the BCV split.
>
> Our system is not 24x7 so we can shutdown before the
> BCV split. Also, it's not directly accessed by users
> for ad-hoc queries. Automated processes access the
> database and build cubes using Cognos tools. Users
> access these and not the DB directly.
>
> So, again I don't see the need for archive logging.
>
> Any thoughts?
>
> mohammed
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: mkb
> INET: mkb125_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
--
Author: Ryan
INET: ryan.gaffuri_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Fri Jan 09 2004 - 16:09:25 CST
