Dear All,
My Oracle Database is 10gR2 on Windows 2003 Server, I have a Logical standby for my production database.
I just want to know how to find out how much transaction and time lag there will be if the production database is crashed and current archive is not shipped on the logical standby.
How to document this thing, we can't say that this is a real time replication since there is no data guard setup. Its just log shipping and applying.
My redo log file sizes are 10MB each. In peak time log switch may happen twice in a minute on certain occasion but mostly it is from 8 to 1 minutes.
Is there any configuration without using a data guard you can have zero percent of data loss in logical standby setup?
But still the important thing is to determine the loss if primary goes down and standby role needs to be change as primary manually.
Regards, Imran