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 -> Re: How to convert RAW <-> File datafiles of tablespace?

Re: How to convert RAW <-> File datafiles of tablespace?

From: Ronald <devnull_at_ronr.nl>
Date: 20 Sep 2001 06:52:12 -0700
Message-ID: <67ce88e7.0109200552.1c5f8d15@posting.google.com>


"mako" <makoml_at_jcom.home.ne.jp> wrote in message news:<_saq7.1575$kn.190961_at_news1.rdc1.ky.home.ne.jp>...
> Hello everybody,
> Is it possible to convert filesystem-based (cooked) tablespace datafiles to
> raw-based datafiles? I tried to transform them using dd command, but never
> succeeded to mount transformed one.
>
> I used dd command like below.
>
> dd if=/oradata/data001.dbf bs=16k of=/dev/vg01/rdata001

Hi Mako

I am not sure how much you should skip on HP but on AIX you have to skip the first 4kb of the raw device.

dd if=/cooked/file of=/dev/vg01/data001 ibs=600k obs=4k seek=1

Ronald.



http://ronr.nl/unix-dba Received on Thu Sep 20 2001 - 08:52:12 CDT

Original text of this message

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