Connect with me
An Oracle database can run in one of two modes. By default, the database is created in NOARCHIVELOG mode. This command will check to see if you have altered your database to run in ARCHIVELOG mode.
Set the environment variables if not added refer my last post to set the environment variables
Run the below command to know if you are running oracle database in ARCHIVELOG mode
[email@example.com ~]$ sqlplus / as sysdba SQL*Plus: Release 184.108.40.206.0 Production on Thu Feb 6 13:45:03 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 24 Next log sequence to archive 25 Current log sequence 25 SQL>
Or you can run the below line
SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG
Also published on Medium.