今天做RMAN恢复，数据库为10.2.0.5，从单机到RAC。<br />
<br />
打开数据库的时候出现下面的错误。<br />
<div id="codeText" class="codeText">
<ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number">
<li>
RMAN> alter database open resetlogs;
</li>
<li>
RMAN-00571: ===========================================================
</li>
<li>
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
</li>
<li>
RMAN-00571: ===========================================================
</li>
<li>
RMAN-03002: failure of alter db command at 08/10/2015 09:53:07
</li>
<li>
ORA-00344: unable to re-create online log '/oradata/outdb/redo01.log'
</li>
<li>
ORA-27040: file create error, unable to create file
</li>
<li>
Linux-x86_64 Error: 2: No such file or directory
</li>
</ol>
</div>
查看当前系统redo log路径<br />
<div id="codeText" class="codeText">
<ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number">
<li>
<span style="color:#000000;">SQL<span style="color:#0000CC;">></span> <span style="color:#0000FF;">select</span> <span style="color:#0000CC;">*</span> <span style="color:#0000FF;">from</span> v$logfile<span style="color:#0000CC;">;</span><br />
</span>
</li>
<li>
<br />
</li>
<li>
<span style="color:#0000FF;">GROUP</span><span style="color:#0000FF;">#</span> STATUS <span style="color:#0000FF;">TYPE</span> <span style="color:#0000FF;">MEMBER</span> IS_<br />
</li>
<li>
<span style="color:#FF9900;">---------- ------- ------- -------------------------------------------------- ---</span><br />
</li>
<li>
1 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo01<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
2 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo02<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
3 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo03<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
4 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo04<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
5 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo05<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
6 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo06<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
7 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo07<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
8 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo08<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
9 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo09<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
10 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">/</span>oradata<span style="color:#0000CC;">/</span>outdb<span style="color:#0000CC;">/</span>redo10<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO
</li>
</ol>
</div>
查询结果可以看出日志路径不是ASM里面的路径，所以需要对路径进行修改。<br />
执行下面的语句修改路径：<br />
<div>
<div class="codeheads">
<p>
SQL:
</p>
</div>
<div id="code73" class="codeText">
<ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css">
<li>
<span style="color:#000000;">SQL<span style="color:#0000CC;">></span> <span style="color:#0000FF;">alter</span> <span style="color:#0000FF;">database</span> <span style="color:#0000FF;">rename</span> <span style="color:#0000FF;">file</span> <span style="color:#FF00FF;">'/oradata/outdb/redo01.log'</span> <span style="color:#0000FF;">to</span> <span style="color:#FF00FF;">'+DATADG/otdb/onlinelog/redo01.log'</span><span style="color:#0000CC;">;</span><br />
</span>
</li>
<li>
<span style="color:#0000FF;">alter</span> <span style="color:#0000FF;">database</span> <span style="color:#0000FF;">rename</span> <span style="color:#0000FF;">file</span> <span style="color:#FF00FF;">'/oradata/outdb/redo02.log'</span> <span style="color:#0000FF;">to</span> <span style="color:#FF00FF;">'+DATADG/otdb/onlinelog/redo02.log'</span><span style="color:#0000CC;">;</span><br />
</li>
<li>
<span style="color:#0000FF;">alter</span> <span style="color:#0000FF;">database</span> <span style="color:#0000FF;">rename</span> <span style="color:#0000FF;">file</span> <span style="color:#FF00FF;">'/oradata/outdb/redo03.log'</span> <span style="color:#0000FF;">to</span> <span style="color:#FF00FF;">'+DATADG/otdb/onlinelog/redo03.log'</span><span style="color:#0000CC;">;</span><br />
</li>
<li>
<span style="color:#0000FF;">alter</span> <span style="color:#0000FF;">database</span> <span style="color:#0000FF;">rename</span> <span style="color:#0000FF;">file</span> <span style="color:#FF00FF;">'/oradata/outdb/redo04.log'</span> <span style="color:#0000FF;">to</span> <span style="color:#FF00FF;">'+DATADG/otdb/onlinelog/redo04.log'</span><span style="color:#0000CC;">;</span><br />
</li>
<li>
。。。。。。。。。
</li>
</ol>
</div>
</div>
修改完之后再重新打开数据库，打开正常。<br />
<span style="font-weight:bold;line-height:25px;background-color:#F2F2F2;">open</span>
<div>
<div id="code202" class="codeText">
<ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css">
<li>
[oracle@otdb1 ~]$ sqlplus / as sysdba
</li>
<li>
</li>
<li>
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Aug 10 10:03:01 2015
</li>
<li>
</li>
<li>
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
</li>
<li>
</li>
<li>
</li>
<li>
Connected to:
</li>
<li>
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
</li>
<li>
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
</li>
<li>
</li>
<li>
SQL> alter database open resetlogs;
</li>
<li>
</li>
<li>
Database altered.
</li>
<li>
</li>
<li>
SQL> select open_mode from v$database;
</li>
<li>
</li>
<li>
OPEN_MODE
</li>
<li>
----------
</li>
<li>
READ WRITE
</li>
</ol>
</div>
</div>
最新的日志路径：<br />
<span style="font-weight:bold;line-height:25px;background-color:#F2F2F2;">v$logfile</span>
<div>
<div id="code304" class="codeText">
<ol style="margin:0 1px 0 0px;padding-left:40px;" start="1" class="dp-css">
<li>
<span style="color:#000000;">SQL<span style="color:#0000CC;">></span> <span style="color:#0000FF;">select</span> <span style="color:#0000CC;">*</span> <span style="color:#0000FF;">from</span> v$logfile<span style="color:#0000CC;">;</span><br />
</span>
</li>
<li>
<br />
</li>
<li>
<span style="color:#0000FF;">GROUP</span><span style="color:#0000FF;">#</span> STATUS <span style="color:#0000FF;">TYPE</span> <span style="color:#0000FF;">MEMBER</span> IS_<br />
</li>
<li>
<span style="color:#FF9900;">---------- ------- ------- -------------------------------------------------- ---</span><br />
</li>
<li>
1 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo01<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
2 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo02<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
3 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo03<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
4 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo04<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
5 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo05<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
6 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo06<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
7 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo07<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
8 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo08<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
9 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo09<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO<br />
</li>
<li>
10 <span style="color:#0000FF;">ONLINE</span> <span style="color:#0000CC;">+</span>DATADG<span style="color:#0000CC;">/</span>otdb<span style="color:#0000CC;">/</span>onlinelog<span style="color:#0000CC;">/</span>redo10<span style="color:#0000CC;">.</span><span style="color:#FF0000;">log</span> NO
</li>
</ol>
</div>
</div>
这次过程也提醒我以后做rman恢复时要注意日志的路径，提前修改，避免后面的错误。<br />
<br />
<br />
<br />
<br />
<div style="white-space:nowrap;">
<br />
</div>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8218271/viewspace-2121921/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
没有了~
请登录后发表评论
登录
全部评论
