V$RMAN_BACKUP_JoB_DETAILS output different for different nodes
Hi Experts,
For 2 node RAC database, we are running backup from node1. Output from V$RMAN_BACKUP_JoB_DETAILS is running but at same time output from node2 for view V$RMAN_BACKUP_JoB_DETAILS is failed,
Any idea how come this is happening.
Node 1 :
SQL> !date
Thu Nov 22 02:07:37 EST 2012
SQL> select a.* from (select session_key, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
2 3 to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
4 elapsed_seconds/3600 hrs
5 from V$RMAN_BACKUP_JoB_DETAILS
6 order by session_key desc) a
7 where rownum < 2;
SESSION_KEY STATUS START_TIME END_TIME HRS
0