FIELD STAUS IN TABLEE RC_RMAN_STATUS AND VIEW V$RMAN_STATUS ARE DIFFERENT??
664334Oct 9 2008 — edited Oct 9 2008making follow-up to a problem I had with the dayly backups
got a backup diefrencia between the RC_RMAN_STATUS table and the view
v$RMAN_STATUS with field STATUS
where both objects is usually different with the
kind of full backup "DB FULL" in the Table show "FAILED" and in the view show "COMPLETTE"
I would like to know if anyone has any idea that it could be,
according to the oracle documentation
I understand that the difference between the two objects is
that the view does not include the information of the
current session and some other fields.
could be a bug?
pardon by my poor english
show sample querys
QUERY IN PROD DATABASE WHERE RESIDE VIEW
10:20:00 <SYSTEM prod> select recid , stamp, status ,
10:20:00 2 to_char(start_time,'DD-MON-YYYY HH24:MI') starttime,
10:20:00 3 to_char(end_time,'DD-MON-YYYY HH24:MI') endtime,
10:20:00 4 object_type
10:20:00 5 from v$rman_status
10:20:00 6 where start_time >= to_date('07-oct-08','dd-mon-yy')
10:20:00 7 and object_type = 'DB FULL'
10:20:00 8 order by 1
10:20:00 9 /
RECID STAMP STATUS STARTTIME ENDTIME OBJECT_TYP
---------- ---------- --------------------- -------------------- -------------------- ----------
4184 667483508 COMPLETED 07-OCT-2008 12:05 07-OCT-2008 14:30 DB FULL
4196 667492362 COMPLETED 07-OCT-2008 14:32 07-OCT-2008 16:52 DB FULL
4220 667530031 COMPLETED 08-OCT-2008 01:00 08-OCT-2008 03:04 DB FULL
4243 667587931 FAILED 08-OCT-2008 17:05 08-OCT-2008 17:20 DB FULL
4262 667616432 COMPLETED 09-OCT-2008 01:00 09-OCT-2008 03:05 DB FULL
QYUERY IN RMAN DATABASE WHERE RESIDE TABLE
10:20:36 <RMAN > select recid , stamp, status ,
10:20:36 2 to_char(start_time,'DD-MON-YYYY HH24:MI') starttime,
10:20:36 3 to_char(end_time,'DD-MON-YYYY HH24:MI') endtime,
10:20:36 4 object_type
10:20:36 5 from rc_rman_status
10:20:36 6 where start_time >= to_date('07-oct-08','dd-mon-yy')
10:20:36 7 and object_type = 'DB FULL'
10:20:36 8 order by 1
10:20:36 9 /
RECID STAMP STATUS STARTTIME ENDTIME OBJECT_TYP
---------- ---------- --------- -------------------- -------------------- ----------
4184 667483508 FAILED 07-OCT-2008 12:05 DB FULL
4196 667492362 FAILED 07-OCT-2008 14:32 DB FULL
4220 667530031 FAILED 08-OCT-2008 01:00 DB FULL
4243 667587931 FAILED 08-OCT-2008 17:05 08-OCT-2008 17:20 DB FULL
4262 667616432 FAILED 09-OCT-2008 01:00 DB FULL
5 rows selected.
Elapsed: 00:00:00.00
10:20:36 <RMAN >