Warrior 技术大杂论

通过动态性能视图v$backup_set_details或v$backup_piece都可以查询RMAN每天的备份大小信息： 查询v$backup_set_details select to_char(start_time,'yyyy-mm-dd') start_time, to_char(start_time,'day') day, round(sum(OUTPUT_

查看已经完成和未完成的RMAN备份进度set line 9999 col opname for a35 col start_time for a19 SELECT SID, SERIAL#,opname, to_char(start_time,'yyyy-mm-dd HH24:MI:SS') start_time, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*1

Syntax formatSpec::= Description of the illustration formatspec.gif Semantics formatSpec The following table lists RMAN substitution variables that are valid in format strings.