This content has been marked as final. Show 4 replies
Run this from the Primary side :
I thought you had a Data Guard question. rsync is NOT part of Data Guard.
Edited by: mseberg on Oct 3, 2012 3:08 PM
As i have already mentioned the archives are manually shipped using rsync command.There is no a remote location defined on primary.We simply pull the archives from primary and put it into a location on remote. Later recovery script is run which will recover using these archives.
So your query does not provide enough data.
Even though i do a manual recovery on standby, those details on sequence should be there in the standby controlfile. Am i right.But if you check my previous note, count from v$archved_log shows zero.
This is were am stuck.
The view v$archived_log and v$log_history views are same they give you output from the controlfile. The difference is that v$archived_log will give give you output only if you are in automatic recover mode. This view is useful only if the registrar column in v$archived_log is RFS. Which you will get if your standby is in automatic recovery mode.
In your case you are doing manual recover so that is why it is not giving you any output.
you can compare the SCN's , they can be converted to timestamps and then used to check how far is your standby lagging behind.