VMCD.ORG

Focus on database architecture

Fractured blocks when Rman backup is running

Posted by admin on February 20th, 2012

系统alert在主库出现下面错误 OS为linux 5.5

Stopping background process CJQ0
Sat Feb 11 03:41:07 2012
Hex dump of (file 9, block 561424) in trace file /data/oracle/diag/rdbms/yhdstd/yhddb1/trace/yhddb1_ora_11327.trc
Corrupt block relative dba: 0x02489110 (file 9, block 561424)
Fractured block found during backing up datafile
Data in bad block:
 type: 6 format: 2 rdba: 0x02489110
 last change scn: 0x0007.a9d2831f seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xe6b90601
 check value in block header: 0x8c60
 computed block checksum: 0x82af
Reread of blocknum=561424, file=/data/oracle/oradata/yhddb1/md_data01.dbf. found valid data

这个情况在9i比较常见,rman备份时datafile 正在处在剧烈的io操作,如大批量的写入等等,oracle判断此块为Fractured,但是这并不是真正意义上的Corrupt[……]

Read more

Tags:
Posted in backup, oracle, replication | No Comments »

[转] 11g Release 2 RMAN Backup Compression

Posted by admin on December 16th, 2011

11g Release 2 RMAN Backup Compression
Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data[……]

Read more

Tags:
Posted in 11g, backup, oracle | No Comments »

NBU 异机恢复测试

Posted by admin on October 19th, 2011

一、搭建恢复测试环境

安装操作系统
操作系统安装,过程略

硬件配置:
# hostname
nbutest
#prtconf
System Model: IBM,7026-B80
Machine Serial Number: 10960AF
Processor Type:[……]

Read more

Tags:
Posted in backup | 8 Comments »

Ovpass 创建步骤

Posted by admin on October 17th, 2011

ovpass创建步骤
1、找出对应的光纤卡(粗体字),此处为fscsi1:
[21:58:27 root@billdg /]# lsdev -C |grep I/O
fscsi0 Available 03-00-02 FC SCSI I/O Controller Protocol De[……]

Read more

Tags:
Posted in backup | No Comments »

exchange 备份错误

Posted by admin on October 17th, 2011

错误状态:

之前备份都正常,日志正常清除,NBU配置都正常,找不出可更改选项。
备份时报如下错误,且日志不能清除,造成系统空间报警:
2010-9-3 18:32:41 – Error bpbrm(pid=876580) 从客户端 SHHQ-Mail13: 出错 – failure rea[……]

Read more

Tags:
Posted in backup | 2 Comments »