Check Oracle Archivelog Mode Status

1 year ago
Ava Mitchell
1 minute

To check if the Oracle database has enabled archive log mode, you can follow these steps:

  1. Log in to the SQL*Plus or SQL Developer tool in the Oracle database.
  2. Execute the following SQL query:
SELECT log_mode FROM v$database;

If the query result is ARCHIVELOG, then it means that archivelog mode is enabled; if the query result is NOARCHIVELOG, then it means that archivelog mode is not enabled.

Additionally, you can execute the following SQL query to view the target path of the archived logs:

SELECT name, value FROM v$parameter WHERE name = 'log_archive_dest_1';

This statement will display the target path of the current archive log.

bannerAds