Re: copying oracle dbf files on hp-ux

strepxe_at_yahoo.co.uk wrote:
> i have a database consisting of regular or "cooked" files which i am
> trying to convert to a "raw" filesystem on hp-ux 11i. what i've done
is
> to create, for each file, a similarly sized (slightly larger) logical
> volume. following this i use the dd command to copy the file to the
> logical volume. the syntax of the command i use is as follows:
> dd if=/tmp/file1.dbf of=/dev/vgoracle/rfile1.dbf bs=2048
> where:
> /tmp/file1.dbf - original (cooked) file
> /dev/vgoracle/rfile1.dbf - raw character device for logical volume
> bs=2048 - block size of 2k
> for some reason this is not working for all files for a reason i've
not
> yet been able to determine. some of the raw files "work" when i do an
> alter file ... in sql*plus wheras others do not. i'm wondering if i
> should use a skip=N (N is integer value >= 1) as you apparently have
to
> do on aix.
> to summarise my questions are:
> - does the method appear sound from whats been described?
> - for the dd command am i performing it correctly?

Two questions:

1. Why are you naming your raw partition with a '.dbf' extension? Normally one would simply create a raw partition following normal device naming conventions. It probably isn't a part of your problem, but it could obscure the fact these are now RAW partitions.
2. Which partitions are 'not working'? You have stated 'this [the dd copy] is not working for all files' yet fail to provide examples of working versus non-working copies. You have also failed to provide a complete list of all RAW partitions you're creating. And you've not stated whether you've tried to create additional RAW partitions on a different physical device and copy the datafiles in the same manner.

Please clarify your question, as it is nearly impossible to tell what is wrong with this scenario. Also in your clarification provide Oracle version number and O/S release number. This information is necessary to properly assess and answer your question.

David Fitzjarrell Received on Thu Apr 21 2005 - 08:07:08 CDT