Database Backup and Recovery (MOSC)

MOSC Banner

Why SESSION_KEY value in V$RMAN_BACKUP_JOB_DETAILS different from RC_RMAN_BACKUP_JOB_DETAILS

edited Mar 2, 2019 8:52AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓

As you can see SESSION_KEY  for the same backup is different is it normal ?

RC_RMAN_BACKUP_JOB_DETAILS:

SESSION_KEY DB_NAME  INPUT_TYPE    STATUS     START_TIME       END_TIME         OUTPUT_BYTES_DISPLAY     TIME_TAKEN_DISPLAY

----------- -------- ------------- ---------- ---------------- ---------------- ------------------------ ------------------------

       1428 OPENVIEW DB FULL       COMPLETED  2019-02-26 02:04 2019-02-26 02:05     1.38G                00:00:59

       1650 OPENVIEW ARCHIVELOG    COMPLETED  2019-02-26 02:26 2019-02-26 02:33     1.01G                00:07:31

       1623 OPENVIEW ARCHIVELOG    FAILED     2019-02-26 02:23 2019-02-26 02:23     0.00K                00:00:33

       1810 OPENVIEW ARCHIVELOG    RUNNING    2019-02-27 20:31 2019-02-27 20:31    14.41M                00:00:06

V$RMAN_BACKUP_JOB_DETAILS:

SESSION_KEY INPUT_TYPE    STATUS     START_TIME       END_TIME         OUTPUT_BYTES_DISPLAY     TIME_TAKEN_DISPLAY

----------- ------------- ---------- ---------------- ---------------- ------------------------ ------------------------

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