RE: Redo log question
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <peterdixon001@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Sep 2005 15:43:06 -0700
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
