如何启动或关闭Oracle的归档模式

　1.管理员身份连接数据库

　　C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba

　　SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014

　　Copyright (c) 1982, 2010, Oracle. All rights reserved.

　　Connected to:
　　Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
　　With the Partitioning, OLAP, Data Mining and Real Application Testing options
　　2.查看当前归档模式，是归档还是非归档

　　SQL> archive log list;
　　Database log mode No Archive Mode
　　Automatic archival Disabled
　　Archive destination USE_DB_RECOVERY_FILE_DEST
　　Oldest online log sequence 228
　　Current log sequence 230
　　3.关闭数据库

　　SQL> shutdown immediate;
　　Database closed.
　　Database dismounted.
　　ORACLE instance shut down.
　　4.启动数据库到mount状态

　　SQL> startup mount;
　　ORACLE instance started.

　　Total System Global Area 3423965184 bytes
　　Fixed Size 2180544 bytes
　　Variable Size 2013268544 bytes
　　Database Buffers 1392508928 bytes
　　Redo Buffers 16007168 bytes
　　Database mounted.
　　5.启动归档模式

　　SQL> alter database archivelog;

　　Database altered.

　　SQL> archive log list;
　　Database log mode Archive Mode
　　Automatic archival Enabled
　　Archive destination USE_DB_RECOVERY_FILE_DEST
　　Oldest online log sequence 228
　　Next log sequence to archive 230
　　Current log sequence 230
　　6.启动数据库

　　SQL> alter database open;
　　Database altered.
　　7.关闭归档模式

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

　　Total System Global Area 3423965184 bytes
　　Fixed Size 2180544 bytes
　　Variable Size 2013268544 bytes
　　Database Buffers 1392508928 bytes
　　Redo Buffers 16007168 bytes
　　Database mounted.
　　SQL> alter database noarchivelog;

　　Database altered.

　　SQL> archive log list;
　　Database log mode No Archive Mode
　　Automatic archival Disabled
　　Archive destination USE_DB_RECOVERY_FILE_DEST
　　Oldest online log sequence 228
　　Current log sequence 230
　　SQL>

启动：
关闭数据库 SQL> shutdown immediate;
启动数据库到mount状态 SQL> startup mount;
启动归档模式 SQL> alter database archivelog;
启动数据库 SQL> alter database open;

关闭
关闭数据库SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
archive log list;

在sqlplus下执行