OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Redo Log (oracle 10g ,linux)

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

Redo Log [message #358581]

Tue, 11 November 2008 21:56

vinniora
Messages: 56
Registered: October 2008
Location: Mumbai

Member

hi to all....i want to know that is there any restriction on the number of redo-log file that can be created..and if their than please tell me the maximum number of redo-log that can be created for a database(single instance)...

Report message to a moderator

Re: Redo Log [message #358638 is a reply to message #358581]

Wed, 12 November 2008 00:55

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Redo log groups or redo log members in each group?

Regards
Michel

Report message to a moderator

Re: Redo Log [message #358643 is a reply to message #358638]

Wed, 12 November 2008 01:01

vinniora
Messages: 56
Registered: October 2008
Location: Mumbai

Member

redo-log members...and if there is any restriction of number of redo log group than state that also...

Report message to a moderator

Re: Redo Log [message #358648 is a reply to message #358643]

Wed, 12 November 2008 01:10

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You defined the limit at database creation time.

Regards
Michel

Report message to a moderator

Re: Redo Log [message #358652 is a reply to message #358581]

Wed, 12 November 2008 01:17

vinniora
Messages: 56
Registered: October 2008
Location: Mumbai

Member

yeah thnx..but as we define maxlog member at database creation time...so i want to know that is this maxlogmember has some range any maximum value????

Report message to a moderator

Re: Redo Log [message #358655 is a reply to message #358652]

Wed, 12 November 2008 01:35

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

A quick look to the documentation says:

Quote:

The default, minimum, and maximum values depend on your operating system.

Regards
Michel

Report message to a moderator

Previous Topic:	Add datafile to UNDO, then remove datafile again
Next Topic:	ORACLE UPGRADE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 12:31:41 CDT 2024