My Oracle Support Banner

Upgrade : Pre-Upgrade Error - Error in FIND_RECOVERY_AREA step 3a ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_PREUP" (Doc ID 2602742.1)

Last updated on OCTOBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Upgrading to 18c failed with the below Error-

SEVERE: ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:
INTERNAL ERROR: An internal preupgrade error occurred that prevents further execution. This is unexpected and usually caused by some sort of internal inconsistency. You may want to contact Oracle Support. The internal error message is:
Error in FIND_RECOVERY_AREA step 3a
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 291
ORA-06512: at "SYS.DBMS_PREUP", line 9340
ORA-06512: at "SYS.DBMS_PREUP", line 4091
ORA-06512: at "SYS.DBMS_PREUP", line 9741
ORA-06512: at line 8

declare
*
ERROR at line 1:
ORA-20000: Error in FIND_RECOVERY_AREA step 3a
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 291
ORA-06512: at "SYS.DBMS_PREUP", line 9340
ORA-01403: no data found
ORA-06512: at line 56

DBUA Screenshot -

 

 

 

Changes

 This is a SIHA DB in an Oracle Restart Environment.
 FRA was setup as per alert.log,as below-

Sat Oct 19 09:33:16 2019
ALTER SYSTEM SET db_recovery_file_dest_size='50000' SCOPE=BOTH;
Sat Oct 19 09:34:00 2019
ALTER SYSTEM SET db_recovery_file_dest=' +XXX_FRA' SCOPE=BOTH;
Sat Oct 19 09:34:00 2019

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
Changes
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.