| 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: RAID5 Oracle upgrade
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_01C06B69.C30E7D70
Content-Type: text/plain;
charset="iso-8859-1"
Sorry, before opening database you will have to recover it from archivelogs until cancel before opening
Alex Hillman
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Wednesday, December 20, 2000 6:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAID5 Oracle upgrade
Why not install new array, connect it to the same box, create file systems
and directories
on it, put tablespaces one by one into backup mode and copy files to the new
raid array including control files. Also copy oracle software and admin
directories if they are also on old array. Then shutdown the database (not
abort), change everywhere in parameter file old directories to new
directories if needed, open database on the old array in mount mode and
change file names to new directories - it can be scripted. Then you can open
database and take away old array. Downtime should me minimal.
Alex Hillman
-----Original Message-----
From: Bill Becker [ mailto:beckerb_at_mfldclin.edu
<mailto:beckerb_at_mfldclin.edu> ]
Sent: Wednesday, December 20, 2000 4:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RAID5 Oracle upgrade
Hello,
Someone made a clever(?) proposal regarding a disk upgrade at our site, and I'm wondering what to make of it.
First, we run Oracle 8.1.6 on Sun Solaris; filesystem type is UFS (not Veritas) with an 8K block size. Most of the Oracle data resides upon two RAID5 arrays; each array is composed of five 18GB disks. The upgrade consists of replacing the RAID5 18GB disks with 36GB disks.
The usual way we do this is to shutdown Oracle, take a full cold backup of the system, remove the 10 18GB disks, install and configure the new 10 36GB disks, and restore from backup.
The problem with this process is that we will be down for 8-10 hours or more.
The proposal is that we upgrade the disks one-at-a-time by making use of the automatic RAID5 rebuild mechanism. That is, each day we will simply remove one 18GB disk from a RAID5 array, replace it with a new 36GB disk, and let the automatic RAID5 rebuild mechanism kick in and restore the disk. Poor performance for a few hours, but no down time.
Has anyone done anything similar? I suspect this method will only reclaim 18GB of space on the new 36GB disk; can anyone verify that? If true, does anyone know of a way to increase that to the full 36GB on all disks without taking the machine out of service for any length of time?
Thanks to any responders.
Bill "I don't actually do this stuff, I just propose it" Becker
beckerb_at_dgabby.mfldclin.edu
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: Bill Becker INET: beckerb_at_mfldclin.edu 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_01C06B69.C30E7D70 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: RAID5 Oracle upgrade</TITLE> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD> <BODY> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=643411616-21122000>Sorry, before opening database you will have to recover it from archivelogs until cancel before opening</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=643411616-21122000></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=643411616-21122000>Alex Hillman</SPAN></FONT></DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">Received on Thu Dec 21 2000 - 10:19:15 CST
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> Alex Hillman [mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Wednesday, December 20, 2000 6:26 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: RAID5 Oracle upgrade<BR><BR></DIV></FONT>
<P><FONT size=2>Why not install new array, connect it to the same box, create
file systems and directories</FONT> <BR><FONT size=2>on it, put tablespaces one by one into backup mode and copy files to the new raid array including control files. Also copy oracle software and admin directories if they are also on old array. Then shutdown the database (not abort), change everywhere in parameter file old directories to new directories if needed, open database on the old array in mount mode and change file names to new directories - it can be scripted. Then you can open database and take away old array. Downtime should me minimal.</FONT></P>
<P><FONT size=2>Alex Hillman</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Bill
Becker [<A href="mailto:beckerb_at_mfldclin.edu">mailto:beckerb_at_mfldclin.edu</A>]</FONT>
<BR><FONT size=2>Sent: Wednesday, December 20, 2000 4:56 PM</FONT> <BR><FONT
size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RAID5 Oracle upgrade</FONT> </P><BR>
<P><FONT size=2>Hello,</FONT> </P>
<P><FONT size=2>Someone made a clever(?) proposal regarding a disk
upgrade</FONT> <BR><FONT size=2>at our site, and I'm wondering what to make of it.</FONT> </P>
<P><FONT size=2>First, we run Oracle 8.1.6 on Sun Solaris; filesystem
type</FONT> <BR><FONT size=2>is UFS (not Veritas) with an 8K block size.</FONT> <BR><FONT size=2>Most of the Oracle data resides upon two RAID5 arrays; each</FONT> <BR><FONT size=2>array is composed of five 18GB disks. The upgrade consists of</FONT> <BR><FONT size=2>replacing the RAID5 18GB disks with 36GB disks.</FONT> </P>
<P><FONT size=2>The usual way we do this is to shutdown Oracle, take a full
</FONT><BR><FONT size=2>cold backup of the system, remove the 10 18GB disks,
install</FONT> <BR><FONT size=2>and configure the new 10 36GB disks, and restore from backup.</FONT> </P>
<P><FONT size=2>The problem with this process is that we will be down
for</FONT> <BR><FONT size=2>8-10 hours or more.</FONT> </P>
<P><FONT size=2>The proposal is that we upgrade the disks one-at-a-time by
making</FONT> <BR><FONT size=2>use of the automatic RAID5 rebuild mechanism. That is, each day</FONT> <BR><FONT size=2>we will simply remove one 18GB disk from a RAID5 array, replace</FONT> <BR><FONT size=2>it with a new 36GB disk, and let the automatic RAID5 rebuild</FONT> <BR><FONT size=2>mechanism kick in and restore the disk. Poor performance for a</FONT> <BR><FONT size=2>few hours, but no down time.</FONT> </P>
<P><FONT size=2>Has anyone done anything similar? I suspect this method will
only</FONT> <BR><FONT size=2>reclaim 18GB of space on the new 36GB disk; can anyone verify that?</FONT> <BR><FONT size=2>If true, does anyone know of a way to increase that to the full 36GB</FONT> <BR><FONT size=2>on all disks without taking the machine out of service for any </FONT><BR><FONT size=2>length of time?</FONT> </P>
<P><FONT size=2>Thanks to any responders.</FONT> <BR><FONT size=2>Bill "I
don't actually do this stuff, I just propose it" Becker</FONT> <BR><FONT size=2>beckerb_at_dgabby.mfldclin.edu</FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT size=2>--
</FONT><BR><FONT size=2>Author: Bill Becker</FONT> <BR><FONT size=2>
INET: beckerb_at_mfldclin.edu</FONT> </P>
<P><FONT size=2>Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT>
<BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail
message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also
 |
 |