Re: Copying a Database (NT)

Copy an Oracle database on NT;

1. From svrmgr23 or sqlplus;
   · Alter database backup control file to trace;
   · Copy this file to a new name for editingl
   
2. Shutdown the database.
3. Copy the data files to the target directory.
4. Rename the files;
   · Rename *OLD.ora *NEW.ora
   
5. Create a new init.ora (if one doesn't already exist);
   · Copy source init.ora to new init.ora
   · Replace all DB strings with new DB;
   · ReplaceOLD with NEW
   
6. Edit the trace file from step 1;
   · Change all OLD to NEW
   · Change reuse database OLD to set database NEW
   · Change noresetlogs to resetlogs
   · Change alter database open to alter database open resetlogs;
   
7. Start the NT services;
   · If the instance already existed you can use services applet, otherwise you
   need to create the services.
8. From svrmgr23;
   · Run the tracefile from step 1; @d:\orant\database\NEWdb.sql
   · Shutdown the database
   
9. Restart the database in normal mode.
10. Sign on as a DBA and 'alter database rename global_name to NEW;'

You now have an exact copy to the original database, this is MUCH faster than export/import ....

Tim. Received on Tue May 05 1998 - 19:42:31 CDT