Handling the archive log folder in the standbys
It is now in run-in test stage. I am very excited and happy, but I have a concern today over a scenario/situation that I hope some of you could share you thought.
In the primary, I’ve setup a daily RM backup, as usual, using the following two statements , to backup and reset the archivelog folder so that the archivelog folder won’t grow. When it is done, the backup files are copied out to secondary location to avoid being cleaned up when the next backup cycle kicks in to erase the prior backup.