RE: BIG database backup methods
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
- Date: Tue, 21 Sep 2004 16:01:42 -0400
I'm thinking a combo of both, but you know they want to eliminate those
extra disks. Not if we can avoid it.
I love RMAN, use it at another client exclusively, but at 1-2 TB and
multiples on the same server, that "5 minute bounce, all backed up" is
ever so nice. They can start the sync even a day or two early if we are
in an "almost there" state... The client complete "the run", it looks
good, 5 minute backup, start the next phase.
Now if we could COMBINE that with RMAN and archived backups would work
very nicely, that would be good. But I'd fear a large restore could take
hours.
Then again, when we had to rebuild an older shadow to get some data,
that took 2-3 days. Not pretty.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
-----Original Message-----
From: Carel-Jan Engel [mailto:cjpengel.dbalert@xxxxxxxxx]
Sent: Tuesday, September 21, 2004 3:05 PM
To: Kline.Michael
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: BIG database backup methods
Just a thought: This HW-copying won't detect block corruptions. RMAN
will. A problem can survive beyond repair with the syncing method.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Tue, 2004-09-21 at 20:11, Kline.Michael wrote:
We have the "luxury?" of being able to do shadow copies for many of our
data warehouses. These are only in the 1-2 TB range, but with shadow
copy, we start at perhaps 2AM with the syncing, and then around 4PM we
stop the database, wait about 5 minutes, break the volumes and we're
back up.
<//www.freelists.org/webpage/oracle-l>
************************************************
The information transmitted is intended solely
for the individual or entity to which it is
addressed and may contain confidential and/or
privileged material. Any review, retransmission,
dissemination or other use of or taking action
in reliance upon this information by persons or
entities other than the intended recipient is
prohibited. If you have received this email in
error please contact the sender and delete the
material from any computer.
************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
