How to restore an Oracle RMAN backup to a new SID (4046830)

Date - 10/2007
Affected Product & Version - NetVault: Backup 7.4.5
Affected Module & Version - APM for Oracle (Version 5.0)
OS Version - Any
Application Information - Oracle 10.0.2.x, Oracle 9.x

Description:
Instructions for restoring an Oracle RMAN backup to a new SID.

Symptoms:
When restoring an Oracle instance, it is possible to restore the database to an Oracle instance with a new SID provided that the new instance has the same DBID as the original instance that was backed up.

1. Check the DBID of the backup, you can do this by looking at the NetVault log of the backup, filter the logs on "all" and there is a line that reads:
Job Message 2007/10/08 10:11:49 302 Data Plugin nv_kerri connected to target database: TEST (DBID=1931409638)

2. Check the DBID of the target database:
to do this run the following command in a SQL*plus session:
SQL> select DBID from v$database;

DBID
----------
1931409638

3. Provided these two are the same you can perform the restore, if not the restore will fail.

4. To restore to the new SID, enter the SID name, user and password in the "Restore Options" "Destination Details" sub-tab.

5. The rest of the restore job configuration is as normal.

Discussion
It is NOT possible to restore a database to a new SID with a new DBID, the DBID has to correspond to that in the backups.

This type of restore would typically be used in an environment where a "TEST" database was promoted to a "PRODUCTION" database with a corresponding SID change.