- 论坛徽章:
- 0
|
<span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: small; "><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; ">一、归档的启用,停用和自动归档</p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; ">1、启用和停用archivelog</p><br><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><span lang="EN-US"><font face="宋体"></font></span></p><table cellspacing="0" cellpadding="0" width="955" border="0" style="border-collapse: collapse; "><tbody><tr height="20"><td class="xl25" width="955" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; width: 716pt; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">C:Documents and SettingsAdministrator>sqlplus "/ as sysdba"</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic">SQL*Plus: Release 9.0.1.0.1 - Production on </font><font class="font5">星期日</font><font class="font8" face="Arial Baltic"> 7</font><font class="font5">月</font><font class="font8" face="Arial Baltic"> 23 23:48:19 2006</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">(c) Copyright 2001 Oracle Corporation. All rights reserved.</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">连接到<font class="font8" face="Arial Baltic">:</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">With the Partitioning option</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">JServer Release 9.0.1.1.1 - Production</font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><span lang="EN-US"><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>archive log list </strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><font class="font7" color="#ff0000"><strong>此处是显示当前的归档模式</strong></font></span></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">数据库日志模式<font class="font8" face="Arial Baltic"> </font><font class="font5">存档模式</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">自动存档<font class="font8" face="Arial Baltic"> </font><font class="font5">启用</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">存档终点<font class="font8" face="Arial Baltic"> D:oracleora90RDBMS</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">最早的概要日志序列<font class="font8" face="Arial Baltic"> 171</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">下一个存档日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">当前日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><span lang="EN-US"><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>shutdown immediate</strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><font class="font7" color="#ff0000"><strong>关闭数据库</strong></font></span></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">数据库已经关闭。</font></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">已经卸载数据库。</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic">ORACLE </font><font class="font5">例程已经关闭。</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><span lang="EN-US"><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>startup mount</strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><strong><font color="#ff0000"><font class="font7">启动到</font><font class="font10" face="Arial Baltic">mount</font><font class="font7">状态</font></font></strong></span></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><span lang="EN-US"><font color="#00ff00"><font face="Arial Baltic">ORACLE </font><font class="font5">例程已经启动。</font></font></span></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic"><span lang="EN-US">Total System Global Area 118255568 bytes</span></font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">Fixed Size 282576 bytes</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">Variable Size 83886080 bytes</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">Database Buffers 33554432 bytes</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">Redo Buffers 532480 bytes</font></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">数据库装载完毕。</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><span lang="EN-US"><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>alter database noarchivelog</strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><font class="font7" color="#ff0000"><strong>关闭数据库的归档状态(因为原来是打开的,现在设置成关闭)</strong></font></span></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic">2 ;</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">数据库已更改。</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic"><span lang="EN-US">sys@oralocal>archive log list</span></font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">数据库日志模式<font class="font8" face="Arial Baltic"> </font><font class="font5">非存档模式</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">自动存档<font class="font8" face="Arial Baltic"> </font><font class="font5">禁用</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">存档终点<font class="font8" face="Arial Baltic"> D:oracleora90RDBMS</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">最早的概要日志序列<font class="font8" face="Arial Baltic"> 171</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">当前日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>alter database archivelog</strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><font class="font7" color="#ff0000"><strong>开启归档模式</strong></font><font class="font8" face="Arial Baltic" color="#00ff00"></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic">2 ;</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">数据库已更改。</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00"><font face="Arial Baltic"><span lang="EN-US">sys@oralocal>archive log list</span></font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">数据库日志模式<font class="font8" face="Arial Baltic"> </font><font class="font5">存档模式</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">自动存档<font class="font8" face="Arial Baltic"> </font><font class="font5">禁用</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">存档终点<font class="font8" face="Arial Baltic"> D:oracleora90RDBMS</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">最早的概要日志序列<font class="font8" face="Arial Baltic"> 171</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">下一个存档日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">当前日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="21"><td class="xl25" height="21" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15.75pt; background-color: black; "><font face="Arial Baltic"><font color="#00ff00">sys@oralocal><font class="font9"><strong>archive log start</strong></font></font><font class="font10" color="#ff0000"><strong>——</strong></font></font><font class="font7" color="#ff0000"><strong>开启自动归档模式</strong></font></td></tr><tr height="19"><td class="xl24" height="19" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 14.25pt; background-color: black; "><font color="#00ff00">已处理的语句</font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00">sys@oralocal>archive log list</font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">数据库日志模式<font class="font8" face="Arial Baltic"> </font><font class="font5">存档模式</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">自动存档<font class="font8" face="Arial Baltic"> </font><font class="font5">启用</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">存档终点<font class="font8" face="Arial Baltic"> D:oracleora90RDBMS</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">最早的概要日志序列<font class="font8" face="Arial Baltic"> 171</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">下一个存档日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="20"><td class="xl24" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font color="#00ff00">当前日志序列<font class="font8" face="Arial Baltic"> 173</font></font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><font face="Arial Baltic" color="#00ff00"> </font></td></tr><tr height="20"><td class="xl25" height="20" style="border-right-color: rgb(212, 208, 200); border-right-width: initial; border-right-style: initial; border-top-color: rgb(212, 208, 200); border-top-width: initial; border-top-style: initial; border-left-color: rgb(212, 208, 200); border-left-width: initial; border-left-style: initial; border-bottom-color: rgb(212, 208, 200); border-bottom-width: initial; border-bottom-style: initial; height: 15pt; background-color: black; "><span lang="EN-US"><font face="Arial Baltic" color="#00ff00">sys@oralocal></font></span></td></tr></tbody></table><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><span lang="EN-US"><font face="宋体">2、设置自动归档随数据库一起启动</font></span></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><font face="宋体">停库后修改<span lang="EN-US">init.ora文件,添加一行:</span></font></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><font face="宋体"><em><b><span lang="EN-US">log_archive_start=true</span></b></em></font></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><font face="宋体">重启数据库。</font></p><p style="margin-top: 7px; margin-bottom: 7px; overflow-x: auto; overflow-y: auto; "><font face="宋体">二、归档的作用:做增量的热备</font></p></span> |
|