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

切換ORACLE數據庫歸檔非歸檔模式

2013-11-13 22:17:23  來源: Oracle 

  TP系統與AP系統的最大一個區別就是AP系統可能由於數據量較大還有就是他的數據都是有來源的假如真的發生了介質故障或其他問題時都是可以從源再拉數據過來的所以AP通常運行在非歸檔模式下

  [oracle@localhost archive]$ cd

  [oracle@localhost ~]$ sqlplus /nolog

  SQL*Plus: Release Production on Mon Nov ::

  Copyright (c) Oracle  All Rights Reserved

  SQL> conn /as sysdba

  Connected

  SQL> archive log list;

  Database log mode              Archive Mode

  Automatic archival             Enabled

  Archive destination            /u/app/oracle/archive

  Oldest online log sequence    

  Next log sequence to archive  

  Current log sequence          

  SQL> shutdown immediate;

  Database closed

  Database dismounted

  ORACLE instance shut down

  SQL> startup mount;

  ORACLE instance started

  Total System Global Area E+ bytes

  Fixed Size                  bytes

  Variable Size            bytes

  Database Buffers         bytes

  Redo Buffers               bytes

  Database mounted

  SQL> alter database noarchivelog;

  Database altered

  SQL> alter database open;

  Database altered

  SQL> archive log list;

  Database log mode              No Archive Mode

  Automatic archival             Disabled

  Archive destination            /u/app/oracle/archive

  Oldest online log sequence    

  Current log sequence          

  SQL>


From:http://tw.wingwit.com/Article/program/Oracle/201311/18694.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.