在Oracleg中log_archive_start参数已经被废弃只要启动数据库的归档模式Oracle就会启用自动归档从而避免了g以前由于用户疏忽所带来的一系列问题
$ sqlplus / as sysdba
SQL*Plus: Release Production on Wed Apr ::
Copyright (c) OracleAll 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 modeNo Archive Mode
Automatic archival Disabled
Archive destinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
Current log sequence
SQL> show parameter log_archive_start
NAME TYPEVALUE
log_archive_startboolean 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 modeArchive Mode
Automatic archival Enabled
Archive destinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
Next log sequence to archive
Current log sequence
SQL>
~