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

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

29

积分

187

好友

71

主题
1#
发表于 2014-4-1 17:47:46 | 查看: 5569| 回复: 4
QQ图片20140401174526.jpg

QQ图片20140401174523.jpg

QQ图片20140401174751.jpg



问题描述
vbox + 2gb内存+ PRM 中遇到ASM analyze问题闪退


直接执行,是:[root@rac1 ParnassusData_PRMforOracle_2001]# ./prm.sh
Byte order: LITTLE ENDIAN
KFBH Check value: 2126801060
Disk ID: 0
Disk name: DG_DATA_0000
Disk group name: DG_DATA
Disk failover group name: DG_DATA_0000
Meta data block size: 4096
AU size: 1048576
Disk size: 5120
kfdhdb.f1b1locn: 2

*****************************************

./prm.sh: line 1:  6626 Aborted                 java -Xms1024M -server -jar prm.jar


cat /proc/meminfo |grep Mem

MemTotal:        2070460 kB
MemFree:         1336284 kB


java -version

java version "1.4.2"
gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-54)

Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.



java的版本是1.4.2 ,且不是ORACLE的JDK




对于该问题 建议使用ORACLE JDK 1.6以上版本,或者至少使用ORACLE JDK 1.4版本
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569   
2#
发表于 2014-4-1 22:05:31
测试了下 oracle自带jdk(1.5.0_51),java修改启动参数,还是报错,明天我试试安装个1.6的jdk。

[root@rac1 ParnassusData_PRMforOracle_2001]# /app/oracle/11.2.0/dbhome_1/jdk/bin/java -version
java version "1.5.0_51"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_51-b10)
Java HotSpot(TM) Client VM (build 1.5.0_51-b10, mixed mode)

[root@rac1 ParnassusData_PRMforOracle_2001]# cat prm.sh
#java -Xms1024M -server -jar  prm.jar
/app/oracle/11.2.0/dbhome_1/jdk/bin/java -Xms1024M -server -jar  prm.jar
#java  -server -jar prm.jar
[root@rac1 ParnassusData_PRMforOracle_2001]# ./prm.sh
Error occurred during initialization of VM
Incompatible initial and maximum heap sizes specified

[root@rac1 ParnassusData_PRMforOracle_2001]# /app/oracle/11.2.0/dbhome_1/jdk/bin/java -Xms1024M -server -jar  prm.jar
Error occurred during initialization of VM
Incompatible initial and maximum heap sizes specified
[root@rac1 ParnassusData_PRMforOracle_2001]#
[root@rac1 ParnassusData_PRMforOracle_2001]#
[root@rac1 ParnassusData_PRMforOracle_2001]#
[root@rac1 ParnassusData_PRMforOracle_2001]# java  -server -jar prm.jar
Byte order: LITTLE ENDIAN
KFBH Check value: 2126801060
Disk ID: 0
Disk name: DG_DATA_0000
Disk group name: DG_DATA
Disk failover group name: DG_DATA_0000
Meta data block size: 4096
AU size: 1048576
Disk size: 5120
kfdhdb.f1b1locn: 2

*****************************************

GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 512000):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 258048):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 512000):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 512000):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 512000):
        May lead to memory leak and poor performance.
GC Warning: Repeated allocation of very large block (appr. size 512000):

回复 只看该作者 道具 举报

3#
发表于 2014-4-4 14:37:24
在Oracle Linux 5.9(x64)上出现ASM analyze 闪退问题,数据库版本10.2.0.5,安装JDK1.6后问题解决。
  1. # java -version
  2. java version "1.4.2"
  3. gij (GNU libgcj) version 4.1.2 20080704 (Red Hat 4.1.2-54)

  4. Copyright (C) 2006 Free Software Foundation, Inc.
  5. This is free software; see the source for copying conditions.  There is NO
  6. warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

  7. # rpm -qa | grep java
  8. java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

  9. # rpm -e --nodeps java-1.4.2-gcj-compat-1.4.2.0-40jpp.115

  10. # yum localinstall --nogpgcheck jdk-6u31-linux-amd64.rpm

  11. # java -version
  12. java version "1.6.0_31"
  13. Java(TM) SE Runtime Environment (build 1.6.0_31-b04)
  14. Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01, mixed mode)
复制代码

回复 只看该作者 道具 举报

4#
发表于 2014-4-4 15:34:43
redhat 自带的gcj java跑PRM 目前是有问题的
不过 就算本地没安装 中文 , 应当也是不影响 PRM的数据搭桥的

回复 只看该作者 道具 举报

5#
发表于 2014-10-31 17:54:05
不错哦,很不错

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-21 02:11 , Processed in 0.053105 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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