Want to know for certain if your dataguard standby is in REAL TIME APPLY mode?
Here is how:
select DEST_ID,dest_name,status,type,srl,recovery_mode from v$archive_dest_status
where status <>’INACTIVE’;
To turn on real time apply do this:
From a shutdown position:
— optionally if you want to use read only Active Data Guard issue this open read only
alter database open read only;
alter database recover managed standby database using current logfile disconnect from session;
The keyword that turns on real time apply is “using current logfile” – this valuable feature is available from 10g forward.
Hope this helps, Mike