ORACLE10G FROM noarchive mode to archive mode

在init.ora中增加：
log_archive_max_processes=3
log_archive_dest_1='location=/oradata/orcl01/archive/'
log_archive_format="%T%S%r.ARC"

干净关闭数据库：
SQL>shutdown immediate;

用pfile启动到mount状态
SQL>startup mount pfile='/oracle/app/admin/orcl01/pfile/init.ora'

启用archivelog
SQL> alter database archivelog;

打开数据库，查看状态：
SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/orcl01/archive/
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5

重建SPFILE
SQL> create spfile from pfile='/oracle/app/admin/orcl01/pfile/init.ora';

测试一下：
SQL> alter system switch logfile;

System altered.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/orcl01/archive/
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 6

OK!
--------------------------------------
ORACLE10G FROM archive mode to noarchive mode

SQL> shutdown immediate;
SQL> startup mount pfile='/oracle/app/admin/orcl01/pfile/init.ora'
SQL> alter database noarchivelog;
SQL> alter database open;