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');
