Oracle-L: RE: Hot Backup using EMC /BCV splits

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Thu, 15 Aug 2002 08:03:44 -0800
Message-ID: <F001.004B63F1.20020815080344@fatcity.com>

Nate,

We are looking at the same process. Your Unix Admin is incorrect. The split needs to happen at STEP 2. Otherwise, what is the point of putting the tablespaces in hot backup mode? The split is not instant, in fact we are assuming it will take up to 5 minutes to complete. The only way that EMC can guarantee consistency is to suspend I/O to the volumes and I'm not certain what that would do to processes currently writing. The fact is that I don't want to find out.

Here is what we are doing:

1. Log switch
2. Tablespaces in hot backup
3. Split BCVs
4. Tablespaces out of hot backup
5. Log switch
6. Mount bcvs on other machine

Dan Fink

-----Original Message-----
Sent: Thursday, August 15, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L

Hello,

We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup.

Put all tablespaces in the database in Hot backup mode
Sleep 5
Put all the tablespaces back into normal mode
Split the BCV's
Mount on another machine and backed up from it.

What I am concerned is with step 4. Split BCV's should be done at step 2 instead of step 4.
According to our Unix Admin, EMC takes care of consistency and there is no need for any concern. As per him the split is instant split and EMC guarantees consistency.

What do you all think. What is the recommended procedure.

TIA, Nate

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nat
INET: nat2710_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------