RE: rman incremental backups vs. full backups
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <jwilton@xxxxxxxxxxxxx>, <ryan_gaffuri@xxxxxxxxxxx>
- Date: Thu, 11 Nov 2004 07:59:30 -0500
What a mistake? If you only take one full backup (ever) think how much
longer and more complicated restoring would be. I try to do full
backups up until the point where my backup window simply won't work.
Then I start considering incremental. =20
Another approach for a large data warehouse where most of your data may
be only loaded once and never changed is to switch those tablespaces to
read-only, perform a full backup (making sure to mark this tape) then to
use the rman close not to backup those readonly tablespaces anymore. =20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeremiah Wilton
Sent: Wednesday, November 10, 2004 3:27 PM
To: Ryan
Cc: Oracle Discussion List
Subject: Re: rman incremental backups vs. full backups
On Wed, 10 Nov 2004, Ryan wrote:
> I believe I read somewhere that you should only take 1 full backup=20
> ever. I can't remember where.
This doesn't make any sense to me. If you only ever took one full
backup, you would have to apply all the incrementals thereafter in the
event of a restore. Until at least 10g (?), incrementals don't save you
anything but backup media. They take just as long and read just as much
as fulls.
--
Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
http://www.speakeasy.net/~jwilton
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
NOTE: This message was auto-learned as non-spam. If this is wrong,
please correct the training as soon as possible.
Teach CanIt if this mail (ID 15412930) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D15412930&m=3Ddca1=
bd010
5d8
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D15412930&m=3Ddca1=
bd010
5d8
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D15412930&m=3Ddca1=
bd010
5d8
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
