Re: converting from "cooked" to "raw" oracle database

strepxe_at_yahoo.co.uk wrote:
>
> i'm working on a database which consists of datafiles in filesystems
> (referred to as cooked in some technical documents). i want to look at
> the performance difference with all the files raw i.e. using logical
> volumes to store the data. i know its possible to backup raw files
> using the dd command. what i'm interested in finding out/understanding
> is how to perform the opposite process i.e. convert from a 'cooked' to
> 'raw' storage system for an existing instance containing data. can i
> use a dd command to copy data from file to logical volume? is an
> export/import the only option? i'm going to be performing a number of
> tests myself and will post findings here. any other knowledge on
> subject appreciated.

dd if=file of=raw

will work fine. Just remember to adjust your buffer cache to take into account any file system caching you may have been inadertently taking advantage of.

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------