Re: copy a datafile to a raw device

Gene,

        I recall a similar scenario (this was Oracle7, so it may not apply). The real issue was that oracle uses different file header configurations for cooked and raw files when it uses them. I don't think you can copy the file to a raw device and expect oracle to be happy about it. I think you will have to recreate the database (since it is the system tablespace). If it were another tablespace, I think you could get by with just recreating the tablespace.

Daniel Fink

> > -----Original Message-----
> > From: Gurelei [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 19, 2003 1:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: copy a datafile to a raw device
> >
> >
> > hi all:
> >
> > I need to move a SYSTEM datafile from a filesystem
> > to a raw device. I have shutdown the database,
> > copied the file via
> >
> > dd if=system of=/dev/raw
> >
> > renamed the file in the database, but couldn't open
> > the database because of the error: Unknown File Header
> > Version read for file number 1.
> >
> > I tried another dd:
> >
> > dd if=system of=/dev/raw obs=32768 (32K is the db
> > block size), but I got the same error. Can anyone
> > see what else could be wrong with my dd command
> >
> > thanks
> >
> > Genebegin:vcard

n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard Received on Thu Jun 19 2003 - 15:22:22 CDT