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
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