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

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.

>>
>>
>> Where in the script do you put your ARCHIVELOG and AUTOEXTEND to
>> make sure that your redo log files are archived and autoextend?
>They cannot autoextend. And archive logging is a two-step
>process:
>1) make the instance run in archive_log mode
>2) start the archiving process.
>
>Also, I would use more redolog groups (3 at least!), and would consider
>multiplexing the redolog files, if this is anything more than a test bed
Received on Thu Apr 17 2003 - 17:32:17 CDT