I have a standby machine. I am asked to make sure that, in case of failure, The standby is not older than 15 minutes. As per the transactions, the new archive is getting created every 15 to 60 minutes. And as soon as the new Archive is created, then it is getting transferred to Standby machine. What if log swicth does not occur for say 40 minutes. And at 20th minute the system failed. And I cannot make sure that the data is just older of 15minutes in Standby.
My question is, is there any way I can make sure that, the STANDBY is just not older than 15 minutes.
That's what I am doing. My batch wakes up every fifteen minutes and if any new Archive logfile occurs, it transfers it to Standby. My question is not that.
What if there is not Logwitch for 60 minutes. Then Production failes, and the data in Online redo logs are not transferred for the past 60 minutes, and I will loose the data. How to make sure that, I will not loose data not older than 15 minutes
Even I am eager to know that. I was above to suggest the same 'switching log file for evry 15 min'. But, didn't feel its the best way of doing it... so, I didn't post it and waiting for someone to come up with best way of doin it..