Find Registered Database From Recovery Catalog Schemas

C:\Users\rajib.pradhan>SQLPLUS /NOLOG

SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 21 12:49:24 2014

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

SQL> CONN RMAN/RMAN@DBRMAN

Connected.

SQL> select * from rc_database;

    DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS

---------- ---------- ---------- -------- ----------------- ---------

       221        222 1350456456 ORCL             390117985 17-JUL-14

         2          4 3796675194 DBRMAN              940976 16-JUN-14

SQL>