RMAN>alterdatabaseopenresetlogs;


databaseopened

RMAN-06900:WARNING:unabletogenerateV$RMAN_STATUSorV$RMAN_OUTPUTrow

RMAN-06901:WARNING:disablingupdateoftheV$RMAN_STATUSandV$RMAN_OUTPUTrows

ORACLEerrorfromtargetdatabase:

ORA-06553:PLS-801:internalerror[56319]

具体的告警日志如下。

Completed:alterdatabaseopenresetlogs

SunMay2822:34:472017

Errorsinfile/home/oracle/oracle/admin/SCM2/bdump/scm2_mmon_20272.trc:

ORA-06553:PLS-801:internalerror[56319]

SunMay2822:34:472017

Errorsinfile/home/oracle/oracle/admin/SCM2/bdump/scm2_mmon_20272.trc:

ORA-06553:PLS-801:internalerror[56319]

SunMay2822:34:472017

StartingbackgroundprocessCJQ0

CJQ0startedwithpid=19,OSid=21562

SunMay2822:34:502017

Errorsinfile/home/oracle/oracle/admin/SCM2/bdump/scm2_j000_21565.trc:

ORA-12012:erroronautoexecuteofjob42567

ORA-06553:PLS-ORA-06553:PLS-801:internalerror[56319]

:

SunMay2822:34:502017

Errorsinfile/home/oracle/oracle/admin/SCM2/bdump/scm2_j001_21567.trc:

ORA-12012:erroronautoexecuteofjob42568

ORA-06553:PLS-ORA-06553:PLS-801:internalerror[56319]

:

SunMay2822:34:502017

Errorsinfile/home/oracle/oracle/admin/SCM2/bdump/scm2_j002_21569.trc:

ORA-12012:erroronautoexecuteofjob5329

ORA-06544:PL/SQL:internalerror,arguments:[ORA-06544:PL/SQL:internalerror,arguments:[56319],[],[],[],[],[],[],[]

ORA-06553:PLS-801:internalerror[56319]

],[],[],[],[],[],[],[]

这个是由于Oracle的软件版本和之前restore进去的数据库版本不一致导致。如下即可修复，具体可以参考RMAN还原32位数据库到64位实例的错误处理

SQL>startupupgrade;


SQL>@?/rdbms/admin/utlip.sql


SQL>shutdownimmediate;


SQL>startup


@?/rdbms/admin/utlrp.sql本文属于转载文章