ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 归档的几个命令的区别:

归档的几个命令的区别:

原创 Linux操作系统 作者:lfree 时间:2007-09-12 00:00:00 0 删除 编辑

参考链接:

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.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-83092/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 函数lnnvl
请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2485
  • 访问量
    6290633