4 Replies Latest reply on Oct 9, 2012 10:49 AM by 957761

    Registering primary database to catalog database.

      Hi all,

      Here we have a dataguard environment with db1(db_unique_name) as primary and db2(db_unique_name) as physical standby database. Also we configured one schema on a third machine as catalog database using following steps.

      The steps executed in catalog database(appsdb):

      SQL> create tablespace rmancatlog_tbs datafile '/u01/app/oracle/oradata/NEW/rman_catalog.dbf' size 500M autoextend off extent management local segment space management auto;

      SQL> create user rman identified by oracle
      2 default tablespace rmancatlog_tbs
      3 quota unlimited on rmancatlog_tbs
      4 ;

      SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

      RMAN> create catalog;
      recovery catalog created

      Added tns entries of catalog database in primary and standby. Then from primary database we tried to register to catalog database. It is showing that it is registering. But every query afterwards in rman is throwing the error. Below are the steps and error:

      [oracle@db1 ~]$ rman target sys/oracle catalog rman/oracle@appsdb
      Recovery Manager: Release - Production on Mon Aug 13 21:39:32 2012
      Copyright (c) 1982, 2005, Oracle. All rights reserved.
      connected to target database: NIOS (DBID=1589015669)
      connected to recovery catalog database

      RMAN> register database;
      database registered in recovery catalog

      RMAN> report schema;
      Report of database schema
      List of Permanent Datafiles
      File Size(MB) Tablespace RB segs Datafile Name
      ---- -------- -------------------- ------- ------------------------
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of report command at 10/08/2012 06:16:06
      RMAN-00600: internal error, arguments [8201] [] [] [] []

      Can anyone help regarding this error?