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;

Database altered.

SQL> alter system switch logfile;

END;