557.html
来自「Jsp001精华文章离线版.很不错的,主要是针对JSP的相关内容的」· HTML 代码 · 共 75 行
HTML
75 行
<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 + =
减小字号Ctrl + -
显示快捷键?