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

Thread: HOT backup

  1. #1
    Join Date
    Apr 2001
    Posts
    2

    Question

    Hi,

    I have a script that performs "begin backup" and "end backup" for each tablespace. After all the tbs has been backed up, I perform a "alter system switch logfile" once at the end to synchronize all the header files.

    Lately, my reading indciates that I should be performing a switch on the logfile after each "end backup". Is this correct?

    Please let me know, so that I can modify my HOT backup scripts.

    many thanks

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I don't see any particular reason to switch logfile after each tablespace when taking full hot backup. One logswitch at the end should be sufficient.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2001
    Posts
    2
    Thank you for your response, i needed some reassurance.

    i am not sure what the book was driving at;
    is it possible that, if the database fails during the time of my "begin backup" of one of the tablespace, the headerfiles will not be in synch???


  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, in this case your file headers will not be in sinc, but I still can't see any particular reason how switched log file would help you in this scenario. You would still need to restore some or all files from your previous backup and last needed redo information will still be still stored in your online log file instad of in switched and archived logfile.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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