Oracle啟動或關閉歸檔模式

標籤：alt   開發環境   1.2   log   11.2   bash   automatic   11g   cells   

在Oracle安裝後，預設歸檔模式開啟，大量的日誌會瞬間填滿磁碟，所以在開發環境，經常需要關閉歸檔模式。

1.管理員身份串連資料庫

$sqlplus user/passwd@dbname as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014Copyright (c) 1982, 2010, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options

 

2.查看當前歸檔模式，是歸檔還是非歸檔

SQL> archive log list;Database log mode              No Archive ModeAutomatic archival             DisabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     228Current 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 bytesFixed Size                  2180544 bytesVariable Size            2013268544 bytesDatabase Buffers         1392508928 bytesRedo Buffers               16007168 bytesDatabase mounted.

 

5.啟動歸檔模式

 

SQL> alter database archivelog; Database altered. SQL> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     228Next log sequence to archive  230Current 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 bytesFixed Size                  2180544 bytesVariable Size            2013268544 bytesDatabase Buffers         1392508928 bytesRedo Buffers               16007168 bytesDatabase mounted.SQL> alter database noarchivelog; Database altered. SQL> archive log list;Database log mode              No Archive ModeAutomatic archival             DisabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     228Current log sequence          230

Oracle啟動或關閉歸檔模式