返回数说广场
0
一键查询 RMAN 备份情况:set linesize 2222 pagesize 1000headingon wrap on
colstatusfor a30
col input_type for a20
col start_time for a25
col end_time for a25
col input_bytes_display for a10
col output_bytes_display for a10
col time_taken_display for a10
SELECT input_type, status,
to_char(start_time, 'yyyy-mm-dd hh24:mi:ss') as start_time,
to_char(end_time, 'yyyy-mm-dd hh24:mi:ss') as end_time,
input_bytes_display, output_bytes_display, time_taken_display, compression_ratio
FROM v$rman_backup_job_details
ORDERBY start_time DESC;
0
0 222
分享
评论
热门数说


