ORACLE ARCHIEVE LOG

Enable Archive Log Mode

> sqlplus / as sysdba
SQL> archive log list
SQL> show parameter recovery_file_dest
SQL> archive log list;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list
SQL> alter system switch logfile;

Disable Archive Log Mode

>sqlplus / as sysdba
SQL> archive log list;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> archive log list;