I am using oracle9i. Our DBA's are taking online backup with RMAN.
I wanted to ensure that, the backup is running fine every day. I wanted to do this from oracle dictionary(v$ views). How can i do this?
Login to the catalog database as RMAN user and check the details (from the horse mouth) would be the ultimatum:
Originally Posted by pranavgovind
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST BACKUP BY FILE;
If you need the way u want, then,
V$ backup,backup_datafile,backup_sync_io would give you all the details.
"What is past is PROLOGUE"
but only by restoring will you know the backups are ok
Thank you very much for your help. My goal is, my corporate DBA are taking RMAN backup. We wanted to assure that, the backups are completed successfully. I believe v$backup_sync_io file will give the details. Once again, thanks..
but you still wont know they are ok unless you restore them somewhere
try restore... validate command
Think of it like this: Your job is only as good as your backups.
Make sure they work so you can too.
Regular recovery to different hardware is good practice and good economics too.
Restore often, sleep well.
You should do a test restore once a month to test your media, and get an idea of how long it takes to bring a database back from the dead.
Good idea If you've got the time and resources.
Originally Posted by JMacBrain
Click Here to Expand Forum to Full Width