RE: Hot Backup using EMC /BCV splits

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Tue, 20 Aug 2002 00:23:19 -0800
Message-ID: <F001.004B997E.20020820002319@fatcity.com>

Hi,

While your EMC Standard volumes and BCVs are in synchronized mode (not split), both Standard and BCV will be updated at the same time. So is better you split instantly before you end backup your tablespaces. This will ensure your data files in BCV are backup mode data files before you them copy to tape.

Sinardy

-----Original Message-----
Sent: 20 August 2002 14:34
To: Multiple recipients of list ORACLE-L

Hi,

The logic should be like this

1. tablespace begin backup 1a. archive log current
2. suspend database (or sleep)
3. EMC synchronized standard volume and bcv
4. after all mount point (datafile) synchronized EMC split 4a. after EMC split you can mount your bcv to another host and then do the media backup. while you can continue step 5
5. resume database
6. tablespace end backup

Sinardy

-----Original Message-----
Sent: 15 August 2002 22:59
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.

1. Put all tablespaces in the database in Hot backup mode
2. Sleep 5
3. Put all the tablespaces back into normal mode
4. Split the BCV's
5. 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: Sinardy Xing
  INET: SinardyXing_at_bkgcomsvc.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: Sinardy Xing
  INET: SinardyXing_at_bkgcomsvc.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). Received on Tue Aug 20 2002 - 03:23:19 CDT