Forum Stats

  • 3,825,018 Users
  • 2,260,455 Discussions
  • 7,896,382 Comments

Discussions

"RECVR AREA" value in V$RMAN_BACKUP_JOB_DETAILS

GurettoAndrea
GurettoAndrea Member Posts: 1 Green Ribbon
edited May 19, 2020 10:48AM in Recovery Manager (RMAN)

Can anyone tell me what the "RECVR AREA" value of column INPUT_TYPE in  V$RMAN_BACKUP_JOB_DETAILS means?

By querying the above view I get this value at a full or lev_0 backup.

SESSION_KEY INPUT_TYPE    STATUS    START_TIME     END_TIME           HRS

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

      18542 ARCHIVELOG    COMPLETED 05/14/20 09:46 05/14/20 10:14     .47

      18546 ARCHIVELOG    COMPLETED 05/14/20 21:41 05/14/20 22:15     .57

      18550 ARCHIVELOG    COMPLETED 05/15/20 09:54 05/15/20 10:21     .45

      18554 RECVR AREA    COMPLETED 05/15/20 20:05 05/17/20 00:49   28.74  <---- full???

      18556 ARCHIVELOG    COMPLETED 05/15/20 21:55 05/15/20 22:48     .8

      18560 ARCHIVELOG    COMPLETED 05/16/20 09:50 05/16/20 10:33     .73

      18564 ARCHIVELOG    COMPLETED 05/16/20 21:50 05/16/20 22:40     .83

      18574 ARCHIVELOG    COMPLETED 05/17/20 09:45 05/17/20 09:51     .11

      18578 ARCHIVELOG    COMPLETED 05/17/20 21:51 05/17/20 22:04     .22

      18582 ARCHIVELOG    COMPLETED 05/18/20 09:50 05/18/20 10:07     .29

Is it correct ?

Thanks

Andrea

Answers