released channel: disk4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "CATLG_30.DBMS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "CATLG_30.DBMS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "CATLG_30.DBMS_PKG"

SQL> select object_name,status,object_type from dba_objects where status !='VALID';
no rows selected

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 7 19:51:36 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 
SQL> select owner,object_name,object_type from dba_objects where object_name='DBMS_PKG' and object_type='PACKAGE';

no rows selected

SQL> select username from dba_users where username='CATLG_30';

no rows selected

  1* select owner,object_name,object_type from dba_objects where object_name='DBMS_RCVCAT'
SQL> /

no rows selected

SQL> select owner, count(*) from dba_objects where owner like 'C%' group by owner order by 1;

OWNER                            COUNT(*)
------------------------------ ----------
CACHEADM                               14
CTXSYS                                382

SQL> 

alter system set "_disable_fast_validate"=TRUE [scope=both]

SQL> select owner, count(*) from dba_objects where owner like 'C%' group by owner order by 1;

no rows selected

Server08:DB1:/opt/nokia/backup>rman catalog CATLG_30.DBMS_PKG@CATLG

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 8 10:38:30 2014

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

connected to recovery catalog database

RMAN> select * from rc_database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
RMAN-01008: the bad identifier was: select
RMAN-01007: at line 1 column 1 file: standard input

Server08:DB1:/opt/nokia/backup>rman catalog CATLG_30.DBMS_PKG@CATLG

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 8 10:38:30 2014

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

connected to recovery catalog database

Server08:DB1:/opt/nokia/backup>:SYNC1:/opt/nokia/backup>sqlplus cat11_26/****@CATLG

SQL*Plus: Release 11.2.0.3.0 Production on Sun Nov 9 05:06:20 2014

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, OLAP, Data Mining and Real Application Testing options


SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
CAT1

SQL> select OBJECT_NAME,CREATED,TIMESTAMP,STATUS,OBJECT_TYPE from user_objects where OBJECT_TYPE='PACKAGE' and  OBJECT_NAME='DBMS_RCVCAT';

OBJECT_NAME          CREATED            TIMESTAMP           STATUS  OBJECT_TYPE
-------------------- ------------------ ------------------- ------- -------------------
DBMS_RCVCAT          26-JUN-12          2014-11-07:21:25:51 VALID   PACKAGE

SQL> select object_name,object_type,to_char(created,'DD-MM-YY HH24:MI:SS')created,to_char(last_ddl_time,'DD-MM-YY HH24:MI:SS')last_ddl from user_objects where object_name='DBMS_RCVCAT';

OBJECT_NAME          OBJECT_TYPE         CREATED           LAST_DDL
-------------------- ------------------- ----------------- -----------------
DBMS_RCVCAT          PACKAGE             26-06-12 10:54:05 07-11-14 21:26:04
DBMS_RCVCAT          PACKAGE BODY        26-06-12 10:54:06 07-11-14 21:25:52

SQL> SELECT username,
       owner,
       obj_name,
       action_name
FROM   user_audit_trail
where OBJ_NAME like'DBMS_RCVCAT'
ORDER BY timestamp;  

no rows selected