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

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

0

积分

1

好友

8

主题
1#
发表于 2014-10-31 15:33:55 | 查看: 4626| 回复: 3
version:crs   11.1.0.6.0
            linux oracle linux 5.4

没有创建数据库,只安装了CRS和RDBMS HOME。

LINUX启动和使用crsctl start crs,crsctl start resource都能启动相关resource,但是过几分钟vip就offline,LINUX自动重启。
OCR权限(raw2):
[root@ocm1 bin]# ls -l /dev/raw
total 0
crw-r----- 1 oracle dba 162, 1 Oct 31 14:36 raw1
crw-r----- 1 oracle dba 162, 2 Oct 31 15:03 raw2
crw-r----- 1 oracle dba 162, 3 Oct 31 15:21 raw3

[oracle@ocm2 raw]$ ls -l /dev/raw
total 0
crw-r----- 1 oracle dba 162, 1 Oct 31 14:45 raw1
crw-r----- 1 oracle dba 162, 2 Oct 31 14:45 raw2
crw-r----- 1 oracle dba 162, 3 Oct 31 15:20 raw3

两个节点ocrcheck:
Status of Oracle Cluster Registry is as follows :
         Version                  :          2
         Total space (kbytes)     :  262124272
         Used space (kbytes)      :       2024
         Available space (kbytes) :  262122248
         ID                       :  837110435
         Device/File Name         : /dev/raw/raw2
                                    Device/File integrity check succeeded

                                    Device/File not configured

         Cluster registry integrity check succeeded

crsd cssd和linux日志都在附件中,请帮忙看看。

node1 log.zip

201.02 KB, 下载次数: 1172

node2 log.zip

307.47 KB, 下载次数: 1124

2#
发表于 2014-10-31 15:59:18
2014-10-31 14:37:41.822: [  OCRRAW]proprutrbuf: the offset passed is invalid [4096]. Pointer will NOT be incremented.
2014-10-31 14:37:41.822: [  OCRRAW]proprutrbuf: the offset passed is invalid [4096]. Pointer will NOT be incremented.
2014-10-31 14:37:41.822: [  OCRRAW]proprutrbuf: the offset passed is invalid [4096]. Pointer will NOT be incremented.
2014-10-31 14:37:41.822: [  OCRRAW]proprutrbuf: the offset passed is invalid [4096]. Pointer will NOT be incremented.



Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/hdc, opened
Oct 31 14:37:16 ocm1 kernel: hdc: drive_cmd: status=0x51 { DriveReady SeekComplete Error }
Oct 31 14:37:16 ocm1 kernel: hdc: drive_cmd: error=0x04 { AbortedCommand }
Oct 31 14:37:16 ocm1 kernel: ide: failed opcode was: 0xec
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/hdc, not ATA, no IDENTIFY DEVICE Structure
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sda, opened
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sda, IE (SMART) not enabled, skip device Try 'smartctl -s on /dev/sda' to turn on SMART features
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdb, opened
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdb, IE (SMART) not enabled, skip device Try 'smartctl -s on /dev/sdb' to turn on SMART features
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdc, opened
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdc, IE (SMART) not enabled, skip device Try 'smartctl -s on /dev/sdc' to turn on SMART features
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdd, opened
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sdd, IE (SMART) not enabled, skip device Try 'smartctl -s on /dev/sdd' to turn on SMART features
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sde, opened
Oct 31 14:37:16 ocm1 smartd[3604]: Device: /dev/sde, IE (SMART) not enabled, skip device Try 'smartctl -s on /dev/sde' to turn on SMART features


hdc 是什么盘?

回复 只看该作者 道具 举报

3#
发表于 2014-10-31 16:27:56
HDC是光驱。

另外在CRS_HOME/bin目录下产生很多这样的文件,在linux下用strings可见:
core.12289     core.13172  core.13782  core.14476  core.17465  core.18246  core.20501  core.21395  core.5925  core.6216      
core.12302     core.13190  core.13790  core.14484  core.17473  core.18254  core.20516  core.21408  core.5927  core.6229     
core.12310     core.13198  core.13798  core.14492  core.17481  core.18262  core.20532  core.21438  core.5928  core.6242         
core.12323     core.13206  core.13811  core.14505  core.17489  core.18270  core.20540  core.21452  core.5933  core.6255         evmlogger           ocssd
core.12346     core.13220  core.13824  core.14513  core.17497  core.18283  core.20555  core.21460  core.5934  core.6263 。。。。。。。。。。。

回复 只看该作者 道具 举报

4#
发表于 2014-10-31 16:31:18
回复的附件发不上来。

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-21 01:36 , Processed in 0.053194 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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