Home » RDBMS Server » Server Administration » Redo Log (oracle 10g ,linux)
Redo Log [message #358581] Tue, 11 November 2008 21:56 Go to next message
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)...
Re: Redo Log [message #358638 is a reply to message #358581] Wed, 12 November 2008 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Redo log groups or redo log members in each group?

Regards
Michel

Re: Redo Log [message #358643 is a reply to message #358638] Wed, 12 November 2008 01:01 Go to previous messageGo to next message
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...
Re: Redo Log [message #358648 is a reply to message #358643] Wed, 12 November 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You defined the limit at database creation time.

Regards
Michel
Re: Redo Log [message #358652 is a reply to message #358581] Wed, 12 November 2008 01:17 Go to previous messageGo to next message
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????
Re: Redo Log [message #358655 is a reply to message #358652] Wed, 12 November 2008 01:35 Go to previous message
Michel Cadot
Messages: 64110
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
Previous Topic: Add datafile to UNDO, then remove datafile again
Next Topic: ORACLE UPGRADE
Goto Forum:
  


Current Time: Mon Dec 05 10:47:35 CST 2016

Total time taken to generate the page: 0.13762 seconds