Q
Problem solve Get help with specific problems with your technologies, process and projects.

Steps to copy an 8i database to another PC

I want to make a copy of an Oracle 8i (8.1.6 Release 2) database named ORCL on another PC with the same name (ORCL). Both PCs are running Windows NT.

This is my logic: Install the Oracle 8i software on the target PC. Then create an instance on the target PC using oradim with the new option. Next, create the same directory (folder) structure on the target PC as on the source PC. Then shutdown the ORCL database on the source PC and take an offline (cold) backup of all datafiles, control files, redo log, archived logs, initialization and password files. Then copy the files from the cold backup to the target PC in the same directories as the source PC. Then start up the new instance on the target PC using oradim with the startup option. Next, set the variable ORALCE_SID = ORCL. Then connect as SQL*PLUS.

Is this the correct process? Am I missing any steps? I am a new DBA so I thought I would ask you some questions before I try this. Thanks.


You've got the basic idea but here's what you should do specifically. Since you want a duplicate of your original database, you will be copying the data and log files from the primary db to new location (make sure your primary db is shutdown at the time in order to insure consistency). But before you can do the copy, you need to create a backup control file of your primary db.

Steps:

  1. Use the alter database backup controlfile to trace command on the primary database to create a create controlfile script.
  2. Shutdown the primary database.
  3. Copy the data and log files over the secondary database. Then you could restart the primary if you wanted.
  4. Next, edit the create control file statement generated prior (in step 1). You'll change the paths to the data and log files.
  5. Use sqlplus or svrmgrl to run that create control file script to recreate the control files for this "copied" instance.
Finally, don't forget to create a good backup of the primary instance before doing any of this. You never know what "accidents" might occur and a good backup will save you if they do.

Note that you could use export/import as well. Particularly the transportable tablespace option. To read more about this, see the Oracle Administrator's guide and the Oracle Utilites guide.

For More Information


Dig Deeper on Oracle database export, import and migration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close