1) In real time apply, the redo data from primary is handed over to RFS processes at the standby by the LNS process at primary, and RFS process writes that redo data to the standby log file. From this standby log file, the redo data is applied to the standby database by the MRP process. Am i correct?
2) In Real-Time Apply, MRP process picks up data directly from the SRL and apply to the database and in non Real-Time apply, MRP picks up data from the archived logs and applies to the database. Are there any differences other than the above between normal MRP and RTA MRP(Real-Time)?
You are correct:
Real-Time Apply means just that Redo is been applied from the Standby Redo Logs directly without having to wait for them getting archived.
That was a new feature of 10g, by the way :-)
"Don't believe it, test it!"