Home » Server Options » Data Guard » Long transactions (Oracle 10.2.0.1.0 - Linux)
Long transactions [message #356126] Wed, 29 October 2008 12:44 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!

I've got a question...
How does online redo logfiles work when there is a long transaction?
Are they written to archived redo logs as they get full or they wait for the transaction to end?
If they wait for the transaction to end... How does the database react if it runs out of redo logfiles?

Thanks a lot!

Daniela.

Report message to a moderator

Re: Long transactions [message #356133 is a reply to message #356126] Wed, 29 October 2008 13:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
They are written to archived logs.

Regards
Michel

Report message to a moderator

Re: Long transactions [message #356141 is a reply to message #356126] Wed, 29 October 2008 13:29 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Thanx!!

Report message to a moderator

Re: Long transactions [message #379946 is a reply to message #356126] Thu, 08 January 2009 10:19 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
... and what happens if it needs to rollback a transaction that at some point had to be written to archived logs?

Report message to a moderator

Re: Long transactions [message #379950 is a reply to message #379946] Thu, 08 January 2009 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Rollback marker is written in redo log, that's all.

Regards
Michel

[Updated on: Thu, 08 January 2009 10:28]

Report message to a moderator

Re: Long transactions [message #379952 is a reply to message #356126] Thu, 08 January 2009 10:30 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Oh! Great!!

Thank you!!
Daniela.

Report message to a moderator

Re: Long transactions [message #379954 is a reply to message #379952] Thu, 08 January 2009 10:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Well, when I say that's all, that's all from the point of view of redo logs but of course all modifications are undone in the data blocks (and also rollback header is updated to indicate that the transaction completed and those kind of things).

Regards
Michel

Report message to a moderator

Re: Long transactions [message #379955 is a reply to message #356126] Thu, 08 January 2009 10:54 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
And how does it work when logs are applied to the Standby db?

Report message to a moderator

Re: Long transactions [message #379956 is a reply to message #379955] Thu, 08 January 2009 11:04 Go to previous message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
When it sees the rollback marker, Oracle applies the rollback data to undo modifications in data blocks as it did it in primary.

Regards
Michel

[Updated on: Thu, 08 January 2009 11:10]

Report message to a moderator

Previous Topic: Alter table and Data guard
Next Topic: dbstart
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 04:09:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.