RE: Oracle Database - EMC Disks and BCV

From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
Date: Wed, 18 Oct 2000 16:05:58 +1300
Message-Id: <10652.119578@fatcity.com>

Parveen,
I beleive if you seprate Control file with data file and also spread your datafile it is much faster and safer plus backup of each individual tablespace would be faster.
Hope it helps

-----Original Message-----
From: Praveen Gautam [mailto:gautam_at_pipeline.com] Sent: Wednesday, 18 October 2000 15:51
To: Multiple recipients of list ORACLE-L Subject: Oracle Database - EMC Disks and BCV

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 Tue Oct 17 2000 - 22:05:58 CDT