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.
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?