Summary of enabling and disabling Oracle 9i Database Archive

Enable archive Mode
SQL> shutdown immediate;

SQL> startup Mount;

SQL> alter system set log_archive_dest_1 = "location = D: \ oracle \ oradata \ archivelog" Scope = spfile;

SQL> alter system set log_archive_start = true scope = spfile;

Restart the database to make the preceding two parameters take effect.

SQL> shutdown immediate;

SQL> startup Mount;

SQL> alter database archivelog;

SQL> archive log start;

SQL> archive log list;

SQL> alter database open;
Check status
SQL> archive log list;

Stop archive Mode
SQL> shutdown immediate;

SQL> startup Mount;

SQL> alter database noarchivelog;

SQL> alter system set log_archive_start = false scope = spfile;

SQL> alter database open;
Check status
SQL> archive log list;