eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« ORA-03113错误解决一例 | Blog首页 | 遥远与安宁-2008新年记事 »

RAC环境下根据sequence恢复指定日志

RAC环境下,可以通过如下命令来恢复备份集中的归档日志。

1.使用From Until语句

restore archivelog from sequence 69346 until sequence 69397 thread 1;
restore archivelog from sequence 75193 until sequence 75263 thread 2;

2.使用Between语句

restore archivelog sequence between 134 and 136 thread 1;
restore archivelog sequence between 56 and 58 thread 2;

关键是要指明Thread参数。


历史上的今天...
      >> 2009-02-07文章:
      >> 2007-02-07文章:
             Oracle10g Events CONTROLF的改变
      >> 2006-02-07文章:
             DBWR enhancements In Oracle10g
      >> 2005-02-07文章:
             如何获得Oracle的隐含参数

By eygle on 2008-02-07 23:43 | Comments (0) | Del.icio.us | Google | Backup&Recovery | Edit |Pageviews:

无觅

搜索本站:

发表留言



CopyRight © 2004~2012 eygle.com, All rights reserved.
数据恢复·紧急救援·联系我们:电话:010-59459859 手机:13911812803 邮件:eygle@eygle.com|MSN联系:eygle@hotmail.com