In this issue backup was transferred to another server.
Backup files was succesfully restored and recovered, but database opened with errors:
=============================================================
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 with Oracle 64bit, but restored with Oracle 32bit.
To resolve this issue, swith your database to 32bit with help of Metalink NOTE [ID 62290.1] --
Changing between 32-bit and 64-bit Word Sizes.
Good luck!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment