Don't forget step 0: Back up the database!
Steve
koert54 wrote:
> 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 - 14:00:23 CDT
