move datafile from file system to raw device

From: Eric Lam <eric.lam_at_datacraft-asia.com>
Date: Wed, 07 Feb 2001 06:34:21 +0000
Message-ID: <3A815CED.4EED0167@datacraft-asia.com>

Hi all,

Currently we are trying to move a oracle database's datafile from file system file to raw device..
it's running oracle 8.1.5 over Digital Unix (v4.0f)

we managed to do it by skipping the first 64k header of raw device using dd.

but after we dd the file system datafile .. when we try to online the tablespace which offlined for dd using the file system datafile, the below error occured:

SVRMGR> alter tablespace test1 online;
alter tablespace test1 online
*
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: '/oracle/u01/datafile/db01t1.dbf'

The overflow:
(1) alter tablespace test1 offline; (test1 is rely only on one datafile,
db01t1.dbf, file system file)
(2) dd oseek=128 if='/oracle/u01/datafile/db01t1.dbf'
of='/dev/rdisk/xyz'
(3) alter tablespace test1 online; (then the above error occured)

my question is... why?????

many thx! Received on Wed Feb 07 2001 - 00:34:21 CST