A physical standby database could always be opened in “read only” mode. The problem was that it didn’t apply any archived logs at that time. It could only apply logs when mounted.
Then came Oracle 11g with the “active standby database” feature (sometimes referenced as real-time query).
With this feature we can open the database in “read only” mode, and can still apply archive logs from the primary.
Let’s see how it works…