SQL Script to show the Last Backup Taken and Time it took to backup and Siz
507076Jun 18 2010 — edited Jun 18 2010I want to get a SQL that tells me the details of a backup on the database from RMAN Repository.
select DB_NAME,to_char(newest_backup_time,'DD-MON-YYYY hh24:mi:ss'),output_bytes_display from RC_BACKUP_SET_SUMMARY
This is the simple one but want the details like
Database Name
Last Backup Start Time
End Time
Size
Status
Let me know from where i can get it in RMAN Repository in SQL Format.