Re: What is the best way to copy a database to another machine?

Hi,
here is my opinion:
1) If it is to be a 1:1 copy, this should be the fastest alternative under the assumption
that the directory structure on the destination machine will be exactly the same as on
the original one. Otherwise you would have to rename manually all the files using the
ALTER DATABASE command. If the server on the destination machine is not installed
yet, you must install it and then manually create the services (or let the system create
a database just for the purpose of creating services). 2) I have no experience with "Standby" option. 3) Export/import is good if you want to uitlize the opportunity to reorganize the
dababase, like changing the directory structure, compacting tables into one extent, etc.
But it may take quite a long time, especially import. 4) Here I don't understand quite well what type of backup you mean. If it's  a cold backup
of the database then it's more or less equivalent to 1).

I hope it will help you in deciding,

Regards,
--
Pavel Polcar

Steven Peterson <stevenpeterson_at_mindspring.com> wrote in article <3569FD04.11990CDD_at_mindspring.com>...
> Hi,
>
> I need to make an exact copy of a database on another machine (Both
> original and copy are on Windows NT machines running Oracle 7.3
> Workgroup server). I have seen the following methods discussed in this
> newsgroup:
> 1) Take the servers down, copy all files from the database directory
> of one machine to the other, then restart.
> 2) Use the "Standby" server option
> 3) Use export/import
> 4) Use backup.
>
> Does anyone have a pointer to a discussion of the pros/cons of each
> method and/or a recommendation?
>
> --
> Steven Peterson, President
> Frontier Productions, Inc.
> 310 Wesley Drive
> Chapel Hill, NC 27516
> Tel 919-942-1386; Fax 919-933-2677
> peterson_at_frontier-news.com
>
>
>
Received on Tue May 26 1998 - 02:06:31 CDT