online tablespace backup in progress and oracle instance is restarted...then what?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: online tablespace backup in progress and oracle instance is restarted...then what?

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    Hi,
    If oracle online database backup is in-progress and there's a instance restart due to switch-over of a fail-over cluster...do i need to perform a new round of online database backup again or can i use the "old" online backup copy and perhaps do something about it to bring it updated ??

    any input will be appreciated

    ngwh

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You will have to re-backup the tablespace which was being backed-up and all other tablespace that are yet to be backed-up. You can still use the backup of tablespaces that have been successfully completed before instance shutdown.

    HTH
    Sanjay

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if you cannot open database you would have to mount the database first and do

    alter database datafile 'xxx' end backup

    then alter database open

    and backup the affected tablespace/s again

  4. #4
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi pando,

    do u mean that if its like the scenario i mentioned..after the oracle instance restarted..database definitely wont be able to open is it ?? so u hv to end the online backup of the tablespace(that was interrupted) first correct???

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    yes but since you cannot do alter tablespace xxx end backup in mount state you have to do the way I posted

    the problem is if you try to start the database most probably Oracle will complain about file syncronization problems and to overcome that (unfreeze datafile header) we have to end datafile backup

  6. #6
    Join Date
    Sep 2002
    Posts
    20

    Smile

    Yes, pando thats the way to do it, but from experience you need to backup the whole database again to have a consistent backup and make it easy for you if you end up in a restore/recovery situation. You know how it tends to be when this situation occurs, managers hanging all over the place trying to speed the process up!
    Real experts gets the fact before stating that they are 100% shure!

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    well this only happened to me once and what I did is what i posted so if we have to talk about experience on this kind of situation mine is little however from theoretical view i dont see why I should backup whole database again if I was doing backup tablespace after tablespace. If it crashes I simply start backing up my last tablespace again since I have all the archived logs I dont see what can go wrong if I have to recover anything later?


  8. #8
    Join Date
    Sep 2002
    Posts
    20
    well if you do a backup per tablespace it's OK with your approach, but if you are running a full online consistent backup that backup is not valid any more!

    /Beppo
    Real experts gets the fact before stating that they are 100% shure!

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    ahh another missunderstanding

    I never do that kind of backups, generates too much archived logs!

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