OraFAQ Forum: Backup & Recovery » why we need redo log files when transaction is commited

Home » RDBMS Server » Backup & Recovery » why we need redo log files when transaction is commited

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why we need redo log files when transaction is commited [message #649680]

Sun, 03 April 2016 22:24

aruntutor
Messages: 10
Registered: June 2014
Location: chennai

Junior Member

Hi ,

PFA

I have came across this statement in oracle doc. Hence would like verify the same with u people.

"Online redo log files are used , when there is a instance failure to recover committed data that has not been written to data files."

Here is my Q.

When a transaction is committed, it means data has been saved to data files.

In such cases, why we need redo log files when the data is already committed ???

Attachment: redo.png
(Size: 185.64KB, Downloaded 1874 times)

Report message to a moderator

Re: why we need redo log files when transaction is commited [message #649681 is a reply to message #649680]

Sun, 03 April 2016 22:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>When a transaction is committed, it means data has been saved to data files.
above is WRONG & INCORRECT

https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm

Commit Transactions
Committing a transaction means making permanent the changes performed by the SQL statements within the transaction.

Before a transaction that modifies data is committed, the following has occurred:

Oracle has generated undo information. The undo information contains the old data values changed by the SQL statements of the transaction.

Oracle has generated redo log entries in the redo log buffer of the SGA. The redo log record contains the change to the data block and the change to the rollback block. These changes may go to disk before a transaction is committed.

The changes have been made to the database buffers of the SGA. These changes may go to disk before a transaction is committed.

Report message to a moderator

Re: why we need redo log files when transaction is commited [message #649682 is a reply to message #649681]

Mon, 04 April 2016 00:02

aruntutor
Messages: 10
Registered: June 2014
Location: chennai

Junior Member

Thanks dude . got the logic now. nice explanation.

Report message to a moderator

Previous Topic:	Is it necessary to back up the whole database when moving a datafile
Next Topic:	RMAN How to restore completed backup without recover archive redo log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 02:06:05 CST 2024