I need to restore an Oracle 8i database to a new server running Windows 2000. What do I need to do? I know I should use RMAN to do it, but I want to know:
- Do I have to create an Oracle database with the same name as the old one on the new server, and then run RMAN to restore the database?
- Can I copy everything from the old computer to the new server and then start the Oracle
database? Will it work in this way, assuming the path is the same?
There are many ways to move your database from an Oracle database from one server to another. You can use Oracle's export/import utilities. You can use Transportable Tablespaces. You can copy data from one server to another with database links. All of these choices require you to precreate the destination database.
Many people use backups of the database to move it to a new server. If you shut down your instance, you can take a cold backup of the database and move the backup files to the new server. Provided that you haven't changed your directory structure, the database should start. Since you are running the database on Windows, you'll have to create the Service manually with the oradim utility.
You can also use RMAN to move the database. That option appears to be the solution you are seeking. In RMAN, this is called duplicating a database. Oracle's documentation covers this in much more detail than I could. You can find instructions on duplicating a database with RMAN at the following URL:http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmconc2.htm#1006535
This was first published in September 2004