IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    DG:GAP SQL

    Adamhuan发表于 2017-04-18 03:38:46
    love 0

    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。



沪ICP备19023445号-2号
友情链接