当前位置导航:炫浪网>>网络学院>>编程开发>>Oracle教程

Oracle10g废弃log_archive_start参数


  在Oracle10g中,log_archive_start参数已经被废弃,只要启动数据库的归档模式,Oracle就会启用自动归档,从而避免了10g以前由于用户疏忽所带来的一系列问题。
  $ sqlplus "/ as sysdba"
  
  SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 09:53:25 2005
  
  Copyright (c) 1982, 2004, Oracle. All rights reserved.
  
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit 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   25
  Current log sequence      27
  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 3204448256 bytes
  Fixed Size         1304912 bytes
  Variable Size       651957936 bytes
  Database Buffers     2550136832 bytes
  Redo Buffers        1048576 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   25
  Next log sequence to archive  27
  Current log sequence      27
  SQL>
  ~
  -----
相关内容
赞助商链接