Hi Friends,
My question is regarding alter sysem switch log file.
Assuming that I will put my 5 tablespaces in backup mode.
Then I do an OS copy of the datafiles to second location.
I take out the tablespaces out of Backup mode.

To generate the archived log files i connect internal and the do alter system switch log file.

If I have 5 datafiles, do i have to do alter system switch log file 5 times ?

Does it depend on the # of datafiles or i can just do it a couple of times ?How many times have to repeat that?

Thanks in advance