| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Database - EMC Disks and BCV
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C038FB.5C5CCCCA
Content-Type: text/plain;
charset="iso-8859-1"
Praveen,
This is our backup strategy:
Resync BCV's
Put all tablespaces in hotbackup mode
Split BCV's
Take all tablespaces out of hotbackup mode.
Our redo logs are NOT on the BCV's. The reason is, if you have to restore, you don't want your arclogs restored over any arclogs that may already exist. When you restore a BCV, it overwrites everything.
Our controlfiles are on the BCV's. However, I'm sure you could make this work without having the controlfiles on the BCV'S. Depends on your strategy.
The split command is very fast - like 10 minutes max. Bang, the part of the backup that involves the database is DONE, plus I have a hot backup sitting on the BCV's should I need it (and I have). The BCV's are then written to tape. Restore from the BCV'S takes approx. 25 minutes.
Drawback - the license to use RMAN, BCV's, and third-party backup software like Veritas, Omniback is pricey. So I do not have the flexibility that RMAN gives me, and I am more dependent upon SA's to get me out of a tight spot with a restore. But again: I have a backup that I can restore very quickly.
Hope this helps.
<<< GO VIKINGS!! >>>
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Praveen Gautam [mailto:gautam_at_pipeline.com]
Sent: Tuesday, October 17, 2000 6:22 PM
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.
All comments are appreciated.
TIA
--
+===========================================================================+
| Praveen K. Gautam | | Tellabs, Inc. | +===========================================================================+
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).
------_=_NextPart_001_01C038FB.5C5CCCCA
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>RE: Oracle Database - EMC Disks and BCV</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2>Praveen, </FONT>
</P>
<P><FONT SIZE=3D2>This is our backup strategy:</FONT> </P>
<P><FONT SIZE=3D2>Resync BCV's</FONT> <BR><FONT SIZE=3D2>Put all tablespaces in hotbackup mode</FONT> <BR><FONT SIZE=3D2>Split BCV's</FONT> <BR><FONT SIZE=3D2>Take all tablespaces out of hotbackup mode. </FONT> </P>
<P><FONT SIZE=3D2>Our redo logs are NOT on the BCV's. The reason is, if = you have to restore, you don't want your arclogs restored over any = arclogs that may already exist. When you restore a BCV, it = overwrites everything. </FONT></P>
<P><FONT SIZE=3D2>Our controlfiles are on the BCV's. However, I'm sure = you could make this work without having the controlfiles on the = BCV'S. Depends on your strategy.</FONT></P>
<P><FONT SIZE=3D2>The split command is very fast - like 10 minutes = max. Bang, the part of the backup that involves the database is = DONE, plus I have a hot backup sitting on the BCV's should I need it = (and I have). The BCV's are then written to tape. Restore from = the BCV'S takes approx. 25 minutes. </FONT></P>
<P><FONT SIZE=3D2>Drawback - the license to use RMAN, BCV's, and = third-party backup software like Veritas, Omniback is pricey. So = I do not have the flexibility that RMAN gives me, and I am more = dependent upon SA's to get me out of a tight spot with a restore. = But again: I have a backup that I can restore very quickly. = </FONT></P>
<P><FONT SIZE=3D2>Hope this helps.</FONT> </P>
<P><FONT SIZE=3D2><<< GO VIKINGS!! =
>>></FONT>
</P>
<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT><BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P>
<P><FONT SIZE=3D2>"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P> <BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Praveen Gautam [<A = HREF=3D"mailto:gautam_at_pipeline.com">mailto:gautam_at_pipeline.com</A>]</FON= T>
<BR><FONT SIZE=3D2>Sent: Tuesday, October 17, 2000 6:22 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Oracle Database - EMC Disks and BCV</FONT> </P> <BR>
<P><FONT SIZE=3D2>Hi All,</FONT>
<BR><FONT SIZE=3D2>I am in the process of designing a backup strategy =
for our Web Portal Database. The database will</FONT>
<BR><FONT SIZE=3D2>reside on EMC disks. I am familiar with the =
BCV concept but do not have any hands-on experience. I</FONT>
<BR><FONT SIZE=3D2>need your help to determine the following.</FONT>
</P>
<P><FONT SIZE=3D2>1. Is is better to keep control file and the = redo log groups/members separate from the data files?</FONT> <BR><FONT SIZE=3D2>2. Is it better to put all tablespaces in = backup mode, split the BCV and end backup mode - OR - put</FONT> <BR><FONT SIZE=3D2>each tablespace in backup mode one at a time. = In the second case, should I keep the</FONT> <BR><FONT SIZE=3D2>tablespace/datafiles in separate volumes?</FONT> </P>
<P><FONT SIZE=3D2>All comments are appreciated.</FONT> </P>
<P><FONT SIZE=3D2>TIA</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D+</FONT>
Gautam = = = = |</FONT><BR><FONT SIZE=3D2>| Tellabs, =
Inc. &n= bsp; &n= bsp; &n= bsp; &n= bsp; =|</FONT>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D+</FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Praveen Gautam</FONT> <BR><FONT SIZE=3D2> INET: gautam_at_pipeline.com</FONT> </P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=-----</FONT>
 |
 |