RE: copy a datafile to a raw device
Stephen / Gene, Actually there is no difference between Raw Devices and File Systems when Oracle reads/writes Oracle Blocks. It is the OS interface that is different -- Character-device or Block-device. Most OSs include a header portion in a Raw Device which must be skipped because when Oracle makes read/write calls to the file [ie, the Raw Device] the OS automatically ignores the header. See these Notes on MetaLink 1. Note 23037.1 on Raw Partitions as Oracle Data Files 2. Note 45351.1 for Digital Unix [skip block of 64K] 3. Note 146384.1 for HP-UX [skip block of 8K] 4. Note 153892.1 on how to use RMAN to copy the data Hemant At 01:19 PM 19-06-03 -0800, you wrote: I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to "format" the raw device and essentially create a sort of proprietary "file system" there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: "This might be a raw device, but it ain't no stinkin' ORACLE raw device." Or, to put it another way: "What's this merde?" (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) > -Original Message- > From: Stephen Lee > Sent: Thursday, June 19, 2003 3:27 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: copy a datafile to a raw device > > > > 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 OR
RE: copy a datafile to a raw device
You just have lots of empty space left on your raw device. -Original Message- Sent: Thursday, June 19, 2003 6:30 PM To: Multiple recipients of list ORACLE-L And if I dd a 200 Mb data file to a 1500 Mb raw device ??? > -Original Message- > > > Well, this oracle "file system" is the logical storage structure of > tablespace, segment, extent, db blocks which is the same on > File System or raw device. > -- 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: Richard Ji 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).
RE: copy a datafile to a raw device
And if I dd a 200 Mb data file to a 1500 Mb raw device ??? > -Original Message- > > > Well, this oracle "file system" is the logical storage structure of > tablespace, segment, extent, db blocks which is the same on > File System or raw device. > -- 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).
RE: copy a datafile to a raw device
You didn't mention what Unix platform you are on. But since a striaght dd didn't work, you need to use seek to skip some blocks. -Original Message- Sent: Thursday, June 19, 2003 2:55 PM To: Multiple recipients of list ORACLE-L 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: Richard Ji 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).
RE: copy a datafile to a raw device
You left out, "...and why is there a goat in the corner?" Sounds like a fun way to have at my duhvelopers (not the good ones). -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/19/03 4:49 PM Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: copy a datafile to a raw device
Well, this oracle "file system" is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. Richard Ji -Original Message- Sent: Thursday, June 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to "format" the raw device and essentially create a sort of proprietary "file system" there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: "This might be a raw device, but it ain't no stinkin' ORACLE raw device." Or, to put it another way: "What's this merde?" (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) > -Original Message- > From: Stephen Lee > Sent: Thursday, June 19, 2003 3:27 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: copy a datafile to a raw device > > > > 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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: copy a datafile to a raw device
Concerning my speculation about error messages in the Oracle kernel, the following is an actual error message in an app here. Of course, the error is never supposed to occur -- so says the programmer when I asked about it. SERROR_MESSAGE := 'How did I Get Here? Where is my car? Who is that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- 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).
Re: copy a datafile to a raw device
Gurelei,ÄúºÃ£¡ hi, what is your OS? In some os, you have to skip some block on that raw device for lvm usage. If you use rman copy, rman will handle it for you. Good luck === 2003-06-19 10:55:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== >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). = = = = = = = = = = = = = = = = = = = = Ö Àñ£¡ chao_ping [EMAIL PROTECTED] 2003-06-20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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).
RE: copy a datafile to a raw device
I might expand on this some. If you think about it, any time you store bytes on something, the storing process has to make a note of where it put the bytes; maybe how many bytes it put there; if the bytes are not contiguous, then info about where one set leaves off and where the next set picks up. And on and on ... I've never worked with Oracle raw devices and am just guessing here, but applying some knowledge about how other forms of storage work, I seems logical that Oracle would have to "format" the raw device and essentially create a sort of proprietary "file system" there. If you just toss some bytes on a raw device and tell Oracle to go get 'em, then I'm guessing Oracle will just say something like: "This might be a raw device, but it ain't no stinkin' ORACLE raw device." Or, to put it another way: "What's this merde?" (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) > -Original Message- > From: Stephen Lee > Sent: Thursday, June 19, 2003 3:27 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: copy a datafile to a raw device > > > > 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: 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).
RE: copy a datafile to a raw device
Dennis, Thanks for your input. I am doing what the manual says - shutdown , copy, mount, alter, open and every time I'm getting the "unknown file header" message. I suspect that I am missing some parameters in my dd command because of - as Stephen suggested - different formats. I guess I will have to play with different parameters to see which one is correct. thanks Gene --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > 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] > > __ 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).
RE: copy a datafile to a raw device
What platform is this on? On some UNIX platforms the file header for the raw device may vary in size. (It has been a while since I dealt with raw devices). You may have to use seek= option (dd command) to skip the header bytes before actually writing the data using 'dd'. Or just call Oracle Support. - Kirti --- Stephen Lee <[EMAIL PROTECTED]> wrote: > > 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: Kirtikumar Deshpande 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).
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
RE: copy a datafile to a raw device
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).
RE: copy a datafile to a raw device
Title: RE: copy a datafile to a raw device It's been a number of years since I did anything with raw devices, so this is all ancient and possibly out of date/incorrect. I believe Stephen to be wrong. The bits and bytes written on the data file are identical, regardless of whether the device is raw or cooked. However, back in the day I worked with these, the file could not use the first block of the raw device, as that was reserved for operating system usage (and back then on those devices, this was 8K). So, we had to do something like dd if=system of=/dev/raw obs=8192 seek=1 to force the dd to skip the first 8K. Since you have already overwritten the first block of the raw device, you might have to drop it and re-create it. Also, since the first 8K was reserved for the OS, the size of the raw device must be at LEAST the size of the datafile + 8K. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended. All Targets Met. All Systems Working. All Customers Satisfied. All Staff Enthusiastic. All Pigs Fed And Ready To Fly. -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 19, 2003 4:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: copy a datafile to a raw device 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).
RE: copy a datafile to a raw device
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).
