SQL apply的疑问？

Yong Huang

First, let's make sure this is about logical standby, not physical standby, where no SQL is executed.

I don't have direct experience with logical standby. But I think zhangweizhao answered the question correctly. You configure two separate directories, one for the standby itself, the other to receive the archive logs from the primary.