enable/Disable archivelog in oracle database

 

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     90553

Current log sequence           90555

SQL> select log_mode from v$database;

LOG_MODE

------------

NOARCHIVELOG

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 2516582224 bytes

Fixed Size                  9031504 bytes

Variable Size             587202560 bytes

Database Buffers         1912602624 bytes

Redo Buffers                7745536 bytes

Database mounted.

SQL> alter database archivelog;  (When Disable  --> alter database noarchivelog; )

Database altered.

SQL> alter database open;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE

------------

ARCHIVELOG

SQL> select log_mode from v$database;