conver DR into realtime apply

Run in standby database side:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

set lines 200

col MEMBER for a40

set pages 100

select TYPE,MEMBER from v$logfile;

##if there is no standby redologs create by  using follown sample command:

alter database add standby logfile ('/u02/oradata/FSDR/standby_redo4a.log','/u10/oradata/FSDR/standby_redo4b.log') size 300M;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect from session;

Checking status:

set lines 200

select instance_name,host_name from gv$instance;

select process, client_process, sequence#, status from gv$managed_standby;

col DEST_NAME for a10

col DEST_NAME for a20

select DEST_ID,dest_name,status,type,srl,recovery_mode from v$archive_dest_status where dest_id=1;

col name for a13

col value for a13

col unit for a30

set lines 132

select name, value, unit, time_computed from gv$dataguard_stats where name in ('transport lag', 'apply lag');