-
online backup
All,
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?
Thanks
GT
-
Originally Posted by pranavgovind
All,
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?
Thanks
GT
Login to the catalog database as RMAN user and check the details (from the horse mouth) would be the ultimatum:
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.
-
Originally Posted by JMacBrain
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|