This content has been marked as final. Show 4 replies
So how about you tell us that what you didn't get about the query scn first?
It's the highest SCN to which data is synchronised between the primary and secondary in a way that the secondary guaranteed read-consistent. It's therefore not possible to query an active standby for data modified after that SCN. At any given time, there might be transactions committed on the primary but not yet shipped or applied to the standby. You're not allowed to see those on the secondary. Not sure how much more detailed you want to get, really.1 person found this helpful
Edited by: Catfive Lander on Jan 15, 2013 4:15 AM
918868 wrote:What exactly you don't understand in "query scn"
What are the details concepts behind the’ query scn’ in Dataguard in Oracle 11g. I read the concept from Oracle Datagaurd 11g Handbook but it was not clear for me.
Thanks Lander & everyone , my doubt is now clear, highly appreciates your help.
Edited by: 918868 on Jan 15, 2013 2:35 AM