关闭oracle10g的archive log

 昨天有个测试的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