OraFAQ Forum: Server Administration » Redo log Group & Members

Home » RDBMS Server » Server Administration » Redo log Group & Members

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

Redo log Group & Members [message #158951]

Wed, 15 February 2006 03:50

gajini
Messages: 262
Registered: January 2006

Senior Member

Consider a redo log group which contains two members i.e.,redo1.log,redo2.log. My doubt is while redo1.log is getting filled,will redo2.log also get filled with the same contents?

Report message to a moderator

Re: Redo log Group & Members [message #158980 is a reply to message #158951]

Wed, 15 February 2006 05:29

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Yes, All the members of a group holds the same data.

Report message to a moderator

Re: Redo log Group & Members [message #158995 is a reply to message #158951]

Wed, 15 February 2006 06:43

gajini
Messages: 262
Registered: January 2006

Senior Member

Then,can you explain me What is the use/need of having two or more than two members for a Redo log Group?

Report message to a moderator

Re: Redo log Group & Members [message #159070 is a reply to message #158995]

Wed, 15 February 2006 23:23

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Just for a safe side, you have an extra log memeber even if one redo log member gets corrupted.

Note: Its not compulsory to have more than one log member in a group.

Report message to a moderator