Data Guard查看和检查

select NAME,DB_UNIQUE_NAME,INSTANCE_NAME,HOST_NAME,OPEN_MODE,LOG_MODE,DATABASE_STATUS,

DATABASE_ROLE,SWITCHOVER_STATUS,PROTECTION_MODE,PROTECTION_LEVEL,CONTROLFILE_TYPE,STATUS,

LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,gv$instance;

select status,instance_name,database_role,open_mode,protection_mode,switchover_status

from gv$instance,gv$database;

switchover_status：是否允许切换

TO STANDBY - 数据库已准备好切换到物理或逻辑备用角色。

TO PRIMARY - 数据库已准备好切换到主要角色

 

V$ARCHIVE_DEST 对于当前实例，显示 Data Guard 配置中的所有目标，包括每个目标的当前值、模式和状态。

DESTINATION：指定归档重做日志的归档位置

STATUS：VALID - 已初始化并可用

DEST_ID：日志归档目标参数标识符 ( 1to 31

select destination,status,error,DEST_ID,DEST_NAME from v$archive_dest; 

检查传输状态（主）

V$ARCHIVE_PROCESSES 显示实例的各种 ARCH 进程的状态

select * from v$archive_processes where status <> 'STOPPED';

V$ARCHIVE_DEST 对于当前实例，显示 Data Guard 配置中的所有目标，包括每个目标的当前值、模式和状态。

STATUS：VALID - 已初始化并可用         INACTIVE - 没有目的地信息                      DEFERRED - 由用户手动禁用

ERROR - 打开或复制时出错                       DISABLED - 错误后禁用                                                BAD PARAM - 参数有错误

ALTERNATE - 目的地可作为替代             FULL - 超出目的地的配额大小

ERROR：显示错误文本

select status,error from v$archive_dest where status <>'INACTIVE';

V$MANAGED_STANDBY显示与 Data Guard 环境中的物理备用数据库相关的某些 Oracle 数据库进程的当前状态信息。此视图在实例关闭后不会保留。

PROCESS：ARCH - 归档进程      LNS - 异步重做传输过程             MRP0 - 分离的恢复服务器进程

STATUS：CONNECTED - 建立到主数据库的网络连接   ALLOCATED - 进程处于活动状态但当前未连接到主数据库

WRITING - 进程正在积极地将重做数据写入归档重做日志

SEQUENCE#：归档重做日志序列号

BLOCK#：最后处理的归档重做日志块号

select process,status,client_process,sequence#,block# from v$managed_standby;

SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS,THREAD#, DELAY_MINS

FROM GV$MANAGED_STANDBY;

应用或接收的最后一个日志

select 'Last applied  : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time

    from v$archived_log

    where sequence# = (select max(sequence#) from v$archived_log where applied='YES')

    union

    select 'Last received : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time

    from v$archived_log

   where sequence# = (select max(sequence#) from v$archived_log);

select al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied"
from (select thread# thrd, max(sequence#) almax
from v$archived_log
where resetlogs_change#=(select resetlogs_change# from v$database)
group by thread#) al,
(select thread# thrd, max(sequence#) lhmax
from v$log_history
where first_time=(select max(first_time) from v$log_history)
group by thread#) lh
where al.thrd = lh.thrd;

 

 

select thread#,max(sequence#) from v$archived_log where archived='YES' group by thread# order by 1; 

ARCHIVED:指示联机重做日志是否已存档 ( YES),或 RMAN 是否仅检查日志并创建记录以备将来恢复期间重做日志的应用 ( NO)。

 

select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread# order by 1;

APPLIED:如果REGISTRAR=RFS和APPLIED= YES，则日志文件已被应用并且数据文件已被更新。

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied",
(ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG
WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME)
FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

 

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied",
(ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG
WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME)
FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

 没有固定IP，网不通。所以今天上班这样子了