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 - 13:41:06 CST
