- 查看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