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

From: mako <makoml_at_jcom.home.ne.jp>
Date: Thu, 20 Sep 2001 20:47:00 GMT
Message-ID: <8Bsq7.1593$kn.193446@news1.rdc1.ky.home.ne.jp>

> Second. You did perform and alter database rename datafile ... while the
> database was in mount only.
>
> There are slightly different ways, but there are two issues.
>
> 1) the datafile can't change during the copy in any way.
> 2) you have to make sure that you have all rights to the device.

Thank you Robert.

I tryed again and I succeeded to convert COOKED -> RAW datafile, after grant all rights to the device file.

# chown oracle:dba /dev/vg01/rdata00101
# dd if=/oradata/data00101.dbf of=/dev/vg01/rdata00101 bs=128k

SVRMGR> startup mount
ORACLE instance started.

Total System Global Area                          5188584 bytes

(...)
Database mounted.

SVRMGR> alter database rename file

        '/oradata/data00101.dbf' to '/dev/vg01/rdata00101'; Statement processed.

SVRMGR> alter database rename file

        '/dev/vg01/rdata00101' to '/oradata/CM01/data00101.dbf'; Statement processed.

SVRMGR> alter database open;
Statement processed. Received on Thu Sep 20 2001 - 15:47:00 CDT