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

如何開啟oracle歸檔模式RMAN

2013-11-13 15:50:00  來源: Oracle 

  查看當前歸檔模式

  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          

  重啟數據庫到mount狀態

  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> archive log start;

  Statement processed

  關閉歸檔模式的步驟

  SQL> startup mount;

  SQL> alter database noarchivelog;

  SQL> alter database open;

  i和g的區別

  i中需要修改初始化參數

  log_archive_start = true

  g中已經廢棄該參數


From:http://tw.wingwit.com/Article/program/Oracle/201311/17367.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.