DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: online backup

  1. #1
    Join Date
    Dec 2005
    Posts
    195

    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

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote 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"

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    but only by restoring will you know the backups are ok

  4. #4
    Join Date
    Dec 2005
    Posts
    195
    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..

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    but you still wont know they are ok unless you restore them somewhere

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    try restore... validate command

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  8. #8
    Join Date
    Dec 2005
    Location
    Brisbane Australia
    Posts
    2

    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.

  9. #9
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote 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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width