SQL:
set linesize 400 col name for a65 select name,thread#,sequence#,to_char(first_time,'yyyy-mm-dd hh24:mi:ss') "First",to_char(next_time,'yyyy-mm-dd hh24:mi:ss') "Next",applied from v$archived_log,(select max(sequence#) "SEQ#" from v$archived_log where applied='YES') b where sequence# between b.seq#-5 and b.seq#+9 order by sequence#; set linesize 400; col client_pid for a20; select process,pid,client_pid,status,delay_mins,known_agents,active_agents from v$managed_standby; cat alert_xxx.log | grep "Fetching gap sequence" | tail -n 1 cat alert_xxx.log | grep "(in transit)" | tail -n 1 cat alert_xxx.log | grep "Media Recovery Waiting for" | tail -n 1 cat alert_xxx.log | grep "Media Recovery Log" | tail -n 1
————————
Done。