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

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

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

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参数。


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

By eygle on 2008-02-07 23:43 | Comments (0) | Backup&Recovery | 2180 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com