[EN]
The window allows you to view detailed backup information using the RMAN utility
Window structure
Field "For the last" - display records for N days
List "List backup" - a list of backup operations with the status of the operation
SELECT end_time,
input_type||' ('||
case when status = 'RUNNING WITH WARNINGS' then 'RWW'
when status = 'RUNNING WITH ERRORS' then 'RWE'
when status = 'COMPLETED' then 'C'
when status = 'COMPLETED WITH WARNINGS' then 'CWW'
when status = 'COMPLETED WITH ERRORS' then 'CWE'
when status = 'FAILED' then 'F'
else status
end||')' "Type",
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM (SELECT end_time,
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM v$rman_backup_job_details
WHERE start_time> sysdate - 10
ORDER BY start_time DESC)
Block "Information" - detailed information about the selected record. The data is displayed by the same query as the information for the "List backup" list
"Details" tab
The tab displays detailed information about the backup of database files, file sizes and start time of the processing operation
select a.STATUS,
to_char(open_time,'dd.mm.yyyy hh24:mi') timebegin,
round(BYTES/1024/1024,2)|| ' Mb' mbbegin,
a.type,
filename
from v$backup_async_io a
where not a.STATUS in ('UNKNOWN')
and open_time >= to_date(<Time_start>,'dd.mm.yyyy hh24:mi:ss')
and close_time <= to_date(<Time_end>,'dd.mm.yyyy hh24:mi:ss')+10/86400
order by open_time
"Log" tab
Detailed log of the session execution of the RMAN utility
select output from V$RMAN_OUTPUT where session_stamp = $$session_stamp
"Configuration" tab
View and change backup settings using the RMAN utility
select CONF#, name, value from V$RMAN_CONFIGURATION order by name
[RU]
Окно позволяет просматривать подробную информацию о резервном копировании используя утилиту RMAN
Структура окна
Поле "For the last" - вывести записи за N дней
Список "List backup" - список операций резервного копирования со статусом выполнения операции
SELECT end_time,
input_type||' ('||
case when status = 'RUNNING WITH WARNINGS' then 'RWW'
when status = 'RUNNING WITH ERRORS' then 'RWE'
when status = 'COMPLETED' then 'C'
when status = 'COMPLETED WITH WARNINGS' then 'CWW'
when status = 'COMPLETED WITH ERRORS' then 'CWE'
when status = 'FAILED' then 'F'
else status
end||')' "Type",
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM (SELECT end_time,
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM v$rman_backup_job_details
WHERE start_time> sysdate - 10
ORDER BY start_time DESC)
Блок "Information" - подробная информация о выделенной записи. Данные выводятся тем же запросом, что и информация для списка "List backup"
Вкладка "Details"
Вкладка выводит подробную информацию о резервном копировании файлов БД, размеры файлов и время старта выполнения операции обработки
select a.STATUS,
to_char(open_time,'dd.mm.yyyy hh24:mi') timebegin,
round(BYTES/1024/1024,2)|| ' Mb' mbbegin,
a.type,
filename
from v$backup_async_io a
where not a.STATUS in ('UNKNOWN')
and open_time >= to_date(<Time_start>,'dd.mm.yyyy hh24:mi:ss')
and close_time <= to_date(<Time_end>,'dd.mm.yyyy hh24:mi:ss')+10/86400
order by open_time
Вкладка "Log"
Подробный лог выполнения сессии утилиты RMAN
select output from V$RMAN_OUTPUT where session_stamp = $$session_stamp
Вкладка "Configuration"
Просмотр и изменение настроек резервного копирования с помощью утилиты RMAN
select CONF#, name, value from V$RMAN_CONFIGURATION order by name