Home » RDBMS Server » Backup & Recovery » Problem after restoring a database on new host (11.2,windows server 2008)
Problem after restoring a database on new host [message #611648] Sun, 06 April 2014 02:27 Go to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
Hi,

I did database restoration on a new host successfully by taking the following steps:
1-set oracle_sid=orcl
2-RMAN> CONNECT TARGET /
3-shutdown immediate;
  SET DBID 1354693553
4- STARTUP NOMOUNT
5-RUN{
  RESTORE SPFILE
  TO PFILE 'C:\Users\Administrator\Desktop\NewPfile\initorcl.ora'
  FROM 'C:\Users\Administrator\Desktop\53 Files\LstBack\FULL-16-1-1393-8-54-10-0-  ORCL-0NP4V2MR-23-1.BAK';
  SHUTDOWN ABORT;
}
5--STARTUP FORCE NOMOUNT PFILE='C:\Users\Administrator\Desktop\NewPfile\initorcl.ora'
6-RUN{
  RESTORE CONTROLFILE FROM 'C:\Users\Administrator\Desktop\53 Files\LstBack\FULL-   16-1-1393-8-54-10-0-ORCL-0NP4V2MR-23-1.BAK';
  ALTER DATABASE MOUNT;
}
7-
RUN{
RESTORE DATABASE ;
RECOVER DATABASE;
}
8-restore spfile from  'C:\Users\Administrator\Desktop\53 Files\LstBack\FULL 16-1-1393-8-54-10-0-ORCL-0NP4V2MR-23-1.BAK';


But after shutting down the database and start up it,the following error occurred:

SQL> startup
ORACLE instance started.

Total System Global Area 8384552960 bytes
Fixed Size                  2192456 bytes
Variable Size            4294970296 bytes
Database Buffers         4076863488 bytes
Redo Buffers               10526720 bytes
ORA-00205: error in identifying control file, check alert log for more info


why? While I've already restoring controlfile and spfile.
Re: Problem after restoring a database on new host [message #611649 is a reply to message #611648] Sun, 06 April 2014 02:52 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you check alert log for more info?
Re: Problem after restoring a database on new host [message #611650 is a reply to message #611649] Sun, 06 April 2014 03:02 Go to previous messageGo to next message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
yes I checked and the messages are as follow:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/orcl/controlfile/current.260.826912817'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/controlfile/current.260.826912817
ORA-15012: ASM file '+DATA/orcl/controlfile/current.260.826912817' does not exist
Re: Problem after restoring a database on new host [message #611651 is a reply to message #611650] Sun, 06 April 2014 03:20 Go to previous messageGo to next message
John Watson
Messages: 4689
Registered: January 2010
Location: Global Village
Senior Member
When you restore a file to an ASM diskgroup, it will be created with a new incarnation number. Therefore, the name in your parameter file will no longer be correct. You need to compare the name it is looking for (as shown in your error message) with the name of the file that was restored to confirm this.
The solution is to create an alias for the file: an alias is a stable filename that ASM will map to whatever the actual filename happens to be (including the incarnation number). You can do this explictly (look up ALTER DISKGROUP...ADD ALIAS...) or implicitly in your RESTORE CONTROLFILE command.
Re: Problem after restoring a database on new host [message #611653 is a reply to message #611648] Sun, 06 April 2014 05:53 Go to previous message
kakakoko
Messages: 22
Registered: March 2014
Junior Member
Thank you John Watson, you said right.
I found the correct name of the controlfile using ASMCMD>+Data/orcl/controlfile ls command, then I modified spfile and database start up correctly.
Previous Topic: Strange problem about incremental level 1 cumulative backup
Next Topic: Restore a database on new host (Problem 2)
Goto Forum:
  


Current Time: Fri Oct 24 07:22:01 CDT 2014

Total time taken to generate the page: 0.23183 seconds