Re: Archiving Redo Log Files

The answer of Kenneth is correct. Unfortunately he forgot to tell you need to close or shutdown the database first. So either issue
shutdown immediate
startup mount
or
alter database close
and then issue the commands outlined below. Hth,

Sybrand Bakker, Oracle DBA

On Tue, 13 Jul 1999 15:50:23 +0200, Florian Petter <florian.petter_at_braintrust.at> wrote:

>Thanks for your help, but this do not work.....
>
>How can I enable the "Archiving Redo Log Files" if the database
>was created with the "Typical Configuration Option"? I have not
>select the "Archive Log" check box in the oracle database assistant!
>
>Thanks,
>Florian
>
>
>Kenneth C Stahl wrote:
>
>> Use svrmgrl to mount, but not open, the database.
>>
>> Enter the commands:
>> alter database archive log
>> archive log start
>> alter database open
>>
>> exit out of svrmgrl and edit your initxxx.ora file to add:
>>
>> log_archive_start = true
>>
>> Ken
>>
>> Florian Petter wrote:
>>
>> > Hi!
>> >
>> > How can I enable the "Archiving Redo Log Files" in a oracle 8 database?
>> > (not with the oracle installer)
>> >
>> > Thanks,
>> > --
>> > Florian Petter
>> > BRAINTRUST New Media Solutions
>> > Schopenhauerstrasse 36
>> > A-1180 Vienna
>> > Phone +43-1-40416-0
>> > Fax +43-1-40416-33
>> > eMail: florian.petter_at_braintrust.at
>
Received on Wed Jul 14 1999 - 04:11:33 CDT