切换ORACLE数据库归档非归档模式
发布时间：2010/11/26 16:57:48 来源：城市学习网 编辑：ziteng
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>
