This forum is currently locked. You can't register or post questions at this time. (read more)

Problem after restoring a database on new host

All posts relating to Oracle database administration.

Moderator: Tim...

Kakakoko
Member
Posts: 22
Joined: Mon Dec 02, 2013 5:37 am

Problem after restoring a database on new host

Postby Kakakoko » Sun Apr 06, 2014 7:30 am

Hi,

I did database restoration on a new host successfully by taking the following steps:

Code: Select all

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:

Code: Select all

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.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Problem after restoring a database on new host

Postby Tim... » Sun Apr 06, 2014 8:27 am

Hi.

My guess would be you restored it using one (s)pfile, then restarted it using a different one, which has the incorrect location of the controlfiles in it.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron