Incomplete recovery question again

From: eAddict <eAddict_at_gmail.com>
Date: Thu, 25 Oct 2007 09:56:13 -0700
Message-ID: <1193331373.552199.136060@y42g2000hsy.googlegroups.com>

So.... how do I debug what I might have done wrong? Why isn't this cancel based recovery working?

SQL> recover database using backup controlfile until cancel; ORA-00279: change 2331427995 generated at 10/24/2007 20:06:07 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052286.ARC
ORA-00280: change 2331427995 for thread 1 is in sequence #52286

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraBCV/hot/oradba/sisi/arch/sisi0000052286.ARC
ORA-00279: change 2331445667 generated at 10/24/2007 21:09:47 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052287.ARC
ORA-00280: change 2331445667 for thread 1 is in sequence #52287 ORA-00278: log file '/oraBCV/hot/oradba/sisi/arch/sisi0000052286.ARC' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraBCV/hot/oradba/sisi/arch/sisi0000052287.ARC
ORA-00279: change 2331445971 generated at 10/24/2007 21:10:10 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052288.ARC
ORA-00280: change 2331445971 for thread 1 is in sequence #52288 ORA-00278: log file '/oraBCV/hot/oradba/sisi/arch/sisi0000052287.ARC' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraBCV/hot/oradba/sisi/arch/sisi0000052288.ARC
ORA-00279: change 2331446250 generated at 10/24/2007 21:10:49 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052289.ARC
ORA-00280: change 2331446250 for thread 1 is in sequence #52289 ORA-00278: log file '/oraBCV/hot/oradba/sisi/arch/sisi0000052288.ARC' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraBCV/hot/oradba/sisi/arch/sisi0000052289.ARC
ORA-00279: change 2331446507 generated at 10/24/2007 21:10:56 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052290.ARC
ORA-00280: change 2331446507 for thread 1 is in sequence #52290 ORA-00278: log file '/oraBCV/hot/oradba/sisi/arch/sisi0000052289.ARC' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oraBCV/hot/oradba/sisi/arch/sisi0000052290.ARC
ORA-00279: change 2331447736 generated at 10/24/2007 21:17:42 needed for thread 1
ORA-00289: suggestion : /oraBCV/hot/oradba/sisi/arch/ test0000052291.ARC
ORA-00280: change 2331447736 for thread 1 is in sequence #52291 ORA-00278: log file '/oraBCV/hot/oradba/sisi/arch/sisi0000052290.ARC' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent ORA-01110: data file 2: '/oraBCV/hot/oradba/sisi/oracle/TEMP_01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 2 needs more recovery to be consistent ORA-01110: data file 2: '/oraBCV/hot/oradba/sisi/oracle/TEMP_01.dbf'

SQL>

---

The way the 'backup' was done was a copy of the database was made from a set of mirrored disks. The LIVE database files were put in backup mode, a copy of the control file was made, the disks were split, the LIVE database was taken out of backup mode. Then the mirrors were mounted on another server. I created a new controlfile to change the SID and the path to the files. Then I tried to recover.

What did I miss?
Vince Received on Thu Oct 25 2007 - 11:56:13 CDT