SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure

The SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system
procedure disables the log archive mode and deletes any existing online archived
log files if the DELETE_ARCHIVED_LOG_FILES input parameter
is non-zero.

Syntax

If the input parameter value for the DELETE_ARCHIVED_LOG_FILES parameter
is a non-zero value, then all existing online archived log files are deleted.
If the parameter value is zero, then exiting online archived log files are
not deleted.

JDBC example

The following example disables log
archive mode for the database and deletes any existing log archive files.