I use rman backups for a very large database somewhere in the area
of 3.5 Terabytes. We run a full hot backup on Sunday and and an incremental
on wednesday. Never had any problems. And the reason we run an incremental
is the full takes around 24 hours, and once a week is not often enough to
run a backup and 2 fulls in the same week is not pratical on resources.

-----Original Message-----
From: Marquez, Chris [mailto:[Email Address Removed] Thursday, February 28, 2002 11:38 AM
To: LazyDBA.com Discussion
Subject: RE: RMAN and incremental backups



We use RMAN (have for some time now) to do full backups of 800GB db to
Legato.

RMAN works great, and I'm sure the incremental functionality works too, but
why?

I wouldn't use incremental backup unless it meant no backup at all. Why
complicate you life this way. Recovery is complicated and stressful enough
with a simple (logic) backup solution. "incremental" only servers to
confuse a stressful situation, recovery!


RMAN cons;
Using a catalog database or the controlfile as the catalog. Old style HOT
file backups are logically simpler, but I take RMAN any day.
It can be as simple as doing an export.


hth

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"There is golf, and there is tournament golf.
The two are in no way the same"
-Robert T. Jones
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Marquez
Oracle DBA S A I C
(202) 261-9454
[Email Address Removed] Message-----
||From: Thomason.[Email Address Removed] Thursday, February 28, 2002 12:19 PM
||To: LazyDBA.com Discussion
||Subject: RMAN and incremental backups
||
||
||We are considering using RMAN to do incremental backups of a
||large 8.1.7
||database. Is anyone using RMAN for this? Does it work, and what are
||the pros and cons?
||
||TIA,
||---------------------------------------------------
||Marshall Thomason
||Lockheed Martin Technical Services
||EPA Primary Support Contract
||thomason.[Email Address Removed] documentation is here:
||http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
||To unsubscribe: send a blank email to
||oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
||Tell yer mates about http://www.farAwayJobs.com
||By using this list you agree to these
||terms:http://www.lazydba.com/legal.html
||

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


*********************************************************************

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

Oracle LazyDBA home page