归档的几个命令的区别:

上一篇 / 下一篇  2007-09-12 00:00:00 / 个人分类:oracle

参考链接:

http://www.itpub.net/showthread.php?threadid=415889&pagenumber=

alter system switch logfile ;
alter system archive log current ;
alter system archive log all ;

Oracle8i Bible上是这样说的
To have Oracle archive the current
redo log files, issue this command:

ALTER SYSTEM ARCHIVE LOG CURRENT;

This command causes Oracle to switch to a new log file. Oracle then archives all redo log files that have not yet been archived. Another approach to this same task is to issue the following two commands:

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM ARCHIVE LOG ALL

The first command forces the log switch, and the second causes Oracle to archive all the redo log files that are full but that haven't been archived yet.



TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-11  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 7740
  • 日志数: 645
  • 建立时间: 2008-01-03
  • 更新时间: 2008-09-23

RSS订阅

Open Toolbar