Showing posts from February, 2016

Restoring and Recovering the Database on a New Host using RMAN

This blog will demonstrate detailed steps to restore a database on New Host using RMAN. You can also use it to move a production database to new host as test database. Here, we are going to use the source database with the DB_NAME=ORCL and we are going to restore this ORCL database on the test database machine. 1. Preparing to restore the database on a new host: If you use the procedure in this section, then the DBID for the restored database equals the DBID for the original database. Do not register a test database created in this way in the same recovery catalog as the source database. Because the DBID of the two databases is the same, the metadata for the test database can interfere with RMAN's ability to restore and recover the source database.  Record the DBID for your source database. You can find the DBID by connecting to the database with RMAN as shown below: Take backups of all the datafiles, controlfiles, spfile and archivelog files on the source database