Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Archivelog Problem Running Two Instances
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
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