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

Restoring an Oracle backup to a new Windows server

I am a senior SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a new server to simulate a disaster. Please provide me with a process of restoring just a backup to a new Windows server.

I am a senior SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g Database.

I am having a lot of difficulty understanding the process of recovering from a backup to a new server only using the backup files. This is a fairly simplistic task in SQL Server but the process in Oracle is in many shades gray. Please provide me with a process of restoring just a backup to a new Windows server. The database is in archive mode. Thanks boatloads!

One of the best things one can do when learning how to back up an Oracle database, especially if they are using Oracle 10g, is to learn Oracle's Recovery Manager (RMAN). RMAN does have a bit of a learning curve, but once you understand it, backing up the database is as simple as the "backup database" command. And restoring from most failures is as simple as "restore database" followed by "recover database." Oracle 10g makes this entire process much easier by introducing the Flash Recovery Area. With this feature, RMAN can back up everything to one location and this is scheduled to occur on a regular basis in Enterprise Manager. RMAN manages everything for you from determining which backup is best to use to figuring out which pieces need restoration.

For more information on RMAN, please read the Backup and Recovery Basics guide.

If you do not want to use RMAN, you can use the traditional user-managed backups. Details are found in the Advanced Backup & Recovery Guide. Chapter 7 of this guide shows how to restore an RMAN backup to a new server.

The unfortunate thing is that there are so many options with backing up Oracle databases, it is difficult to say the exact method to restore the database to a new server. If you are using RMAN, then it is best if you also implement a Recovery Catalog (RC) so that you have information on what was backed up where. The RC should not be on the same server as your database. When restoring to your new server, you install Oracle on the new server and then copy your RMAN backup sets to this new server. You start up RMAN and then tell it to do the restore. If you are using User Managed Backups, you can create a database on the new server that looks identical to the old one. Then overwrite the database's datafiles with the backups you have stored on tape.

I highly recommend learning and implementing RMAN for your backup and recovery needs. Oracle (with RMAN) has so many backup and recovery options that you can backup for virtually any scenario and restore from any situation. In this respect, Oracle is lightyears ahead of SQL Server. However, with all of this functionality comes complexity.

Dig Deeper on Oracle database backup and recovery

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