I am not sure how you can copy a regular file which is operating system dependent to a row file which is managed by Oracle using dd. To me, your only option may be export/import.
Regards, Shakir --- Gene Sais <[EMAIL PROTECTED]> wrote: > Another option is to shutdown db, backup the files to tape, remove > filesystems, create symbolic links named the same as your datafile > names linked to the raw devices, restore files to symbolic links > (i.e. raw devices), startup db. Just a thought. > > Gene > > >>> [EMAIL PROTECTED] 09/20/02 04:20PM >>> > Denis, > > Sorry I missed your main question last time. Each datafile in our > database > will represent a separate raw device. so question of overwriting > files will > never come. If I have 30 datafiles in 5 files systems, I will be > creating > 30 raw devices with properly sized devices to match my datafile size. > As of > now I have created a spreadsheet which is mapping each of datafile to > new > raw device. I have taken current size of my datafile + added a buffer > size + > growth for next 2 months. Hope this works without any problem. Let > me know > what you think about this. > > Thanks, > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, September 20, 2002 3:43 PM > > > Nat - I think your process looks fine, bearing in mind that I haven't > used > raw devices in years. Others on the list use raw on a daily basis, so > may > offer some suggestions. > My question was much simpler. Suppose I have a 80-gig. device, and > a > 20-gig. datafile. Okay, my recollection is that I can use dd to copy > that > datafile onto that device. But that leaves 60-gig. (give or take a > few megs) > unused. If I copy another datafile to that device, since this isn't a > file > system, it will simply overwrite the first file. So I have 60-gig of > wasted > space, unless I issue an Oracle command to expand the datafile to use > the > rest of the device. You are right, that copying datafiles is MUCH > faster > than moving data within Oracle, I'm just curious how you plan to deal > with > size mismatches. > Am I missing something here? > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > -----Original Message----- > Sent: Friday, September 20, 2002 2:09 PM > To: Multiple recipients of list ORACLE-L > > > Dennis, > > We are thinking of doing following steps for our RAW conversions. > Let me know whether it makes sense, > > 1. Shutdown Database. > 2. Take Full Backup > 3. Setup all our raw devices ( properly corresponding to our original > filesystem datafiles.) > 4. Bring up the database in restricted mode. > 4. Bring tablespace offline > 5. Use the dd command to move the datafiles to the raw device. > 6. Rename the moved datafile > 7. Bring the tablespace online > 8. repeat this process till you move all you datafiles. > > We feel creating table as select * or export /import is not feasible > as our > database is big > (around 400 Gigs ) with very large tables. > > Thanks, > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, September 20, 2002 12:18 PM > > > Nat - I haven't worked with raw for a few years, but from my dim > recollection, since you are managing what is on the device, first the > system > administrator had to tell me how many blocks I could write to. I also > dimly > recall the AIX issue, but certainly couldn't recall the answer. > Anyway, this > means that you have only a single file on the device. Based on that, > my > assumption was that you would want to use the entire disk and it > would be > unlikely that your file system file would coincidentally the same > size as > your raw device, so you would want to precreate a new tablespace with > a > datafile of just the right size. That means that you would need to > move the > data itself, not just the datafile. Am I missing something here, or > just > brain-dead on Friday? > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > -----Original Message----- > Sent: Friday, September 20, 2002 9:33 AM > To: Multiple recipients of list ORACLE-L > > > Mark, > Thanks for the reply. We are on AIX 4.3. > We are not changing hardware when we move on to RAW devices. Our > entire > hardware is going to remain same. > We feel dd is the fastest method of copying the files. But we need to > figure > out how many blocks > we should skip in raw devices.(point 2 in NOTES below). > We still do not know how to do that. Metalink says if we use RMAN we > do not > need to > do any header calculation . Below is the article from metalink.. > Thanks again for your suggestions. > > goal: How to convert datafile from raw device to file system > > a.. fact: Oracle Server - Enterprise Edition > > a.. fix: > > Use RMAN to move datafiles from raw devices to file system. > > 1. Connect to the database: > > $ sqlplus system/manager@orcl > > 2. Put the tablespace with the datafile, which should be converted, > offline: > > SQL> alter tablespace test_ts offline; > > 3. Start rman and connect it to the database: > > $ rman nocatalog target rman/rman@orcl > > 4. Move the datafile to file system: > > RMAN> run { > 2> allocate channel c1 type disk; > 3> copy datafile '/dev/raw1' to '/u01/oradata/orcl/test_ts.dbf'; > 4> } > > 5. Rename the moved datafile: > > SQL> alter database rename file '/dev/raw1' to > '/u01/oradata/orcl/test_ts. > dbf'; > > 6. Put the tablespace back online: > > SQL> alter tablespace test_ts online; > > > Notes: > ====== > 1. If you are using RMAN as the backup tool then a backup after the > performed > steps is recommended, because otherwise RMAN treats the copied file > as a > backup. > > 2. Usually Oracle datafiles are moved from filesystem to raw devices > using > the dd command. Using dd is the fastest method to accomplish it. > However, it > is > necessary to know how many blocks to skip in the raw device (e.g. it > is > necessary to skip 64K on Tru64 Unix), so that the information > necessary for > the Operating System is not overwritten. The information on how many > blocks > to > skip is different on the different platforms. Using RMAN there's no > necessity > to know such platform specific information. > > . > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, September 19, 2002 5:28 PM > > > > Hi Nat, > > > > As long as you are not changing hardware platforms, you can use dd. > (Of > > course, I assume you're on some flavor of unix, since you didn't > mention > > OS.) > > > > You can just do 'dd if=/path/to/filsystem/datafile > > of=/path/to/raw/volume'. > > > > Of course, your database must be down. > > > > -Mark > > > > On Thu, 2002-09-19 at 14:38, Nat wrote: > > > We are planning to move to raw devices for all our existing file > systems. > > > Our database size is around 400 Gig. What is the recommended > method that > you > > > guys feel is best as far as time > > > required to convert and ease of conversion. > > > > > > We feel we cannot use export - import as this may take more time > for > > > conversion.. > > > I checked many documents to find out the best method, there are > few > > > suggestions to use RMAN to convert to raw. > > > seems it is fastest. At this point we have not configured RMAN on > our > > > databases so this suggestion seems to be of no use for us. > > > > > > Please let me know, if any of you went through this exercise and > any > > > suggestions and tips will be more beneficial, > > > > > > Thanks in advance, > > -- > > -- > > Mark J. Bobak > > Oracle DBA > > [EMAIL PROTECTED] > > "It is not enough to have a good mind. The main thing is to use it > > well." > > -- Rene Descartes > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mark J. Bobak > > 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.com > -- > Author: Nat > 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.com > -- > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nat > 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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > N to > 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.com > -- > Author: Nat > 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.com > -- > Author: Gene Sais > 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). ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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).
