oracle查看是否归档模式 在Oracle10g里启动自动归档模式

在Oracle10g里启动自动归档模式  

在Oracle g中 只要启动数据库的归档模式 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 ProductionWith the Partitioning and Data Mining optionsSQL> archive log list;Database log mode              No Archive ModeAutomatic archival             DisabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     Current log sequence           SQL> show parameter log_archive_startNAME                                 TYPE        VALUE log_archive_start                    boolean     FALSESQL> shutdown immediate;Database closed Database dismounted ORACLE instance shut down SQL> startup mount;ORACLE instance started Total System Global Area bytesFixed Size                  bytesVariable Size             bytesDatabase Buffers         bytesRedo Buffers                bytesDatabase mounted SQL> alter database archivelog;Database altered SQL> alter database open;Database altered SQL> archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     Next log sequence to archive   Current log sequence           SQL> lishixinzhi/Article/program/Oracle/201311/18619