Gene Good ideas from Stephen. A more basic issue if you haven't dealt with it is that copying a system datafile is different from copying other datafiles. You can't have the database open. I recall that you have to STARTUP MOUNT and ALTER DATABASE DATAFILE. This procedure is covered in the Oracle Manuals. Just thought I should mention this in case you hadn't considered it.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, June 19, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Well heck. Nobody else has replied, so I might take a stab at it here. I suspect that the format of the data (bits and bytes) required on a raw device is different than the format of the data in a file in a file system. I'm stretching a bit here, but I think an analogy would be what would happen if you dd a file from UFS to NTFS. The data on the NTFS might be a digital copy of what was on UFS, but it's format is totally useless in the context of NTFS. > -----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 > > Gene > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
