RE: EMC Snapshot Technology

Hey Tom,  

I'm in the same boat.  

Have you looked over some of the red papers at www.storage.ibm.com/ess???  

If not, check this one out...  

Storage Management for SAP and Oracle8i on SUN SOLARIS Split Mirror Backup/Recovery with IBM's ESS.  

Granted its for Solaris, but I would think the concepts are the same. And of course, there are more about Oracle.  

I believe were running RAID 5, which has me a bit concerned being a unofficial member of the BAARF organization. The red papers speak to this problem, and supposedly it has been resolved. Something about the entire stripe being cached. Since I'm a SAN newbie, I'm starting with the Introduction to SAN paper, and reading my way up. I don't want to raise a red flag until I can prove it.  

Please keep me in mind with whatever path you take. And if you present your findings let me know, I would love to read'em.  

Thanks.  

Chris

-----Original Message-----
Sent: Thursday, October 09, 2003 9:10 AM To: Multiple recipients of list ORACLE-L

Gene,  

What happens when you need to perform a recovery from the Flashcopy backup? Is Flashcopy done while the database is open or closed? If the database is open, then I assume that you would need to perform an incomplete recovery?

Just curious. I am in the middle of setting up new IBM/AIX boxes, and we will using either EMC or IBM Shark disk. Flashcopy was mentioned as a possible solution for backups. But I don't like being boxed in to performing an incomplete recovery.  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, October 09, 2003 8:35 AM To: Multiple recipients of list ORACLE-L

I don't use snapshots, but have used EMC BCV's in the past and now use IBM's Flashcopy for backups. I backup 1TB db in ~20 mins using Flashcopy. Then I take it off to tape, i.e. filesystems monted on a TSM Backup server, hence no resources needed from the production server :). hth,
Gene

>>> jwiegand_at_mn.rr.com 10/08/03 09:39PM >>>
We are implementing Oracle RAC on two Windows nodes, connected to an EMC SAN. We'll also have a failover sight.

We are using S.A.M.E. disk configuration, with only one logical volume, and backups/archivelogs dumping to another volume.

The SAN is an EMC Clariion CX400.

I immediately vetoed snapshots, opting for RMAN, but I'm now taking a second look.

Does anyone use the snapshot technology as a solution for full backups?

Thanks,

Jeff

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net/> 
-- 
Author: jwiegand
  INET: jwiegand_at_mn.rr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com/> 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grabowy, Chris
  INET: chris.grabowy_at_lmco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).