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