Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

6

主题
1#
发表于 2014-12-9 15:27:56 | 查看: 4692| 回复: 5
OS:AIX 6.1
DB: 11.2.0.3 64bit single
在数据库restore的过程中意外报错,报错信息如下
released channel: ch00
released channel: ch01
released channel: ch02
released channel: ch03
released channel: ch04
released channel: ch05
released channel: ch06
released channel: ch07
released channel: ch08
released channel: ch10
released channel: ch11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/09/2014 14:40:32
RMAN-10038: database session for channel ch09 terminated unexpectedly

数据库后台日志如下:
space available in the underlying filesystem or ASM diskgroup.
Tue Dec 09 14:39:02 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1159B6000] [PC:0x105922148, kgcdm()+5320] [flags: 0x0, count: 1]
Errors in file /u01/oracle/diag/rdbms/ywdb/ywdb/trace/ywdb_ora_1770316.trc  (incident=12330):
ORA-07445: exception encountered: core dump [kgcdm()+5320] [SIGSEGV] [ADDR:0x1159B6000] [PC:0x105922148] [Address not mapped to object] []
Incident details in: /u01/oracle/diag/rdbms/ywdb/ywdb/incident/incdir_12330/ywdb_ora_1770316_i12330.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Dec 09 14:39:04 2014
Dumping diagnostic data in directory=[cdmp_20141209143904], requested by (instance=1, osid=1770316), summary=[incident=12330].
Tue Dec 09 14:39:07 2014
Sweep [inc][12330]: completed
Sweep [inc2][12330]: completed
Tue Dec 09 14:45:28 2014
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [2.27%] pct of memory swapped out [0.13%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.



trace文件及restore见附件

麻烦各位大神给点思路

trc.zip

477.02 KB, 下载次数: 1089

日志

2#
发表于 2014-12-9 16:02:48
kgcddo =>  kgcdbz2pseudodo => kgcdbz2do

kgcddo_f - Decompression do function

应当是在解压过程中遇到了问题

回复 只看该作者 道具 举报

3#
发表于 2014-12-9 16:02:50
kgcddo =>  kgcdbz2pseudodo => kgcdbz2do

kgcddo_f - Decompression do function

应当是在解压过程中遇到了问题

回复 只看该作者 道具 举报

4#
发表于 2014-12-9 16:09:22
Liu Maclean(刘相兵 发表于 2014-12-9 16:02
kgcddo =>  kgcdbz2pseudodo => kgcdbz2do

kgcddo_f - Decompression do function

备份的时候是压缩的,那刘大遇到这问题该怎么解决呢?谢谢

回复 只看该作者 道具 举报

5#
发表于 2014-12-9 19:54:14
这个问题你提一个SR 吧, 或者尝试再次备份一个压缩的看是否能恢复。  怀疑备份的文件可能存在损坏或其他问题导致解压时出现意外。

回复 只看该作者 道具 举报

6#
发表于 2014-12-9 20:09:55
Liu Maclean(刘相兵 发表于 2014-12-9 19:54
这个问题你提一个SR 吧, 或者尝试再次备份一个压缩的看是否能恢复。  怀疑备份的文件可能存在损坏或其他问 ...

好的,谢谢刘大回复

回复 只看该作者 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-20 00:13 , Processed in 0.054208 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569