Re: move datafile from file system to raw device

From: tak lam <taklam_at_graduate.hku.hk>
Date: Thu, 08 Feb 2001 01:49:31 +0000
Message-ID: <3A826BAA.84656F03@graduate.hku.hk>

Hi,

Actually i did.

The question is, after i do dd, if i wana to use back the file system datafile, the error prompts out..

such that:

(1) offline tablespace (with only one data file)
(2) dd the datafile to raw device
(3) alter location of the datafile from original to raw device
(4) alter back the location of datafile so it's pointing to the file system

file
(5) alter the tablespace online ==> error comes out saying the file system file need media recovery..

so ? where will be the problem?

Kevin Brand wrote:

> Between steps two and three below, you should change the datafile name in
> the controlfile ( via SQL ) before trying to online the thing.
> Alternatively, you could make the /oracle/u01/datafile/db01t1.dbf file a
> symbolic link to /dev/rdisk/xyz.
>
> -Kevin
>
> "Eric Lam" <eric.lam_at_datacraft-asia.com> wrote in message
> news:3A815CED.4EED0167_at_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 - 19:49:31 CST