RE: find out the backup time in RMAN

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 11 Feb 2003 05:03:58 -0800
Message-ID: <F001.005491B3.20030211050358@fatcity.com>

Srinivas,

First look in the RC_DATABASE view to get the DB_KEY value for your database.
Then look at the RC_BACKUP_SET and RC_BACKUP_PIECE views within the Rman catalog. Sort by COMPLETION_TIME desc. You will see your backups listed there. The RC_BACKUP_SET is the parent record, while the RC_BACKUP_PIECE will contain the individual pieces that were backup up.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, February 11, 2003 5:49 AM To: Multiple recipients of list ORACLE-L

Hi DBA's

Can somebody give me sql query that can get me the last backup time of my database (cold backup thru RMAN) and its start_time, backup_endtime from rman catalog.

donot require LIST commands, as I have to produce a report of backuptime for several databases.

a single database is hosting catalogs for several databases using different users RMAN1, RMAN2,RMAN3 etc.

Thanks in advance,
Srinivas

---

Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: kommareddy sreenivasa
  INET: kommacnu_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 11 2003 - 07:03:58 CST