5 Replies Latest reply: Feb 15, 2013 6:17 PM by 990636 RSS

    Total database backup time varies after applying patch.

    990636
      Hello Gurus,

      I have applied a patch last week to my database to 10.2.0.5, initially it was 10.2.0.1.Before the patch the database took 10hrs to complete the rman backup job through OEM and used to grab 590GB data.After the patch the rman job finishes in 2 hrs and it's only grabs around 220gb without any errors

      The total database size is 590GB but used space 220 and free is 370 gb.

      Magic question is why it's taking 2 hrs to complete and only backing up 220 gb in 10.2.0.5 compare to 10.2.0.1.


      I have used this query to check the size of the database.

      SESSION_KEY, INPUT_TYPE, STATUS,
      to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
      to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
      elapsed_seconds/3600 hrs
      from V$RMAN_BACKUP_JOB_DETAILS
      order by session_key;