Re: Archivelog Problem Running Two Instances

My guess is that the appropriate SID was not designated when the Instance Manager was used, or if from the command line, ORACLE_SID was not set to the proper database. You can look in the alert logs of both databases and see if one has it listed twice.

JAZZIN44 wrote:

> We're running Oracle8 on an NT Server with two instances and they are TEST and
> PROD. I've added similar entries into the initSID.ora files:
> LOG_ARCHIVE_START=true
> LOG_ARCHIVE_DEST=Q:\orant\archivelogs\SID
> LOG_ARCHIVE_FORMAT=%%ORACLE_SID%%S.ARC
> And I've shutdown both instances and did an ALTER DATABASE ARCHIVELOG;
> on each with MOUNT EXCLUSIVE and then ALTER DATABASE OPEN;.
>
> Now when I startup the instances, the only one that returns ARCHIVELOG
> for SELECT LOG_MODE from V$DATABASE; is the TEST instance. The PROD
> instance still returns NOARCHIVELOG.
> I really don't need ARCHIVELOGs from the TEST instance anyway and even
> tried to start ARCHIVING on just the PROD instance by itself to no avail.
> Any help would be great.
>
Received on Thu Feb 11 1999 - 15:12:54 CST