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,网不通。所以今天上班这样子了