RE: copy a datafile to a raw device

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

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

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

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

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

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

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

RE: copy a datafile to a raw device

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

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

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

RE: copy a datafile to a raw device

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

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

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

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:

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