Database - RAC/Scalability (MOSC)

MOSC Banner

V$RMAN_BACKUP_JoB_DETAILS output different for different nodes

edited Nov 29, 2012 8:25AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center