How to enable ARCHIVELOG MODE?

@ : Home > > Interview Room

If the LOG_ARCHIVE_DEST_n parameters are not set, the archived redo logs will be placed in the FRA. If you want to specify their location and the file name format manually, you can do it as follows

SQL> ALTER SYSTEM SET log_archive_dest_1='/u01/app/oradata/MYDB/archive/' SCOPE=spfile;
SQL> ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

start database and start database in mount mode then enable ARCHIVELOG MODE

sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup mount;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> alter database open;

verify Archive is enabled.

SQL> ARCHIVE LOG LIST;

N.B: It is recommended that you take a full backup after you brought the database in archive log mode.

 

Alert me