Want to know for certain if your dataguard standby is in REAL TIME APPLY mode?
Here is how – execute the following query from the primary side:
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:
If you are currently recovering then cancel that:
alter database recover managed standby database cancel;
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