Hot answers tagged dataguard
I simply do not believe. It's impossible. There is process called FAL (Fetch Archive Log), it can happen that redo-logs are not TRANSFERRED in chronological order, but anyway they must be APPLIED in chronological order. Also logical standby has can have some gotchas but those are not related to network link. (For example for some reason LOCK TABLE statement ...
There aren't any special considerations that need to be taken into account when setting up a RAC->No RAC Primary->Standby configuration. In fact, there's a White Paper written by Oracle which explains the setup. The Oracle documentation is here.
Try adding (SERVICE=Dedicated) to your TNS entry on the client computer that you are using and then run your query again. There could be other causes but this is the most common: you are trying to access data using a shared connection when a dedicated connection is required. Edit: Are there any other log or trace file entries when this error happens?
Only top voted, non community-wiki answers of a minimum length are eligible