Oracle DB, Enable archive log mode
# DB Param ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/u01/app/oracle/archivelogs' SCOPE=BOTH; ALTER SYSTEM SET LOG_ARCHIVE_FORMAT = 'DEV_%t_%s_%r.dbf' SCOPE=SPFILE; # DB server sqlplus / as sysdba ARCHIVE LOG LIST; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; ARCHIVE LOG LIST; SELECT log_mode FROM v$database; # Test Aarchive log ALTER SYSTEM SWITCH LOGFILE