How to Enable Archive log Mode

If you are using an spfile



With the database open, issue
ALTER SYSTEM SET log_archive_start = true SCOPE=spfile;
ALTER SYSTEM SET log_archive_dest_1 = "location=D:\Oracle\oradata\orcl\archive" SCOPE=spfile;
ALTER SYSTEM SET log_archive_format = %%ORACLE_SID%%T%TS%S.ARC SCOPE spfile;


Then do the shutdown and mount the database.


connect sys/<pwd> as sysdba
startup mount;
ALTER DATABASE ARCHIVELOG; 
ALTER DATABASE OPEN; 
ALTER SYSTEM SWITCH LOGFILE; (To force the archive generation)
archive log list ; (for see that database is runing on archive or not)




If you are using a pfile


shutdown the database
in the INIT<SID>.ORA set
log_archive_start = true
log_archive_dest_1 = "location=D:\Oracle\oradata\orcl\archive" 
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC


Then do the shutdown and mount the database.


connect sys/<pwd> as sysdba
startup mount;
ALTER DATABASE ARCHIVELOG; 
ALTER DATABASE OPEN; 
ALTER SYSTEM SWITCH LOGFILE; (To force the archive generation) 
archive log list(for see that database is runing on archive or not)