• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Urgent: Oracle Database 9i

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have some question regarding oracle database architecture. It is not proper place to post these quetion but i didnt find any better place than this...plz reply me as soon as possible i have exams ahead
Q1 DBWR Process writes dirty bufers to Data files. Consider a situation in which DBWR writes uncommitted data to data files and instance then crashes then how its recovery will happen next time when instance starts?
Q2 LGRW write log entries to Log files..similarly if LGRW writes uncommited redo log entries to redo log files and then instnce crashes what will happen?
Q3 How SCN is tackled at instance recovery procedure?
Q4 How at instance recovery phase oracle db come to know that this data in data files belongs to uncommitted transaction adn these redo lod entries in redo log files are part of committed transaction
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


I have some question regarding oracle database architecture. It is not proper place to post these quetion but i didnt find any better place than this...plz reply me as soon as possible i have exams ahead



What about the Oracle forum?
Mark
 
High Plains Drifter
Posts: 7289
Netbeans IDE VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I agree with Thomas Paul that such a question isn't suited to the Oracle forum, which is intended for Oracle Application Server questions, and not general database functionality.
I think General Computing is about as good as it gets for this question, so off it goes to that space.
 
Ranch Hand
Posts: 4982
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


Q1 DBWR Process writes dirty bufers to Data files. Consider a situation in which DBWR writes uncommitted data to data files and instance then crashes then how its recovery will happen next time when instance starts?


During recovery, the data in the (online) redo log files will be used.
For simplicity, assume that the DB will insert log records as follows:

where, Tx(i) is the transaction ID, X is the data item that being access, Vold is the old value of data item X, Vnew is the new value of data item X.
Thus, if we use the simplest recovery algorithm, we scan the redo log once, we can have a set of Tx(m) where they are committed, and we can have another set of Tx(n) where they are not committed (those transactions without the operations commit are regarded as not committed, and will be rollback). And we can first undo those uncommitted transactions inside the datafiles, and the redo those committed transactions.


Q2 LGRW write log entries to Log files..similarly if LGRW writes uncommited redo log entries to redo log files and then instnce crashes what will happen?


Based on the above discussion, if the transactions do not committed, the operation commit will NOT appear inside the redo log files, and thus, we know which transactions to be redo and which to be undo.


Q3 How SCN is tackled at instance recovery procedure?


Whenever there is a new log record, a SCN will be assigned to it. In normal operations, if the transaction commits, the committed transaction, together with its corresponding SCN in the log will be recorded. Thus, it can improve a bit with our simplest algorithm. If the SCN in the redo log file is already committed, it imples that the data MUST appear in the data file, and we do not need to cater it during recovery.


Q4 How at instance recovery phase oracle db come to know that this data in data files belongs to uncommitted transaction adn these redo lod entries in redo log files are part of committed transaction


The simiplest recovery algorithm example shows how can the DB recover the data. Of course, this may not be the algorithm for DB to recover, as the performance issues. They will use other algorithms but the idea is same to the simplest one.
Nick
 
You are HERE! The other map is obviously wrong. Better confirm with this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic