Re: How to move raw datafiles?

From: Erwin Dondorp <erwin_at_dondorp.com>
Date: Sun, 22 Oct 2000 22:36:28 +0200
Message-ID: <39F34FCC.4C7ED86@dondorp.com>

mr_potato_head_at_my-deja.com wrote:
> Can someone explain to me in detail how to move my raw datafiles?

Rule #1: Make sure the disk sizes are equal!

The procedure is the same as for moving database files in the filesystem.
Use all the usual "ALTER DATABASE" commands. But instead of the "mv" or "cp" command use the "dd" command.

e.g.:

        dd if=/dev/sourcedisk of=/dev/destdisk bs=1024000

With the explicit block size ("bs=" clause) things should be faster and you will be able to verify the amount of bytes transferred. The output of "dd" will be something like

	1000+1 blocks read
	1000+1 blocks written

The numbers indicate the number of full+partial block transfers. See also "man dd".

        Erwin Received on Sun Oct 22 2000 - 15:36:28 CDT