Effectively Prevent Oracle Minimum Downtime Migration Error!!

 Author: Steve

Page: 1 2

Every database administrator aims to perform database migration with minimal downtime. There are lots of tricks that help you accomplish this task without the need to adopt the slow and cumbersome export/import approach. However sometimes it happens that we get stuck in the migration process where errors tell us nothing about it.

Consider a scenario where have production database Oracle 10.1.0.3 (32-bit) and we wanted to migrate it on one server to 10.2.0.3 (64-bit) on another server with downtime of one hour.

We will follow below approach to accomplish the migration with minimum downtime.

Back up the production database:

First of all we will use RMAN to back up our production database a NAS array (/nas)

Create Instance: 

Now we will create an instance on the new server (64-bit 10.2.0.3).

Restore Controlfile:

Then we will restore the controlfile from /nas

Restore Database: 

Now we will restore the database to the new server.

Start Database in Mount Mode:  

Now we will start the database on the new server in mount mode.

Archive Logs:

Now periodically copy archive logs from the old server, catalog them on the new server and recover database over and over. Continue this process until you are ready perform migration.

Start Database in Restricted Mode:

Now shut down the production database and start it in restricted mode. Then archive log current and shut it down again.

Apply Final Archive Log:

Now apply the final archive log to the new server and try ‘alter database open resetlogs upgrade' Continued...

Page: 1 2

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   DBA Tips for Triggers in Oracle 11g!
   Efficient Tips for Renaming Oracle Instance!!
   Oracle Replication, Some Concerns
   Great Tips on Reusing Space after deletion of database data!!