Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> copying oracle dbf files on hp-ux

copying oracle dbf files on hp-ux

From: <strepxe_at_yahoo.co.uk>
Date: 20 Apr 2005 16:10:58 -0700
Message-ID: <1114038658.786258.30850@g14g2000cwa.googlegroups.com>


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? Received on Wed Apr 20 2005 - 18:10:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US