Solaris ufs to raw w/ oracle question
Albertson, Brett
ncsa-discussion@ncsysadmin.org
Tue, 4 Feb 2003 14:38:27 -0500
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_01C2CC84.FD6DB510
Content-Type: text/plain;
charset="iso-8859-1"
Honestly, there's no easy way to do this that I can think of. UFS is a
structured filesystem with i-nodes storing data, whereas "raw" partitions
are just that, unformatted data space. Raw filesystems are managed by the
database itself, instead of the OS.
To do the conversion:
1. Make a 500MB Veritas Volume and make sure to not put a filesystem on it.
2. Have the DBA initiallize the raw space in Oracle.
3. Have the DBA move data over to the new raw area.
4. Remove freed up .dbf files from UFS filesystems.
5. Remove any unused UFS filesystems
6. repeat with step #1 until done.
good luck,
Brett
-----Original Message-----
From: Ubiquitous Geebles [mailto:geebles@hotmail.com]
Sent: Tuesday, February 04, 2003 2:33 PM
To: ncsa-discussion@ncsysadmin.org
Subject: Solaris ufs to raw w/ oracle question
Need help with a problem.
I've got a Solaris 8 system, running Veritas 3.1.1.
So total 'actual' disk space is over 2.1TB
Also has a 1TB+ oracle 8i database running on it.
The filesystems are mirrored with Veritas, but formatted ufs. What is the
best/simplest way to convert these to 'raw' fstypes ( at the DBAs request )
without backing up to tape and restoring? Is there a way to do this?
Complicating factor -- organization does not possess a tape library capable
of backing this up by filesystem, so I would have to build a 100 GB scratch
zone, format it raw, and then....what?
Need all your experience/thoughts on this.
Many thanks,
Ubi Geebles.
_____
Help STOP SPAM with the new MSN 8 <http://g.msn.com/8HMBENUS/2731> and get
2 months FREE* _______________________________________________
ncsa-discussion mailing list ncsa-discussion@ncsysadmin.org
http://www.ncsysadmin.org/mailman/listinfo/ncsa-discussion
------_=_NextPart_001_01C2CC84.FD6DB510
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">
<META content="MSHTML 5.00.3510.1100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003>Honestly, there's no easy way to do this that I can
think of. UFS is a structured filesystem with i-nodes storing data,
whereas "raw" partitions are just that, unformatted data space. Raw
filesystems are managed by the database itself, instead of the
OS.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>To do
the conversion:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>1.
Make a 500MB Veritas Volume and make sure to not put a filesystem on
it.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>2.
Have the DBA initiallize the raw space in Oracle.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>3.
Have the DBA move data over to the new raw area.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>4.
Remove freed up .dbf files from UFS filesystems.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>5.
Remove any unused UFS filesystems</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>6.
repeat with step #1 until done.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=815373219-04022003>good
luck,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003>Brett</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=815373219-04022003></SPAN></FONT> </DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ubiquitous Geebles
[mailto:geebles@hotmail.com]<BR><B>Sent:</B> Tuesday, February 04, 2003 2:33
PM<BR><B>To:</B> ncsa-discussion@ncsysadmin.org<BR><B>Subject:</B> Solaris ufs
to raw w/ oracle question<BR><BR></DIV></FONT>
<DIV>
<DIV></DIV>
<DIV></DIV>
<P>Need help with a problem.</P>
<P>I've got a Solaris 8 system, running Veritas 3.1.1.</P>
<P>So total 'actual' disk space is over 2.1TB</P>
<P>Also has a 1TB+ oracle 8i database running on it.</P>
<P>The filesystems are mirrored with Veritas, but formatted ufs. What is
the best/simplest way to convert these to 'raw' fstypes ( at the DBAs request
) without backing up to tape and restoring? Is there a way to do
this?</P>
<P>Complicating factor -- organization does not possess a tape library capable
of backing this up by filesystem, so I would have to build a 100 GB scratch
zone, format it raw, and then....what?</P>
<P>Need all your experience/thoughts on this.</P>
<P>Many thanks,</P>
<P>Ubi Geebles.<BR><BR><BR></P>
<DIV></DIV></DIV><BR clear=all>
<HR>
Help STOP SPAM with <A href="http://g.msn.com/8HMBENUS/2731">the new MSN 8
</A>and get 2 months FREE* _______________________________________________
ncsa-discussion mailing list ncsa-discussion@ncsysadmin.org
http://www.ncsysadmin.org/mailman/listinfo/ncsa-discussion</BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2CC84.FD6DB510--