RE: General reports on the RMAN catalog

select * FROM rman.RC_DATABASE_INCARNATION ;  

SELECT i.name, BACKUP_TYPE, max(COMPLETION_TIME) completion_time

    FROM rman.RC_DATABASE_INCARNATION i, rman.RC_BACKUP_SET b     WHERE i.DB_KEY = b.DB_KEY
      AND i.CURRENT_INCARNATION = 'YES'
    group by name, backup_type

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Monday, December 04, 2006 10:34 AM To: oracle-l_at_freelists.org
Subject: General reports on the RMAN catalog

Having a catalog for many databases, is there any general reports out there to tell me who all is using the catalog?

Is it possible to get some generic reports like "Which databases have been backed up this week?"

Everything normally goes from MY database and it's status. What if I want to know if there is any "undocumented" backups taking place of a database not known to be registered in this catalog?

Thanks. Of course, perhaps that's what they have put into Grid Control?

Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446

Cell: 804.744.1545
michael.kline_at_suntrust.com <mailto:michael.kline_at_suntrust.com>

Seeing beyond Money(sm)    

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.  

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]
CONFIDENTIALITY NOTICE:
        This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l