Re: Oracle8 - copying a database.

Actually, this a shorter way, if you can handle it.

1. In your source database, generate a list of datafiles (including RBS) and redo log members.
2. Do a ALTER DATABASE BACKUP CONTROL FILE to TRACE.
3. Shutdown the source database.
4. At your new destination, put the datafiles and redo log members (copied from source) in the relevant directories. (if you do FTP, do a binary transfer)
5. Take a copy of your INIT<sid>.ORA and copy it to the new destination. Edit it to change the database name and the locations of your control file(s) in your new destination
6. Do NOT take the control files from your source database. We are going to fake a loss of control file.
7. Use the manreadable trace file you got from command #2.
8. Change the old instance name to the new instance name you want. Bruno wrote:
   >
   > I would like to know if someone can tell me how to copy (migrate) an
   > Oracle8 (Enterprise Edition) database from one computer to another. The two
   > computers are connected and both have the Oracle8 Enterprise Edition
   > installed.
   >
   > I already tried to copy the entire Orant directory from one computer to
   > the other but it didn't work.
   >
   > If someone knows how to do it and needs more info on what I have
   > installed, just ask.
   >
   > Thank you.
   >
   > Bruno.