RE: Combination of Raw Volumes and File Systems

I've used Waleed's method to clone a database a number of times. The steps were:

	Place tablespaces in hot backup mode
	Use dd to copy the RAW device files to Unix file system files
	RCP the files to another host
	Use dd to copy the files back to RAW devices
	Recover the database

As part of the dd command you need to specify the block size of the RAW device. The cloned database had most of it's files on RAW devices but a few on filesystems due to space limits. I did not mix file type within a tablespace. Both the hosts were the same OS (HP 10.20) and same Oracle version (7.3.4).

Dave

> "Khedr, Waleed" wrote:
>
> > I have not done this but I believe an Oracle file is the same whether it
> is
> > Raw or Cooked.
>
> NO, this is not correct. My personal experience say - db may have both raw
> and
> common FS files, but you can transfer data berween them only using IMP/EXP
> Vadim
>
> >
> > What you will need to copy the Raw file to UFS using some tool may be dd
> and
> > then (alter database rename old-file to new-file location) after putting
> > tablespace in offline mode.
> >
> > You will need to know the exact number of blocks inside the raw file to
> > copy.
> >
> > Any corrections are welcomed,
> >
> > Waleed
> >
> > -----Original Message-----
> > Sent: Thursday, July 06, 2000 12:27 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Has anyone on the list created data files for a tablespace where one was
> on
> > a raw volume and the other was on a file system?
> >
> > We contacted Oracle support and they said it was fine, but the whole
> > "Database Weirdness" thread that I started came into being when this
> change
> > was made.
> >
> > Any thoughts or experience with this would be appreciated.
> >
> > Also, if you think this is a bad idea, suggestions on how to undo it
> would
> > be appreciated, since data is already stored in the new data files.
> >
> > Thanks in advance to the always helpful list...
> > Steve Monaghan
> > WorldCom
> > Long Island, New York
> >
> > --
> > Author: Steven Monaghan
Received on Fri Jul 07 2000 - 06:51:51 CDT