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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).