Re: Archive Log

yes of course you must use two different log_archive_dest values.

These are two differeent databases!

"Juergen Fechter" <J.Fechter_at_science-computing.de> wrote in message news:9tgdtg$ljj$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 database 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
>
> I'm not sure if we should use different paths for archive_destination like
> D:\orant\archive\<sid name>
>
> We changed the state of both databases which will work:
> svrmgr> connect internal/<password>@<sid>
> svrmgr> shutdown immediate
> svrmgr> startup mount
> svrmgr> alter database archivelog;
> svrmgr> alter database open;
> svrmgr> archive log list;
>
> This command shows that the exclusive opened database is in the archive
log
> mode.
> Database Log Mode ARCHIVE LOG
> Automatic Archival ENABLED
>
> But after rebooting the server only one of the two databases is in the
> archive log mode.
> svrmgr> connect internal/<password>@<sid>
> svrmgr> shutdown immediate
> svrmgr> startup
> svrmgr> archive log list;
>
> Then the first database is in archive mode the second not.
>
> Any idea what is going wrong?
>
> Juergen
>
>
Received on Wed Nov 21 2001 - 12:08:10 CST