standby缺损归档的处理

来源：互联网发布：淘宝手机营销软件编辑：程序博客网时间：2024/04/29 20:39

邮件收到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

0 0