Re: Archive Log

Hi

You need to modify the init.ora files for each instance and perform the following for each instance:

svrmgr> shutdown immediate
svrmgr> startup mount
svrmgr> alter database archivelog;
svrmgr> alter system archivel log start;
svrmgr> alter database open;

Check the status by typing

svrmgr> archive log list

Hope it helps.

Alistair

Juergen Fechter <J.Fechter_at_science-computing.de> wrote in message news:9tgcq4$dts$1_at_news.BelWue.DE...
> We use orcale 8.0.6 and we want to set two databases into the Archive Log
> Mode.
> But it seems that only one can be in the Archive Log Mode at one time.
>
> We inserted the following lines into init<sid>.ora
> > log_archive_start=true and
> > log_archive_dest=D:\orant\archive
>
> We changed the state of both databases
> svrmgr> connect internal/<password>@<sid>
> svrmgr> shutdown immediate
> svrmgr> startup mount
> svrmgr>
>
>
>
>
>
Received on Wed Nov 21 2001 - 09:59:30 CST