OraFAQ Forum: Backup & Recovery » Problem after restoring a database on new host

Home » RDBMS Server » Backup & Recovery » Problem after restoring a database on new host (11.2,windows server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem after restoring a database on new host [message #611648]

Sun, 06 April 2014 02:27

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.

Report message to a moderator

Re: Problem after restoring a database on new host [message #611649 is a reply to message #611648]

Sun, 06 April 2014 02:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you check alert log for more info?

Report message to a moderator

Re: Problem after restoring a database on new host [message #611650 is a reply to message #611649]

Sun, 06 April 2014 03:02

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

Report message to a moderator

Re: Problem after restoring a database on new host [message #611651 is a reply to message #611650]

Sun, 06 April 2014 03:20

John Watson
Messages: 8968
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.

Report message to a moderator

Re: Problem after restoring a database on new host [message #611653 is a reply to message #611648]

Sun, 06 April 2014 05:53

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.

Report message to a moderator

Previous Topic:	Strange problem about incremental level 1 cumulative backup
Next Topic:	Restore a database on new host (Problem 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 22:20:55 CDT 2025