3 Replies Latest reply: Nov 26, 2012 1:58 PM by efierro RSS

    Cannot connect at Target Database using RMAN after Shutdown Abort

    user12028775
      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????