Re: move datafile from file system to raw device

I wouldn't skip the blocks - the _whole_ file has to be copied! Just be careful that your raw partition sizing is correct - I used to work exclusively in (ufs) blocks, and still allowed a little bit of extra room. Now, with a variety of different block sizes, that may not be entirely appropriate.
What error are you getting when you do the dd? And it "overruns"?

"tak lam" <taklam_at_graduate.hku.hk> wrote in message news:3A826BAA.84656F03_at_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 Fri Feb 09 2001 - 21:45:00 CST