| From: | Steve Adams |
| Date: | 08-Nov-2000 04:02 |
| Subject: | Log switches between tablespace backups? |
|
|
Log switches before and after the backups I can understand, but I cannot think of any good reason for a log switch between each pair of tablespaces. Can anyone else on the Ixora Answers list think of a reason?
|
![]() |
I'm trying to figure out how to set the best configuration in my online backup scripts. In order to do that, I've read a lot of books and one of them says that it's a good practice to perform a log switch between each alter tablespace XXX BEGIN BACKUP alter tablespace XXX END BACKUP LOG SWITCH alter tablespace XXX BEGIN BACKUP alter tablespace XXX END BACKUP ...So, my question is: Is it true? Could you explain why? (I couldn't find any reason to folow that procedure.)
|