Dear all,
10r2p4 on solaris
when doing a incomplete recovery of the database.
recover database until cancel using backup controlfile;
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 4849683118 generated at 01/15/2010 23:00:08 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212704_661522334.arc
ORA-00280: change 4849683118 for thread 1 is in sequence #212704
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u07/aux/last/ICON1_212704_661522334.arc
ORA-00279: change 4850072917 generated at 01/15/2010 23:54:50 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212705_661522334.arc
ORA-00280: change 4850072917 for thread 1 is in sequence #212705
ORA-00278: log file '/u07/aux/last/ICON1_212704_661522334.arc' no longer needed
for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u07/aux/last/ICON1_212705_661522334.arc
ORA-00279: change 4850505085 generated at 01/16/2010 00:55:20 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212706_661522334.arc
ORA-00280: change 4850505085 for thread 1 is in sequence #212706
ORA-00278: log file '/u07/aux/last/ICON1_212705_661522334.arc' no longer needed
for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u07/aux/last/ICON1_212706_661522334.arc
ORA-00279: change 4850722209 generated at 01/16/2010 01:31:37 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212707_661522334.arc
ORA-00280: change 4850722209 for thread 1 is in sequence #212707
ORA-00278: log file '/u07/aux/last/ICON1_212706_661522334.arc' no longer needed
for this recovery
when I give CANCEL
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u07/aux/last/ICON1_212709_661522334.arc
ORA-00279: change 4852174376 generated at 01/16/2010 07:32:52 needed for thread
1
ORA-00289: suggestion : /u07/aux/arch/ICON1_212710_661522334.arc
ORA-00280: change 4852174376 for thread 1 is in sequence #212710
ORA-00278: log file '/u07/aux/last/ICON1_212709_661522334.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: '/u01/aux/data/undotbs01.dbf'
ORA-01112: media recovery not started
ORA-01112: media recovery not started - now how to proceed with this ?
Kai