一个客户归档应用异常,检查alert日志发现如下报错:

Managed Standby Recovery not using Real Time Apply

Parallel Media Recovery started with 4 slaves

Waiting for all non-current ORLs to be archived…

All non-current ORLs have been archived.

Media Recovery Log /Tbackup/orcl/archlog/1_169918_850233689.dbf

Completed: alter database recover managed standby database disconnect from

session

Errors in file /oracle/app/diag/rdbms/rzorcl/orcl/trace/orcl_pr00_28853.trc (incident=

720594):

ORA-00600: internal error code, arguments: [2619], [169918], [], [], [], [], [], [], []

, [], [], []

Incident details in: /oracle/app/diag/rdbms/rzorcl/orcl/incident/incdir_720594/orcl_pr0

0_28853_i720594.trc

Thu Apr 02 12:41:38 2015

Dumping diagnostic data in directory=[cdmp_20150402124138], requested by (instance=1, o

sid=28853 (PR00)), summary=[incident=720594].

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors with log /Tbackup/orcl/archlog/1_169918_850233689.dbf

MRP0: Background Media Recovery terminated with error 600

    在生产库上查找日志,发现1_169918_850233689.dbf 日志已经被删除。

    考虑备库恢复的方法,一个是全库同步,安装目前数据量,需要传输8个多小时,时间较长。

    所以考虑使用rman增量备份恢复:

  1. primary 上查询最小scn号

SELECT CURRENT_SCN FROM V$DATABASE;

 

select min(fhscn) from x$kcvfh;

 

select min(f.fhscn) from x$kcvfh f, v$datafile d where f.hxfil =d.file# and d.enabled !=’READ ONLY’ ;

 

CURRENT_SCN

—————-

7192342317

MIN(FHSCN)

—————-

7192342323

MIN(F.FHSCN)

—————-

7192342323

 

  1. standby 库上查询scn

SELECT CURRENT_SCN FROM V$DATABASE;

 

select min(fhscn) from x$kcvfh;

 

select min(f.fhscn) from x$kcvfh f, v$datafile d where f.hxfil =d.file# and d.enabled !=’READ ONLY’ ;

 

CURRENT_SCN

—————-

7174118626

MIN(FHSCN)

—————-

7174118627

MIN(F.FHSCN)

—————-

7174118627

  1. 在primary上执行,进行rman 备份

    BACKUP INCREMENTAL FROM SCN 7174118626 DATABASE FORMAT ‘/data/rmanbackup/orcl/st_%U’ tag ’st’;

    BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT ‘/data/rmanbackup/orcl/stctl.bck’;

  2. 把文件拷贝到standby 主机

    scp st_* 192.1.1.39:/backup

  3. 在standby主机上,注册备份片

    CATALOG BACKUPPIECE ‘/Tbackup/st_95q3cevb_1_1′;

    CATALOG BACKUPPIECE ‘/Tbackup/st_96q3cf1n_1_1′;

  4. 执行恢复,并且完成之后恢复standby controlfile :

RECOVER DATABASE NOREDO;

RESTORE STANDBY CONTROLFILE FROM ‘/Tbackup/stCTRL.bck’;

  1. 重启standby 库,开始恢复数据。



Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件