Joe, Interesting. We are wrestling with our warehouse backups. Currently doing a cold backup after the weekly loads. I'm not sure if this would help us or not. We don't have monthly loads like you do. Tom Mercadante Oracle Certified Professional -----Original Message----- From: jtesta@xxxxxxxxxx [mailto:jtesta@xxxxxxxxxx] Sent: Friday, June 04, 2004 2:33 PM To: oracle-l@xxxxxxxxxxxxx Subject: [Fwd: RE:] -------- Original Message -------- Subject: RE: From: <jtesta@xxxxxxxxxx> Date: Fri, June 4, 2004 2:30 pm To: <oracle-l@xxxxxxxxxxxxx> Tom it still points back to being able to backup a level 0 once a month and do just incrementals the rest of the time(like once a week). for our case 3 terabyte DW, we expect long down time at end of month but relatively short down times every other weekend since we do incrementals. my 2 cents worth. joe original message below Dennis, I don't see why Oracle even provides this type of backup (database in mount-only mode using Rman). To me, if I was considering this, I would just shut the database down and perform a cold backup. Using Rman in this situation is a waste of time (unless someone can give me a good reason why it is useful). Rman's biggest strength is point in time recovery, and that the db is up and available all the time. Anything else just seems like a waste to me - no practicality to it. Tom Mercadante Oracle Certified Professional -----Original Message----- From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx] Sent: Friday, June 04, 2004 2:03 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: Joe - Good point. I usually don't even consider offline RMAN backups. But for a really large database, that might be useful. Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of jtesta@xxxxxxxxxx Sent: Friday, June 04, 2004 11:54 AM To: oracle-l@xxxxxxxxxxxxx Subject: ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------