Could you please help me, I have a problem with control file restore.
ORA-01103: database name 'NEWSID' in control file is not 'OLDSID'
I am doing full database restore from Backup server using Symantec Backup Utility.
Restore working fine if I restore with original instance name, but if I rename instance I have problem with controlfiles.
1) Create new Password file, instance, Directory Structure
2) Configure Backup EXEC client
3) Restore the SPFILE From RMAN AUTOBACKUP
4) Create PFile from restored SPFILE, Edit PFile
5) Startup the Oracle instance
6) Restore controlfiles from autobackup
7) Create SPFILE
8) Startup database mount-----------HERE I have A problem
ORA-01103: database name 'ORIGINALSID' in control file is not 'NEWSID'
This procedure used to work fine, before I moved our production database to new instance.
Now it is working only if I restore with original database name.
Does anybody know, why it is happened? I guess some settings of production database need to be changed, but I do know which exactly.
I start working with oracle 6 month ago and it is my first question on DBA forums.
#aux DB should be in nomount state
# the DUPLICATE command uses an automatic disk channel
set until time "to_date('May 20 2010 10:50:00','Mon DD YYYY HH24:MI:SS')";
SET NEWNAME FOR DATAFILE 1 TO '/export/home/oracle/AUX/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/export/home/oracle/AUX/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/export/home/oracle/AUX/example01.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/export/home/oracle/AUX/example02.dbf';
SET NEWNAME FOR DATAFILE 5 TO '/export/home/oracle/AUX/tools01.dbf';
SET NEWNAME FOR DATAFILE 6 TO '/export/home/oracle/AUX/users01.dbf';
SET NEWNAME FOR DATAFILE 7 TO '/export/home/oracle/AUX/logmnrts.dbf';
SET NEWNAME FOR DATAFILE 8 TO '/export/home/oracle/AUX/marius01.dbf';
DUPLICATE TARGET DATABASE TO AUX
GROUP 1 ('/export/home/oracle/AUX/redo01a.log',
'/export/home/oracle/AUX/redo01b.log') SIZE 10M REUSE,
GROUP 2 ('/export/home/oracle/AUX/redo02a.log',
'/export/home/oracle/AUX/redo02b.log') SIZE 10M REUSE;
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I found mistake.
When did edit PFILE,
I changed *.db_name='****'. this was a problem.
You can not change *.db_name='***' parameter
you can change only
I hope it will help somebody.....