Re: A database on raw devices. How to get back to file system based?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 28 Aug 2001 15:42:27 -0500
Message-ID: <ug0abg3bt.fsf@verizon.net>

On Tue, 28 Aug 2001, nsouto_at_optushome.com.au.nospam wrote:

> On 27 Aug 2001 20:41:19 -0500, Galen Boyer
> <galenboyer_at_hotpop.com> wrote:
>

>>back to UNIX.  Does Oracle need to release anything ..., or can
>>I shutdown the instance and then have the sysadmin just
>>reconfigure the disk drives to be file based.  Then, go about
>>my business of creating a new database?

>
> Pretty much so. Shutdown the old stuff, tell the sys admin to
> reuse the raw devices for a file system, and bingo. You will
> *definitely* loose the data that was there vefore, unless you
> can export it somewhere else before the raw devices go.

Thanks. Thought as much, but wanted to get a better opinion than my own.

>>I'm worried that the executables might get munged in this
>>process and I'm worried about whatever else this group might
>>deem that I should worry about :-)

>
> I can't see how that can happen, unless your sys admin gets
> over-enthusiastic! ORACLE executables have to be stored in a
> file system, they cannot be inside a raw device.

Doh! Thanks

> That means unless your sys admin dismounts the file system
> where they live and reformats it, there is no way loosing the
> raw devices should affect them.

Good enough. Thanks a bunch Nuno.

-- 
Galen Boyer
It seems to me, I remember every single thing I know.

Received on Tue Aug 28 2001 - 15:42:27 CDT