Re: Archive Log

On Wed, 21 Nov 2001 18:46:46 +0100, "Juergen Fechter" <J.Fechter_at_science-computing.de> wrote:

>
>"Alistair" <alistair.thomson_at_sphinxcst.co.uk> schrieb im Newsbeitrag
>news:9tgio7$o9j$1_at_thorium.cix.co.uk...
>> Hi
>>
>> You need to modify the init.ora files for each instance and perform the
>> following for each instance:
>
>I did this for every instance.
>
>> svrmgr> shutdown immediate
>> svrmgr> startup mount
>> svrmgr> alter database archivelog;
>> svrmgr> alter system archive log start;
>
>I did this too and after checking with
>the command archive log list the databases were
>in the archive mode. But after reboot of the server only
>one database ist in the archive mode the other not.
>
>> svrmgr> alter database open;
>>
>> Check the status by typing
>>
>> svrmgr> archive log list
>
>Juergen
>

Check your init.ora of the affected database. log_archive_start needs to be set to true

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Nov 21 2001 - 12:30:01 CST