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

Migrate Oracle 8i from one server to another

I want to know the steps to carry out the migration from one Oracle server to another server (same environment). My database is Oracle 8i on Windows 2000.

I am a newbie in this forum and as an Oracle DBA. I want to know the steps to carry out the migration from one Oracle server to another server (same environment). My database is Oracle 8i on Windows 2000.
At a very high level, these are the steps you will want to follow to clone a database from one server to another.
  1. Backup the controlfile to trace on the source database:
    alter database backup controlfile to trace;
    
    This will create a SQL script in the user_dump_destination. You may have to copy this to the target server and modify it if you are changing any datafile locations or the SID of the target database.
  2. Create an Oracle service on the target server using oradim. For more information on how to do this, refer to the Oracle8i Administrator's Guide for Windows NT.
  3. Now you will need to copy the datafiles, controlfiles, online redo logs from the source to the target server. The easiest way is to take a cold backup of the source database but this requires shutting down the database. If this is not possible, you can create a copy of the database with it available by performing a hot backup and restoring it to the target server. This requires putting all tablespaces in backup mode, copying the associated datafiles and then taking the tablespaces out of backup mode. But this will complicate matters since you will then have to apply at least a couple of archived redo logs and perform an incomplete recovery to a point in time on the target database.
  4. If you are able to shut down the source database and copy it to the target, assuming the environment remains the same and the SID does not change, you can simply open the copied database with the 'startup;' command. If this is an incomplete recovery, you must recover the target database to a point-in-time and then open the database with the resetlogs option (alter database open resetlogs;).

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