Enable/Disable Archive Log Mode Oracle 10g/11g
A very very very good and clear explanation from here : http://www.oracledistilled.com/oracle-database/backup-and-recovery/enabledisable-archive-log-mode-10g11g/ To Disable: sqlplus / as sysdba shutdown immediate startup mount alter database noarchivelog; alter database open ; archive log list; To Enable: sqlplus / as sysdba archive log list show parameter recovery_file_dest alter system set log_archive_dest_1= 'LOCATION=/path/orcl/arch' scope = both; shutdown immediate startup mount alter database archivelog; alter database open ; archive log list //alak