可以查看rman备份进度的脚本
SELECT start_time, end_time, elapsed_seconds,TRIM (time_taken_display) TIME, status, input_type,
compression_ratio, TRIM (input_bytes_display) inputb,
TRIM (output_bytes_display) outputb,
TRIM (input_bytes_per_sec_display) input,
TRIM (output_bytes_per_sec_display) output,
status
FROM v$rman_backup_job_details
WHERE start_time > TRUNC (SYSDATE) - 12
order by start_time desc ;
SELECT start_time, end_time, elapsed_seconds,TRIM (time_taken_display) TIME, status, input_type,
compression_ratio, TRIM (input_bytes_display) inputb,
TRIM (output_bytes_display) outputb,
TRIM (input_bytes_per_sec_display) input,
TRIM (output_bytes_per_sec_display) output,
status
FROM v$rman_backup_job_details
WHERE start_time > TRUNC (SYSDATE) - 12
order by start_time desc ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25462274/viewspace-2124951/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25462274/viewspace-2124951/