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

Steven,

#1 will work because you're moving the datafiles between binary compatible machines. The trick then is to create the NT services for Oracle. #2 will work for the same reason as #1, but standbys have a very specific purpose. Make sure you it is a standby you want. #3 will work regardless of machine binary compatibility. Here, you can create an empty database on the receiving machine with Instance Manager and Import your schema(s).
#4 is really either #1 or #3.

Steven Peterson wrote:

> 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 Mon May 25 1998 - 20:46:33 CDT