📄 557.html
字号:
<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>论坛精华 >> Oracle 专栏 >> A 7-4 Archiving Redo Log Files</title>
</head>
<body >
<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>
<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=http://www.jsp001.com/list_thread.php?int_attribute=4>论坛精华</a>
>> <a href=http://www.jsp001.com/list_thread.php?forumid=20&int_attribute=4>Oracle 专栏</a>
>> A 7-4 Archiving Redo Log Files [<a href=http://www.jsp001.com/forum/showthread.php?goto=newpost&threadid=557>查看别人的评论</a>]<br>
<hr><p>由 macro 发布于: 2001-03-01 18:49</p><p> </p><p>Decide if Archiving of the Redo log files should be enabled<br><br>NOARCHIVELOG Mode <br><br>In this mode ,the online redo log files are overwritten each time an online redo log file is filled,and log switches occur.LGWR will not overwrite a redo log group until the checkpoint for that group is completed.<br><br>ARCHIVELOG Mode <br><br>If the database is configured to run in ARCHIVELOG mode,<font color=red>inactive</font> groups of filled online redo log files must be archived . Because all changes made to the database are recorded in the online redo log files,the database administrator can use the physical backup and the archived online redo log files to recover the database without losing any committed data.<br><br>There are two ways in which online redo log files can be archived:<br>1.Manually<br>2.Automatically<br><br>The LOG_ARCHIVE_START initialization parameter indicate whether archiving should be automatic or manual when the instance starts up.<br><br>1.TRUE indicates that archiving is automatic,ARCn will initiate archiving of the filled log group at every log switch.<br><br>2.FALSE,<font color=red>the default</font> value,indicates that the database administrator will archive filled redo log files manaully.The database administrator must manually execute a command each time he or she wants to archived an online redo log file.All or specific online redo log files can be archived manually.<br>__________________<br><br>谢谢你抽时间看我的发言，<br><br>Macro Zeng<br><br>==================================<br><br>我正在学习 Oracle ,坚持每天写读书笔记</p></td>
</tr>
</table>
<p>
<CENTER><a href="http://www.jsp001.com/forum/newreply.php?action=newreply&threadid=557">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>6</font> 分，你认为它对你有帮助吗？
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=557&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>1</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=557&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>1</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=557&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>1</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=557&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>1</font>) </p>
<script language="javascript" src="http://www.jsp001.com/include/read_thread_script.php?threadid=557"></script>
<p><CENTER>
Copyright © 2001 - 2009 JSP001.com . All Rights Reserved <P>
<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -