Square DBA – Oracle DBA Talk

How to put a database in archivelog mode? It’s pretty simple really.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                   778976 bytes
Variable Size             333716768 bytes
Database Buffers          905969664 bytes
Redo Buffers                1048576 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

That is all there is to it. Now make sure you have properly set your LOG_ARCHIVE_DEST or it will cause issues later. To see what mode you database is in currently use this SQL:

SELECT LOG_MODE FROM SYS.V$DATABASE;