Improve company productivity with a Business Account.Sign Up

x
?
Solved

rollforward

Posted on 2004-04-29
4
Medium Priority
?
282 Views
Last Modified: 2008-03-10
  what is rollforwrd data in oracle after instance crash and what happens during rollforward?
0
Comment
Question by:laksirib76
2 Comments
 
LVL 12

Accepted Solution

by:
catchmeifuwant earned 120 total points
ID: 10946946
0
 

Expert Comment

by:sachinkaggrawal
ID: 10947043
when we starts any transaction in the oracle, normally we make some changes in the database tables.
Now when we commit  these changes, all the changes from dbcache are written to disk datafiles. And some SCN is generated which is stamped in the redolog files. now suppose that after commit the data from redo buffer is written to redo file. after this the commited statement will be shown to the user.

but if now before this data being written to datafiles, the instance crashed. now this commited data which is not written to datafiles is rollforward data.

when the oracle instance starts again then this data is written to datafiles during instance recovery. this process of writing data to disk, in which the oracle comes to an consistent state, which was before crash, is known as rollforwarding state.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What we learned in Webroot's webinar on multi-vector protection.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question