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

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
>
>
> 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

-- 
Regards, Frank van Bortel