昨天有个测试的DB，做性能测试，产生了大量的archive log，磁盘空间都用完了。

反正是一般的测试环境，就决定取消archive log。步骤如下：

$ sqlplus "/as sysdba"

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u02/archive/cfgdb

Oldest online log sequence     7942

Next log sequence to archive   7944

Current log sequence           7944

SQL>

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter system archive log stop;

SQL> alter database noarchivelog;

SQL> alter database open;

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /u02/archive/cfgdb

Oldest online log sequence     7942

Current log sequence           7944

SQL> exit