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

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?

Where in the script do you put your ARCHIVELOG and AUTOEXTEND to make sure that your redo log files are archived and autoextend?

Thanks Received on Thu Apr 17 2003 - 20:15:10 CEST