We are in the middle of a first production physical standby. I have configured and played with Logical Standby in 9iR2 and 10g. Logical standby first became avail. in 9iR2. With both logical and physical standby the interesting part is how much you want to way down your production server with this. The pivotal point is the log archive transmission through the listener. I would highly recommend using the fal_server/fal_client parameters to make minimize gaps in archive logs. There is a new feature in 10g which minimizes the impact to your production server called Downstream capture. In this case archivelogs still get sent through the listener but analisys and application of the logs all happens outside the production db.
REGISTER or login: