Solaris ufs to raw w/ oracle question

mark-s ncsa-discussion@ncsysadmin.org
Tue, 4 Feb 2003 11:46:20 -0800 (PST)


my thoughts? you’re screwed ! 

seriously though, 1TB from fs to raw ? I don’t know of
a utility that will do that and convert data, and one
that oracle would be happy with ??????? Maybe someone
else does, and this will be a no brainer.

OTOH,
first, break the mirrors, convert unused diks to raw,
use oracle to import/export db from fs to new raw
volumes. Then destroy the old fs volumes, and mirror
the disks to the new raw volumes. a lot of work no
matter how you splice it. 

second, rent / lease / borrow / steal some storage and
do something similar to above, without breaking
mirrors and exposing yourself to a drive failure, or
other horror. 

third, convince DBA’s boss that raw isn’t going to
provide much better performance in today’s world, and
this is a silly idea. 

-----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 and get 2 months
FREE*


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com