oracle開啟/關閉archlog

.管理者身份連接配接資料庫

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

啟動資料庫到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.

database log mode              archive mode

automatic archival             enabled

next log sequence to archive   230

current log sequence  

6.啟動資料庫

sql> alter database open;

database altered

.關閉歸檔模式

oracle instance shut down.

sql> alter database noarchivelog;

sql>