熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle10g廢棄log

2013-11-13 16:07:44  來源: Oracle 

  在Oracleg中log_archive_start參數已經被廢棄只要啟動數據庫的歸檔模式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/17863.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.