How To Enable/Disable Archive Log Mode In Oracle Database?
How To Enable/Disable Archive Log Mode In Oracle Database Step 1: Connect to the database the following command ============================== [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 22 14:40:27 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1157627168 bytes Fixed Size 8895776 bytes Variable Size 436207616 bytes Database Buffers 704643072 bytes Redo Buffers 7880704 bytes Database mounted. Database opened. Step 2: To check the ARCHIVELOG mode status, enter the following SQL command: ================================== SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/archive Oldest online log sequence 22 Current log sequence 24 Step 3:To enable ARCHIVELOG mode status, enter the following SQL commands: =================