My Oracle Support Banner

ORA-19901 DURING DATABASE RECOVERY (Doc ID 418400.1)

Last updated on DECEMBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.4 to 10.2.0.4 [Release 9.0.1 to 10.2]
Information in this document applies to any platform.

Symptoms

Experienced the ORA-19901 error during the database recovery.

SQL> recover database parallel 4 using backup controlfile until cancel;
ORA-00279: change 8216742426206 generated at 01/22/2007 20:39:10 needed for thread 1
ORA-00289: suggestion : /<PATH>/archive_logs/<PATH>/<FILE_NAME>.log
ORA-00280: change 8216742426206 for thread 1 is in sequence #68075

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-19901: database needs more recovery to create new incarnation

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.