, OUTPUT_BYTES_PER_SEC_DISPLAY IO_OUT_RATE , OUTPUT_DEVICE_TYPEFROMV$RMAN_BACKUP_JOB_DETAILSWHERESTART_TIME>SYSDATE-14ORDERBYSTART_TIMEASC; 那么如果你发现备份的状态为COMPLETED WITH WARNINGS,怎么找出RMAN备份的具体告警信息呢?一个方法是从RMAN备份 的日志中可以搜索到具体的告警信息,还有一种方式,如下...
1. 现象 今天要写程序自动检查数据库RMAN备份的状态,查询V_$RMAN_BACKUP_JOB_DETAILS 视图时状态栏位显示的是COMPLETED WITH WARNINGS 2. 原因查找 2.1 V$RMAN_OUTPUT 这里首先查询V$RMAN_OUTPUT视图,这个视图显示的为最近的RMAN备份输出 这里查询output栏位是否有warning 代码语言:javascript 代码运行次数:0 复制 Clo...
在V$RMAN_STATUS中,最主要的列是OPERATION和status。 Operation的值有rman、backup、list、report。 Status的值有running、running with warnings、running with errors、completed、completed with warnings、completed with errors、failed等几种状态。 如果要查看RMAN的输出,可以查看V$RMAN_OUTPUT。V$RMAN_OUTPUT 视图记录了...
查看备份成功的历史记录SELECT * FROM V$RMAN_STATUSWHERE START_TIME >= TO_DATE(&START_TIME,'YYYY-MM-DD HH24:MI:SS')AND END_TIME <= TO_DATE(&END_TIME ,'YYYY-MM-DD HH24:MI:SS')AND OPERATION ='BACKUP'AND STATUS ='COMPLETED' 其中STATUS主要有RUNNING、RUNNING WITH WARNINGS、RUNNING WITH ...
Operation的值有:rman、backup、list、report Status的值有:running、running with warnings、running with errors、completed、completed with warnings、completed with errors、failed 1. 2. V$RMAN_OUTPUT:查看RMAN的输出,记录RMAN生成的信息。内存中的视图,不会记录到控制文件,最多37278行 ...
YES or NO, depending upon whether or not a control file autobackup was done as part of this backup job STATUS VARCHAR2(23) One of the following values: RUNNING WITH WARNINGS RUNNING WITH ERRORS COMPLETED COMPLETED WITH WARNINGS COMPLETED WITH ERRORS ...
STATUS:RMAN备份job的结果状态,如正在备份但是有警告(RUNNING WITH WARNINGS),正常完成(COMPLETED)、完成但是有错误(COMPLETED WITH ERRORS)等 RUNNING WITH WARNINGS RUNNING WITH ERRORS COMPLETED COMPLETED WITH WARNINGS COMPLETED WITH ERRORS FAILED SQL>select INPUT_TYPE,STATUS from v$rman_backup_job_details; ...
在Oracle 数据库很多的情况下，可以利用V$RMAN_BACKUP_JOB_DETAILS+DB_LINK的方式实现集中监控所有数据库的Rman备份情况，而无需登录到数据库所在主机查看备份日志，减轻了DBA的工作量。SQL> desc v$rman_backup_job_details Name Null? Type --- --- --- SESSION_KEY NUMBER SESSION_RECID ...
WITH WARNINGS 正常完成 COMPLETED 完成但是有错误 COMPLETED WITH ERRORS 等 RUNNING WITH WARNINGS RUNNING WITH ERRORS COMPLETED COMPLETED WITH WARNINGS COMPLETED WITH ERRORS FAILED SQL SELECT INPUT TYPE STATUS FROM V RMAN BACKUP JOB DETAILS INPUT TYPE STATUS DB FULL COMPLETED DB FULL COMPLETED DB FULL ...
OSB_ALLOCATED VARCHAR2(3) 互YES及 鷅洁V$RMAN_STATUS申亙奈匹舑 e今木凶硌隅及紱釬笢卞﹜Oracle Secure Backup民乓生伙互賃曰絞化日木凶仇午毛砩庤允月﹝ NUMBER 犯奈正互憝 S允月戊件氾瓜及ID﹝褫夔卅 反棒及午云曰﹝ 及矢奈斥 棒及矢奈斥...