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

From: TC <donotuse_at_donotuse.com>
Date: Thu, 17 Apr 2003 20:47:58 GMT
Message-ID: <2qEna.494329$L1.141905_at_sccrnsc02>


what do you mean ???

Check your documentation on "ARCHIVELOG". It requires a few parameters in init.ora and a few steps. Read it up please.

"AUTOEXTEND" on logfiles is unheard of

//tc

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:eqrt9v03huhpm664ol0u424580i36h66qs_at_4ax.com...
> 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 - 22:47:58 CEST

Original text of this message