Re: How do you specify the maximum number of redo log files for automatic recovery in the initialization file?

From: Frank <fvanbortel_at_netscape.net>
Date: Fri, 18 Apr 2003 12:43:15 +0200
Message-ID: <3E9FD6C3.9040106@netscape.net>

Peter wrote:
> On Thu, 17 Apr 2003 20:59:00 +0200, Frank <fvanbortel_at_netscape.net>
> wrote:
>
>

>>Peter wrote:
>>
>>>Suppose I have the following in sql script file:
>>>
>>>    logfile  group 1 ('e:\oracle\oradata\hmrs\redolog01.log') 
>>>                size 100m reuse,
>>>              group 2 ('f:\oracle\oradata\hmrs\redolog02.log') 
>>>                size 100m reuse
>>>
>>>How do you specify the maximum number of redo log files for automatic
>>>recovery in the initialization file?
>>
>>You don't, and you don't need to, either

>
>
> I checked it. You can set MAXLOGHISTORY to set it. Oracle does allow
> you to do this.
>
>

I stand corrected. You can.
but:
This parameter is useful only if you are using Oracle with the Parallel Server option in parallel mode, and archivelog mode enabled.

-- 
Regards, Frank van Bortel

Received on Fri Apr 18 2003 - 05:43:15 CDT