Recovering cold backup - running in circles - part 2 -Second opinion needed
832770Jul 12 2011 — edited Jul 13 2011Hello all,
Here I'm again but this time not to ask for a complete solution where I have to do nothing but a second opinion and some help in solving.
In the thread [Recovering cold backup - alter database open failing - running in circles |http://forums.oracle.com/forums/thread.jspa?messageID=9663720] , I was trying to recover a database (I still am) for one of our clients.
Since then a few things have changed, from our client we have no received the installation media for their database software: Oracle 10.0.1.0.2.
I have installed this on a Linux, an opensuse while they used a RHEL 4, placed the database files in the a similar map structure as theirs and made sure that all the ORACLE variables were correctly set, we have also received the pfile and I made the corresponding initfile from.
I start sqlplus / as sysdba
Mounting the database no problem.
Trying to open the database I receive the following error ORA-01207: file is more recent than controlfile – old controlfile, the error refers to the Datafile 2: '/home/oracle/product/10.1.0/oradata/orcl/undotbs01.dbf'.
Their is no corresponding error message in the alert log, well their is but it doesn't really give me the information I was looking for.
Mon Jul 11 16:38:26 2011
alter database open
ORA-1122 signalled during: alter database open...
Mon Jul 11 16:44:51 2011
ALTER DATABASE RECOVER database
Mon Jul 11 16:44:51 2011
Media Recovery Start
Media Recovery failed with error 1122
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
I then attempted to do a media recovery using recover database using backup controlfile, which fails because it can not find a corresponding backup controlfile.
The section generated in the alert log did however worry me more:
ALTER DATABASE RECOVER database using backup controlfile
Mon Jul 11 16:46:15 2011
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
Starting datafile 1 with incarnation depth 0 in thread 1 sequence 1818761
Datafile 1: '/home/oracle/product/10.1.0/oradata/orcl/system01.dbf'
Starting datafile 2 with incarnation depth 0 in thread 1 sequence 1818764
Datafile 2: '/home/oracle/product/10.1.0/oradata/orcl/undotbs01.dbf'
Starting datafile 3 with incarnation depth 0 in thread 1 sequence 1818761
Datafile 3: '/home/oracle/product/10.1.0/oradata/orcl/sysaux01.dbf'
Starting datafile 4 with incarnation depth 0 in thread 1 sequence 1818765
Datafile 4: '/home/oracle/product/10.1.0/oradata/orcl/users01.dbf'
Starting datafile 5 with incarnation depth 0 in thread 1 sequence 1818761
Datafile 5: '/home/oracle/product/10.1.0/oradata/orcl/temp02.dbf'
Media Recovery Log
So that could mean that they've just taken a copy off the files without offlining the database first, anyway to confirm this.
I've come to a point where I have not an immediately clue of what to do, some help even a little push could be helpful.