切换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>