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!
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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading