5 Replies Latest reply on Feb 16, 2013 12:17 AM by 990636

    Total database backup time varies after applying patch.

      Hello Gurus,

      I have applied a patch last week to my database to, initially it was 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 compare to

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

      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
      order by session_key;