Re: convert system tablespace from raw device to filesystem

Because it's the sytem tablespace - you can't offline it ... your database has to be in mount mode to do this...
Use dd to go from raw to cooked : dd if=/dev/lvsystem of=/u01/db/system.dbf The rename the file - alter database rename file '/dev/lvsystem' to '/u01/db/system.dbf' ;
If you're going to do it in bulk :

- dump the controlfile to trace
- bring down the db
- dd all files to cooked devices;
- edit controlfile dump to reflect the changes made
- recreate controlfile
- fire up db

cheers,
Kurt

"Gautrak" <gautrak_at_yahoo.com> wrote in message news:76ceef56.0407050358.7236f21_at_posting.google.com...
> Hi,
> our current 8i (8.1.7) db on solaris uses raw devices for datafiles.
> we have to convert them to cooked filesystem files. ifs and buts have
> been already talked over and we have to do it as long as it is
> technically feasible.
>
> Its is a 100+ GB database. Method we are planning to use is taking the
> tablespace offiline, convert raw device to filesystem and rename the
> datafile to location of this file.
>
> Not sure how we would be converting the system tablespace raw device
> to file using this method.
>
> Kindly provide insights into options available and difficulties we
> might face.
>
> Thanks and regards,
> Gautrak
Received on Mon Jul 05 2004 - 07:19:01 CDT