RE: Redo log question

See comments below, copied from 9i concepts guide (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c09procs.htm#21919)

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Peter Dixon

. . .

> If the instance crashed then,
> on recovery
> SMON would firstly reconstruct the undo from the change
> vectors to the
> rollback block and reconstruct the changes to the data blocks
> but would then
> rollback the changes because the transaction table slot in
> the rollback
> segment header shows that this transaction is not comitted.
>
> Is this correct?

Yes, I believe you are correct.

>
> OK moving on - what exactly happens when the user issues a
> COMMIT?
. . .

>
> So when rolling forward using the online redo log files, for this
> transaction we have:
>
> 1) rollback segment header(uncommitted)
> 2) change vectors to reconstruct "before image" undo blocks
> 3) change vectors to change data blocks
> 3) rollback segment header(committed)
>
> I'm sure this is an over simplified (and probably wrong) version. Can
> someone please clarify this for me?

Not sure about that, I can't find any detail on exactly what the contents of the "commit record" are, but here is what is says in the doc:

"When a user issues a COMMIT statement, LGWR puts a commit record in the redo log buffer and writes it to disk immediately, along with the transaction's redo entries."

>
> My other major area of confusion in all of this is where do
> SCN's fit in,
> when are they allocated?

"When a user commits a transaction, the transaction is assigned a system change number (SCN), which Oracle records along with the transaction's redo entries in the redo log. SCNs are recorded in the redo log so that recovery operations can be synchronized in Oracle9i Real Application Clusters and distributed databases."

HTH
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l