Disabling a Journal Archive

Go Up to Using Journal Archiving

The DROP JOURNAL ARCHIVE statement disables journal archiving for the database. It causes all journal files and database file dumps to be deleted in all journal archive directories. The file system directories themselves are not deleted.

Disabling journal archiving does not disable database journaling (the creation of journal files). The database will continue to use the write-ahead protocol to commit database changes to the journals. If the intent is to also disable journaling, then you must execute a separate DROP JOURNAL statement, shown in Disabling Journal Files.

To disable journal archiving, use the following syntax:

DROP JOURNAL ARCHIVE