Oracle DB 运行状态检查

• 查看DB运行状态

select instance_name, host_name, startup_time, status, database_status from gv$instance;

• 查询DB运行的进程

select * from gv$bgprocess where paddr <> '00' and inst_id=1;
select * from gv$bgprocess where paddr <> '00' and inst_id=2;
select * from gv$bgprocess where paddr <> '00';

• 备份DB备份信息

select t.START_TIME,
       t.END_TIME,
       t.OUTPUT_DEVICE_TYPE,
       t.INPUT_TYPE,
       t.INPUT_BYTES_DISPLAY,
       LTrim(t.OUTPUT_BYTES_DISPLAY),
       t.TIME_TAKEN_DISPLAY,
       t.STATUS
  from v$rman_backup_j