归档模式必须在数据库mount的状态才能修改，在生产环境中，建库的时候要考虑是否开启归档模式。

SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup nomount ORACLE instance started.

Total System Global Area  838860800 bytes

Fixed Size                  1270268 bytes Variable Size             398462468 bytes Database Buffers          432013312 bytes Redo Buffers                7114752 bytes SQL> alter database mount;

Database altered.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL>

SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     36 Next log sequence to archive   38 Current log sequence           38 SQL> alter system set log_archive_dest_1='location=/archive/';

System altered.

SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------ log_archive_dest                     string log_archive_dest_1                   string      location=/archive/ log_archive_dest_10                  string log_archive_dest_2                   string log_archive_dest_3                   string log_archive_dest_4                   string log_archive_dest_5                   string log_archive_dest_6                   string log_archive_dest_7                   string log_archive_dest_8                   string log_archive_dest_9                   string

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------ log_archive_dest_state_1             string      enable log_archive_dest_state_10            string      enable log_archive_dest_state_2             string      enable log_archive_dest_state_3             string      enable log_archive_dest_state_4             string      enable log_archive_dest_state_5             string      enable log_archive_dest_state_6             string      enable log_archive_dest_state_7             string      enable log_archive_dest_state_8             string      enable log_archive_dest_state_9             string      enable SQL> SQL> show parameter process

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------ aq_tm_processes                      integer     0 db_writer_processes                  integer     1 gcs_server_processes                 integer     0 job_queue_processes                  integer     10 log_archive_max_processes            integer     2 processes                            integer     150 SQL> alter system set log_archive_max_processes=3;

System altered.

SQL> show parameter process

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------ aq_tm_processes                      integer     0 db_writer_processes                  integer     1 gcs_server_processes                 integer     0 job_queue_processes                  integer     10 log_archive_max_processes            integer     3 processes                            integer     150 SQL>

SQL> show parameter log_archive_format

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------ log_archive_format                   string      %t_%s_%r.dbf

SQL> alter database noarchivelog;

Database altered.

SQL> archive log list

Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            /oracle/archive/ Oldest online log sequence     31 Current log sequence           33 SQL>