Archive Log

From: Juergen Fechter <J.Fechter_at_science-computing.de>
Date: Wed, 21 Nov 2001 15:32:16 +0100
Message-ID: <9tgdtg$ljj$1@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 - 08:32:16 CST