RE: General reports on the RMAN catalog

From: Mercadante, Thomas F $LABOR$ <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 4 Dec 2006 11:51:08 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08909@EXCNYSM0A1AJ.nysemail.nyenet>

Michael,

I was also just looking at the v$backup_set view within the database itself. It looks like each backup is recorded here as well. This must be stored in the control file someplace.

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Monday, December 04, 2006 11:34 AM To: oracle-l_at_freelists.org
Subject: [Spam] 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]

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

Received on Mon Dec 04 2006 - 10:51:08 CST