RE: General reports on the RMAN catalog
- From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Dec 2006 10:44:56 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kline.Michael
Sent: Monday, December 04, 2006 10:34 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx <mailto:michael.kline@xxxxxxxxxxxx>
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.
Other related posts:
