Release Online Archive Lock

When running an online backup, the backup will fail with error: 7595 Operation not allowed: an online archive logging is currently active on %VSTR
It is most likely that this is a result of a previous online archive that did not entirely complete (i.e. backup aborted)
*** Note: Any online backups/restores will keep this log active. All changes to the table are captured in this log.
Until this log is turned off manually, this journal will continue to grow larger.


Probable Cause: Most likely that the LOGGING ONLINE ARCHIVE is still turned on from a previous job.
Details from ARC manual:
The LOGGING ONLINE ARCHIVE OFF statement stops online logging on the specified
objects. This statement must be submitted for all objects after the online archive is complete if
the LOGGING ONLINE ARCHIVE ON statement was used, or if an online archive job fails. If
LOGGING ONLINE ARCHIVE OFF is not submitted, logging will continue on the objects
indefinitely.

To verify that Online Archive Logging is still in use, run the following SQL Statement:


select CreateTimeStamp,
DatabaseName (VARCHAR(30)),
TVMName (VARCHAR(30))
from DBC.ArchiveLoggingObjsV;
.
Solution: To turn off online archive logging, run the following command (using ARCmain):
LOGGING ONLINE ARCHIVE OFF for (<parent database>) ALL, OVERRIDE;

Example :
.set session transaction BTET
.logon 10.108.0.94/sysdba,;
.set width 100


LOGGING ONLINE ARCHIVE OFF FOR Eadw_Core_Tbl,override;

.logoff;
.exit;