Oracle 10g:Put Database in Archive Log Mode.
1.Set the parameters. SQL> alter system set log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile; SQL> alter system set log_archive_dest_1='location=C:\archive' SCOPE=spfile; SQL>alter system set log_archive_start=true scope=spfile; 2.Restart the database. SQL>SHUT IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 612368384 bytes Fixed Size 1250428 bytes Variable Size 171969412 bytes Database Buffers 432013312 bytes Redo Buffers 7135232 bytes Database mounted. 3.Start Archive log Mode. SQL> alter database archivelog; Database altered. 4.Open Database. SQL> alter database open; D