Program error

[RU]

Источник ошибки: Ядро мониторинга работы СУБД Oracle

Текст сообщения: Monitoring (Oracle RMAN backup info)

Информация

• Получение данных о последнем (удачно завершенном, работающем) резервном копировании используя RMAN (статус операции, дата и тип резервного копирования)

Запрос

select * from (
select max(session_stamp),
       status,
       round((sysdate - start_time)*24*60) "DTRMIN",
       to_char(start_time,'dd.mm.yyyy hh24:mi') "DTR", nvl(input_type,'no') "Type"
  from v$rman_backup_job_details
 where (status='COMPLETED' or status ='RUNNING' or status ='COMPLETED WITH WARNINGS')
group by status,input_type,session_stamp,start_time,status
order by session_stamp desc )
where rownum=1 

Решение

Предоставить пользователю права на чтение данных системного каталога, например

grant select any dictionary to <UserName>; 
или       
grant select on v$rman_backup_job_details to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle RMAN backup info)

Information

• Getting data about the last (successfully completed, working) backup using RMAN (operation status, date and type of backup)

Query

select * from (
select max(session_stamp),
       status,
       round((sysdate - start_time)*24*60) "DTRMIN",
       to_char(start_time,'dd.mm.yyyy hh24:mi') "DTR", nvl(input_type,'no') "Type"
  from v$rman_backup_job_details
 where (status='COMPLETED' or status ='RUNNING' or status ='COMPLETED WITH WARNINGS')
group by status,input_type,session_stamp,start_time,status
order by session_stamp desc )
where rownum=1 

Solution

Grant the user rights to read system directory data, for example

grant select any dictionary to <UserName>; 
or     
grant select on v$rman_backup_job_details to <UserName>;