This discussion is archived
3 Replies Latest reply: Nov 26, 2012 11:58 AM by efierro RSS

Cannot connect at Target Database using RMAN after Shutdown Abort

user12028775 Newbie
Currently Being Moderated
OS: AIX 6.1
DB (EE) : 11.2.0.3

Hi,
Server crashed while backup (RMAN) was running, I was able to start and OPEN database without problem.

When I tried connect using RMAN I got msg error below:
oracle@p1h3db1orcl:/home/oracle> rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Nov 22 18:24:07 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ORACLE error from target database:
ORA-06550: line 1, column 41:
PLS-00201: identifier 'DBMS_RCVMAN.GETPACKAGEVERSION' must be declared
ORA-06550: line 1, column 34:
PL/SQL: Statement ignored

error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN


oracle@p1h3db1orcl:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 22 18:21:46 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Data Mining, Oracle Database Vault and Real Application Testing options

SQL> select SESSION_KEY,SESSION_RECID,START_TIME,END_TIME,STATUS from V$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-1;
select SESSION_KEY,SESSION_RECID,START_TIME,END_TIME,STATUS from V$RMAN_BACKUP_JOB_DETAILS where START_TIME > sysdate-1
                                                                 *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-00904: "SYS"."DBMS_RCVMAN"."NUM2DISPLAYSIZE": invalid identifier
Any suggestion????

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points