切换ORACLE数据库归档非归档模式

    TP系统与AP系统的最大一个区别就是AP系统可能由于数据量较大，还有就是他的数据都是有来源的，假如真的发生了介质故障或其他问题时都是可以从源再拉数据过来的，所以AP通常运行在非归档模式下。
[oracle@localhost archive]$ cd [oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Nov 22 11:11:14 2010
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
SQL> conn /as sysdba Connected. SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /u01/app/oracle/archive Oldest online log sequence     109 Next log sequence to archive   111 Current log sequence           111 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started.
Total System Global Area 1.0737E+10 bytes Fixed Size                  2090600 bytes Variable Size            1560283544 bytes Database Buffers         9160359936 bytes Redo Buffers               14684160 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            /u01/app/oracle/archive Oldest online log sequence     109 Current log sequence           111 SQL>