RE: EMC Snapshot Technology

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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).