standby缺损归档的处理

最新推荐文章于 2021-05-19 18:11:12 发布

娜然

最新推荐文章于 2021-05-19 18:11:12 发布

阅读量578

点赞数

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.csdn.net/nanaranran/article/details/30469013

版权

oracle 专栏收录该内容

83 篇文章 1 订阅

订阅专栏

邮件收到standby错误的信息，查看备库：

sys@c1> select * from v$archive_gap;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 61715 61715

手动从主库拷贝过来，进行注册：

RMAN> catalog archivelog '/oradata2/c1/archivelog/2014_06_12/o1_mf_1_61715_9slq84y2_.arc';

然后备库就可以自动应用了，看日志：

Fri Jun 13 09:16:09 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61715_9slq84y2_.arc
Fri Jun 13 09:16:21 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61716_9slr9tpp_.arc
Fri Jun 13 09:16:44 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61717_9slrg9y9_.arc
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61718_9slx3fdc_.arc
Fri Jun 13 09:17:44 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61719_9sm1k7p1_.arc
Fri Jun 13 09:18:32 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61720_9sm5d1rd_.arc
Fri Jun 13 09:19:12 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61721_9sm9384o_.arc
Fri Jun 13 09:19:54 CST 2014
Media Recovery Log /oradata2/c1/archivelog/2014_06_12/o1_mf_1_61722_9smfj3vb_.arc

如需转载，请注明出处：http://blog.csdn.net/nanaranran/article/details/30469013