Database Software

Hi

We are having 11.2.0.2 database on Linux 5. From last two days the export backup is getting failed with the below error.

. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_CUBE_EXP.schema_i
. exporting statistics
Export terminated successfully with warnings.

When I checked the status of this package DBMS_CUBE_EXP its showing invalid. I tried to compile the body of the package. But it was throwing below error.

SQL> show errors
Errors for PACKAGE BODY DBMS_CUBE_EXP:

LINE/COL ERROR
-------- ----------------------------------------------------------------
53/5 PL/SQL: SQL Statement ignored
54/10 PL/SQL: ORA-04045: errors during recompilation/revalidation of
SYS.DBA_XDS_INSTANCE_SETS
ORA-01422: exact fetch returns more than requested number of rows

I tried to query this view or describe the above view. But it was throwing the same error.

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
SYS.DBA_XDS_INSTANCE_SETS
ORA-01422: exact fetch returns more than requested number of rows

I couldnt get a proper solution from google regarding this view or to compile the above package.

Now we are stcuked without the backups. It would be great if you guys look into it.

Thanks
SHIYAS M