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

From: Steven Peterson <stevenpeterson_at_mindspring.com>
Date: Mon, 25 May 1998 19:21:41 -0400
Message-ID: <3569FD04.11990CDD@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:

Take the servers down, copy all files from the database directory of one machine to the other, then restart.
Use the "Standby" server option
Use export/import
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 - 18:21:41 CDT