ITPUB论坛-中国最专业的IT技术社区

 
 注册
热搜:
查看: 914|回复: 4

[体系架构] 请教一个DG的问题,主库的归档传送到了备库并注册,但不应用

[复制链接]
论坛徽章:
0
跳转到指定楼层
1#
发表于 2017-11-15 15:30 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
中午发现,一套DG三个备库有两个备库的归档已经传送过来,但是无法在备库应用。请教各位大神SQL> select process,status from gv$managed_standby;

PROCESS            STATUS
------------------ ------------------------
ARCH               CLOSING
ARCH               CONNECTED
ARCH               CONNECTED
ARCH               CLOSING
RFS                IDLE
RFS                IDLE
RFS                IDLE
RFS                IDLE
MRP0               APPLYING_LOG

已选择9行。

SEQUENCE# ARCHIV APPLIED
---------- ------ ------------------
     70493 YES    YES
     70494 YES    YES
     70495 YES    YES
     70496 YES    YES
     70497 YES    YES
     70498 YES    YES
     70499 YES    YES
     70500 YES    YES
     70501 YES    NO
     70502 YES    NO
     70503 YES    NO



所需的归档都在

  1* select name,sequence# from v$archived_log where SEQUENCE# > 70500
SQL> //

NAME                                                                              SEQUENCE#
-------------------------------------------------------------------------------- ----------
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70501_f0pfrbh1_.arc           70501
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70502_f0phcbxf_.arc           70502
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70503_f0pjtp2b_.arc           70503
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70504_f0pkkjlt_.arc           70504
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70505_f0pl45q6_.arc           70505
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70506_f0pmpzvb_.arc           70506
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70507_f0po37wd_.arc           70507
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70508_f0ppfd5r_.arc           70508
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70509_f0ppt3l8_.arc           70509
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70510_f0pq5zgf_.arc           70510
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70511_f0pqkhqq_.arc           70511
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70512_f0pqx6o9_.arc           70512
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70513_f0pr83j0_.arc           70513
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70514_f0prn307_.arc           70514
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70515_f0pscvcq_.arc           70515
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70516_f0ptnfrx_.arc           70516
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70517_f0pvkjss_.arc           70517
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70518_f0pwdfwl_.arc           70518
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70519_f0pxbcqb_.arc           70519
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70520_f0py4kml_.arc           70520
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70521_f0pysfqd_.arc           70521
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70522_f0pzl77k_.arc           70522
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70523_f0q1shdf_.arc           70523
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70524_f0q9fcyz_.arc           70524
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70525_f0qfxq2p_.arc           70525
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70526_f0qg6fhc_.arc           70526
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70527_f0qgoy9q_.arc           70527
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70528_f0qgx9vv_.arc           70528
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70529_f0qnhk4p_.arc           70529
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70530_f0qnv7d0_.arc           70530
/oracle/archivelog/SYZM_S/archivelog/2017_11_15/o1_mf_1_70531_f0qtfnpx_.arc           70531


应用时间点的alertlog
RFS[33]: Selected log 12 for thread 1 sequence 70500 dbid 2118740538 branch 859045500
Wed Nov 15 00:09:03 2017
Archived Log entry 93407 added for thread 1 sequence 70499 ID 0x814d26cc dest 1:
Wed Nov 15 00:09:03 2017
Media Recovery Waiting for thread 1 sequence 70500 (in transit)
Recovery of Online Redo Log: Thread 1 Group 12 Seq 70500 Reading mem 0
  Mem# 0: /oracle/oradata/syzm/standby13.log
  Mem# 1: /oracle/oradata/syzm/standby14.log
Wed Nov 15 02:16:42 2017
RFS[33]: Selected log 11 for thread 1 sequence 70501 dbid 2118740538 branch 859045500
Wed Nov 15 02:16:43 2017
Media Recovery Waiting for thread 1 sequence 70501 (in transit)
Recovery of Online Redo Log: Thread 1 Group 11 Seq 70501 Reading mem 0
  Mem# 0: /oracle/oradata/syzm/standby11.log
  Mem# 1: /oracle/oradata/syzm/standby12.log
Wed Nov 15 02:16:43 2017

。。。。
。。。
Wed Nov 15 05:24:15 2017
Errors in file /oracle/diag/rdbms/syzm_s/syzm/trace/syzm_pr05_8881.trc  (incident=680265):
ORA-00600: 内部错误代码, 参数: [3020], [3], [249], [12583161], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 249, file offset is 2039808 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 数据文件 3: '/oracle/oradata/syzm/undotbs1.258.859045417'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /oracle/diag/rdbms/syzm_s/syzm/incident/incdir_680265/syzm_pr05_8881_i680265.trc
Wed Nov 15 05:24:20 2017
Dumping diagnostic data in directory=[cdmp_20171115052420], requested by (instance=1, osid=8881 (PR05)), summary=[incident=680265].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file /oracle/diag/rdbms/syzm_s/syzm/trace/syzm_pr05_8881.trc:
ORA-00600: 内部错误代码, 参数: [3020], [3], [249], [12583161], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 249, file offset is 2039808 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 数据文件 3: '/oracle/oradata/syzm/undotbs1.258.859045417'
ORA-10560: block type 'KTU UNDO BLOCK'
Wed Nov 15 05:24:21 2017
Errors in file /oracle/diag/rdbms/syzm_s/syzm/trace/syzm_mrp0_8857.trc  (incident=680217):
ORA-00600: 内部错误代码, 参数: [3020], [3], [249], [12583161], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 249, file offset is 2039808 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 数据文件 3: '/oracle/oradata/syzm/undotbs1.258.859045417'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /oracle/diag/rdbms/syzm_s/syzm/incident/incdir_680217/syzm_mrp0_8857_i680217.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Recovery Slave PR05 previously exited with exception 600
Wed Nov 15 05:24:22 2017
MRP0: Background Media Recovery terminated with error 448
Errors in file /oracle/diag/rdbms/syzm_s/syzm/trace/syzm_pr00_8871.trc:
ORA-00448: 后台进程正常结束
Managed Standby Recovery not using Real Time Apply
Dumping diagnostic data in directory=[cdmp_20171115052422], requested by (instance=1, osid=8857 (MRP0)), summary=[incident=680217].
Recovery interrupted!
Recovered data files to a consistent state at change 2967629937
Wed Nov 15 05:24:24 2017
Sweep [inc][680265]: completed
MRP0: Background Media Recovery process shutdown (syzm)


论坛徽章:
180
红宝石
日期:2014-05-09 08:24:37萤石
日期:2014-01-03 10:25:39马上有车
日期:2014-02-18 16:41:11马上有钱
日期:2014-11-24 15:17:08马上有钱
日期:2014-11-12 09:33:24马上有房
日期:2014-11-07 08:46:05马上有钱
日期:2014-10-27 09:26:57马上有对象
日期:2014-10-28 10:28:08itpub13周年纪念徽章
日期:2014-10-10 10:38:25马上有对象
日期:2015-01-14 17:33:15
2#
发表于 2017-11-15 17:11 | 只看该作者
alert不是告诉你错误了吗?
从主库拷贝到备库
/oracle/oradata/syzm/undotbs1.258.859045417

使用道具 举报

回复
论坛徽章:
180
红宝石
日期:2014-05-09 08:24:37萤石
日期:2014-01-03 10:25:39马上有车
日期:2014-02-18 16:41:11马上有钱
日期:2014-11-24 15:17:08马上有钱
日期:2014-11-12 09:33:24马上有房
日期:2014-11-07 08:46:05马上有钱
日期:2014-10-27 09:26:57马上有对象
日期:2014-10-28 10:28:08itpub13周年纪念徽章
日期:2014-10-10 10:38:25马上有对象
日期:2015-01-14 17:33:15
3#
发表于 2017-11-15 17:13 | 只看该作者
如果你的备库能连接到备份,可以使用rman的块修复看看.

recover datafile 3 block 249;
blockrecover datafile 3 block 249;

使用道具 举报

回复
论坛徽章:
180
红宝石
日期:2014-05-09 08:24:37萤石
日期:2014-01-03 10:25:39马上有车
日期:2014-02-18 16:41:11马上有钱
日期:2014-11-24 15:17:08马上有钱
日期:2014-11-12 09:33:24马上有房
日期:2014-11-07 08:46:05马上有钱
日期:2014-10-27 09:26:57马上有对象
日期:2014-10-28 10:28:08itpub13周年纪念徽章
日期:2014-10-10 10:38:25马上有对象
日期:2015-01-14 17:33:15
4#
发表于 2017-11-15 17:15 | 只看该作者
lfree 发表于 2017-11-15 17:11
alert不是告诉你错误了吗?
从主库拷贝到备库
/oracle/oradata/syzm/undotbs1.258.859045417

使用rman:
backup as copy datafile 3 ;
然后想办法拷贝到备库(在关闭备库的情况下).

使用道具 举报

回复
论坛徽章:
0
5#
 楼主| 发表于 2017-11-15 17:17 | 只看该作者
lfree 发表于 2017-11-15 17:11
alert不是告诉你错误了吗?
从主库拷贝到备库
/oracle/oradata/syzm/undotbs1.258.859045417

在排查什么原因导致,已经恢复了

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 |
  | | |
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
 北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表