Re:Oracle Database - EMC Disks and BCV

From: <dgoulet_at_vicr.com>
Date: Wed, 18 Oct 2000 10:16:19 -0400
Message-Id: <10653.119646@fatcity.com>

Praveen,

I'd recommend a visit to MetaLink & a search on "EMC". There are several papers there on how to do this actually written by Oracle. Mind you their all based on version 7.3, but their still very relevant. To make this work (in a nutshell), place the entire database (all tablepsaces, redologs, and control files) on the EMC disks where the BCV will mirror them. Archived redo logs can be placed elsewhere. Then re-silver the BCV, place the entire DB in HOT-BACKUP mode, split the BCV off, & end the backup completely. Time in backup mode is less than a minute for the most part. When you fire up the BCV copy it will need to be taken out of backup mode & then will go through instance recovery before opening.

Dick Goulet

____________________Reply Separator____________________

Subject: Oracle Database - EMC Disks and BCV Author: Praveen Gautam <gautam_at_pipeline.com> Date: 10/17/00 2:22 PM

Hi All,
I am in the process of designing a backup strategy for our Web Portal Database. The database will
reside on EMC disks. I am familiar with the BCV concept but do not have any hands-on experience. I
need your help to determine the following.

Is is better to keep control file and the redo log groups/members separate from the data files?
Is it better to put all tablespaces in backup mode, split the BCV and end backup mode - OR - put each tablespace in backup mode one at a time. In the second case, should I keep the tablespace/datafiles in separate volumes?

All comments are appreciated.

TIA
--

+===========================================================================+
|  Praveen K. Gautam                                                        |
|  Tellabs, Inc.                                                            |
+===========================================================================+

--

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

Author: Praveen Gautam
INET: gautam_at_pipeline.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 Wed Oct 18 2000 - 09:16:19 CDT