| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Fwd: RE:]
One reason to have this feature is that it would allow the use of rman to
perform the recovery. A second reason for sites that perform both hot and
cold backup it allows them to do so using the same utility to perform both
backup types.
While the feature is not necessary to sites that only employ hot backups and plan on always running a forward recovery, sites with the luxury of being able to make a cold backup may well find the feature useful. The feature might also be useful to make the database backup usually taken immediately before a upgrade/migration.
IMHO -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
Sent: Friday, June 04, 2004 2:48 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: [Fwd: RE:]
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_at_dmc-it.com [mailto:jtesta_at_dmc-it.com]
Sent: Friday, June 04, 2004 2:33 PM
To: oracle-l_at_freelists.org
Subject: [Fwd: RE:]
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_at_LIFETOUCH.COM]
Sent: Friday, June 04, 2004 2:03 PM
To: 'oracle-l_at_freelists.org'
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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jtesta_at_dmc-it.com
Sent: Friday, June 04, 2004 11:54 AM
To: oracle-l_at_freelists.org
Subject:
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |