Hi
I'm restoring Production Oracle Server database backup to Disaster Recovery database Server using Symantec Backup Exec 2010.
Both Production & DR servers (Windows 2008 R2) have identical Oracle (Oracle 11g) database settings, database file location and database instance names.
In order to get successful restore to DR Oracle server, DBID of DR Oracle server should be same as Production server. I have been trying to change DBID of DR Oracle server, but it is not changing
I have run following commands on Oracle DR server to change DBID:
SQL>shutdown immediate;
SQL>startup nomount;
RMAN>set DBID=2701663xxx;
The Output of set DBID= 2701663xxx, is below:
executing command: SET DBID
when I go back to SQL> prompt and type select dbid from v$database; then it shows me the current ID of Oracle DR Server and doesn't change the DBID to 2701663xxx
Can someone please help ?
Thanks