常用sql

[oracle@db01 dg]$ cat dg.sql
select thread# ,low_sequence#,high_sequence# from v$archive_gap;
select unique thread# as thread,max(sequence#) over(partition by thread#) as last from gv$archived_log;
select unique thread# as thread,max(sequence#) over(partition by thread#) as last from gv$archived_log where applied='YES';
SET LINESIZE 500;
col value format a20;
select * from v$dataguard_stats;
select sequence#,to_char(FIRST_TIME,'yyyy-MM-dd HH24:mi:ss'),to_char(NEXT_TIME,'yyyy-MM-dd HH24:mi:ss'),applied from v$archived_log
where sequence# in (select max(sequence#) from gv$archived_log);

测试输出结果

[oracle@db01 dg]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 11 11:30:35 2022

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @dg

no rows selected


    THREAD       LAST
---------- ----------
         1      31026
         2      32405


    THREAD       LAST
---------- ----------
         1      31026
         2      32403


SOURCE_DBID SOURCE_DB_UNIQUE_NAME            NAME                             VALUE                UNIT                           TIME_COMPUTED                  DATUM_TIME                         CON_ID
----------- -------------------------------- -------------------------------- -------------------- ------------------------------ ------------------------------ ------------------------------ ----------
 1967978881                                  transport lag                    +00 00:09:59         day(2) to second(0) interval   03/11/2022 11:30:36            03/11/2022 11:30:25                     0
 1967978881                                  apply lag                        +00 00:09:59         day(2) to second(0) interval   03/11/2022 11:30:36            03/11/2022 11:30:25                     0
 1967978881                                  apply finish time                                     day(2) to second(3) interval   03/11/2022 11:30:36                                                    0
          0                                  estimated startup time           21                   second                         03/11/2022 11:30:36                                                    0


 SEQUENCE# TO_CHAR(FIRST_TIME, TO_CHAR(NEXT_TIME,' APPLIED
---------- ------------------- ------------------- ---------
     32405 2022-03-11 11:19:37 2022-03-11 11:27:24 NO

#进程状态

SQL> select process,status,sequence#,THREAD#,BLOCK# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#    THREAD#     BLOCK#
--------- ------------ ---------- ---------- ----------
ARCH      CONNECTED             0          0          0
DGRD      ALLOCATED             0          0          0
DGRD      ALLOCATED             0          0          0
ARCH      CONNECTED             0          0          0
ARCH      CONNECTED             0          0          0
ARCH      CONNECTED             0          0          0
RFS       IDLE              32406          2      25780
RFS       IDLE                  0          0          0
RFS       IDLE                  0          0          0
RFS       IDLE              31027          1      44786
RFS       IDLE                  0          0          0

PROCESS   STATUS        SEQUENCE#    THREAD#     BLOCK#
--------- ------------ ---------- ---------- ----------
RFS       IDLE                  0          0          0
MRP0      WAIT_FOR_LOG      31027          1          0

13 rows selected.