Database recovery issue
739888Feb 22 2011 — edited Feb 24 2011Hi,
When I tried to recover my backup database recovery process goes for sometime and suddenly it gives following error and exit.
(Oracle database 10g / Linux)
ORA-00279: change 30595957791 generated at 02/19/2011 07:09:53 needed for*
thread 1*
ORA-00289: suggestion :*
+/u01/app/oracle/flash_recovery_area/STAR10G3/archivelog/2011_02_22/o1_mf_1_97240+
+9_%u_.arc+
ORA-00280: change 30595957791 for thread 1 is in sequence #972409*
ORA-00278: log file*
+'/u01/app/oracle/flash_recovery_area/STAR10G3/archivelog/2011_02_19/o1_mf_1_9724+
+08_6oy7v9gn_.arc' no longer needed for this recovery+
ORA-00279: change 30595958688 generated at 02/19/2011 07:09:53 needed for*
thread 1*
ORA-00289: suggestion :*
+/u01/app/oracle/flash_recovery_area/STAR10G3/archivelog/2011_02_22/o1_mf_1_97241+
+0_%u_.arc+
ORA-00280: change 30595958688 for thread 1 is in sequence #972410*
ORA-00278: log file*
+'/u01/app/oracle/flash_recovery_area/STAR10G3/archivelog/2011_02_19/o1_mf_1_9724+
+09_6oy7v9vl_.arc' no longer needed for this recovery+
ORA-00283: recovery session canceled due to errors*
ORA-12805: parallel query server died unexpectedly*
ORA-01112: media recovery not started*
When I tried the same process again it will continue again and exit after sometime.
Can anyone give me some ideas why this recovery process not getting completed at one run.?
I normally issue "Recover database until cancel" after mounting the db and give "Auto" as the option.
thanks!
Pubudu