[root@localhost ~]#su - oracle

[oracle@localhost ~]$ sqlplus / as sysdba

SQL>archive log list;        # 查看是否是归档模式

Database log mode              Archive Mode

Automatic archival            Enabled

Archive destination            /oracle/arch

Oldest online log sequence    6587

Next log sequence to archive  6589

Current log sequence          6589

SQL> alter system set log_archive_start=false scope=spfile;      #禁用自动归档模式

System altered.

SQL>shutdown abort

ORACLE instance shut down.

SQL> startup mount;                      # 打开控制文件，不打开数据文件

ORA-32004: obsoleete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 6727662472 bytes

Fixed Size                  8911752 bytes

Variable Size            2734686208 bytes

Database Buffers        3976200192 bytes

Redo Buffers                7864320 bytes

Database mounted.

SQL> alter database noarchivelog;  # 将数据库切换为非归档模式

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival            Disabled

Archive destination            /oracle/arch

Oldest online log sequence    6588

Current log sequence          6590

SQL>