DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001


    i am preparing for Backup and Recovery paper, my question is that how can be a datafile can contain uncommitted data and after roll forward what will happen to that data.


  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Sure datafile can contain uncommited data. Imagine a case when you insert 100MB worth of rows in a table in a single transaction, but your redo logs are only 1MB in size. Whenever the log switch ocurs DBWR has to write the whole content of a redo log, either it is commited or not. It can't be any different.

    I'm not sure what you mean what will happen to that data during roll forward. Roll forward ocures only during recovery process. If this is what you are interested in, then during roll forvard all that uncomitted data will again be written to the database files. But after roll forward there allways comes *roll back* phase in which all those uncommited data will be rolled back.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.