RE: BIG database backup methods

From: Kline.Michael <Michael.Kline_at_SunTrust.com>
Date: Tue, 21 Sep 2004 16:01:42 -0400
Message-ID: <52C70FF150F49E479DAF59C68A27149D11DFC0@va016a0e2.corp.suntrust.com>

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_at_xs4all.nl] Sent: Tuesday, September 21, 2004 3:05 PM To: Kline.Michael
Cc: oracle-l_at_freelists.org
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.

<http://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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 21 2004 - 15:03:53 CDT