在Oracle10g裡啟動自動歸檔模式

在Oracleg中只要啟動數據庫的歸檔模式Oracle就會啟用自動歸檔從而避免了g以前由於用戶疏忽所帶來的一系列問題

$ sqlplus / as sysdba

SQL*Plus: Release Production on Wed Apr ::

Copyright (c) Oracle  All rights reserved


Connected to:
Oracle Database g Enterprise Edition Release bit Production
With the Partitioning and Data Mining options

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence    
Current log sequence          
SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE

log_archive_start                    boolean     FALSE
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down

SQL> startup mount;
ORACLE instance started

Total System Global Area bytes
Fixed Size                  bytes
Variable Size             bytes
Database Buffers         bytes
Redo Buffers                bytes
Database mounted
SQL> alter database archivelog;

Database altered

SQL> alter database open;

Database altered

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence    
Next log sequence to archive  
Current log sequence          
SQL>

From:http://tw.wingwit.com/Article/program/Oracle/201311/18619.html