Backup issue

In this issue Oracle 11gR2 backup was transferred to another server. Backup files was successfully restored and recovered, but database opened with errors: ORA-06553: PLS-801: internal error [56327]

Full text of error:

=============================================================
RMAN> alter database open resetlogs;

database opened
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-06553: PLS-801: internal error [56327]

RMAN>
=============================================================

Also alert.log was full with those errors:
====================================================
Wed Jan 27 13:06:27 2010
Errors in file /oracle/diag/rdbms/mydb/trace/mydb_cjq0_10153.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Errors in file /oracle/diag/rdbms/mydb/trace/mydb_cjq0_10153.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
====================================================

In this case the problem was that backup originally was done from Oracle 64bit, but restored to Oracle 32bit. To resolve this issue, simply switch your database to 32bit with help of Metalink NOTE [ID 62290.1] — Changing between 32-bit and 64-bit Word Sizes.

Good luck!

Advertisement