Backup & Recovery paper
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Backup & Recovery paper

  1. #1
    Join Date
    Jan 2001
    Posts
    1

    Angry


    hello!
    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.

    thankyou

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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