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

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

6

积分

0

好友

1

主题
1#
发表于 2012-4-6 14:07:19 | 查看: 9540| 回复: 8
环境:
11.2.0.3 rac+asm
linux 5.2

问题描述:
我现在看crsd.log的时候它一直在找ocr file.但是ocr是放到asm里面。。asm实例没有起来。
但是启动asm实例报下面的错误:
SQL> conn /as sysasm
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service


[grid@ap07 bin]$ crsctl check has
CRS-4638: Oracle High Availability Services is online


[grid@ap07 bin]$ ps -ef |grep css
root      4485     1  0 Apr05 ?        00:01:25 /ora11g/app/11.2.0/grid/bin/cssdmonitor
grid     29976 29748  0 14:06 pts/1    00:00:00 grep css
[grid@ap07 bin]$ ps -ef |grep d.bin
root      3900     1  0 Apr05 ?        00:00:18 /ora11g/app/11.2.0/grid/bin/ohasd.bin reboot
grid      4268     1  0 Apr05 ?        00:00:28 /ora11g/app/11.2.0/grid/bin/oraagent.bin
grid      4280     1  0 Apr05 ?        00:00:02 /ora11g/app/11.2.0/grid/bin/mdnsd.bin
grid      4289     1  0 Apr05 ?        00:00:21 /ora11g/app/11.2.0/grid/bin/gpnpd.bin
root      4301     1  0 Apr05 ?        00:00:11 /ora11g/app/11.2.0/grid/bin/orarootagent.bin
grid      4304     1  0 Apr05 ?        00:01:43 /ora11g/app/11.2.0/grid/bin/gipcd.bin
root      4318     1  0 Apr05 ?        00:04:27 /ora11g/app/11.2.0/grid/bin/osysmond.bin
root      4392     1  0 Apr05 ?        00:02:56 /ora11g/app/11.2.0/grid/bin/ologgerd -M -d /ora11g/app/11.2.0/grid/crf/db/ap07
root      4485     1  0 Apr05 ?        00:01:25 /ora11g/app/11.2.0/grid/bin/cssdmonitor
grid     29978 29748  0 14:06 pts/1    00:00:00 grep d.bin
2#
发表于 2012-4-6 14:33:19
ODM TEST:


FOR GI/CRS 11.2.0.3

crsctl stop cluster -all  -f
crsctl stop has -f




[root@vrh1 ~]# crsctl stop has -f


CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'vrh1'
CRS-2673: Attempting to stop 'ora.crf' on 'vrh1'
CRS-2677: Stop of 'ora.crf' on 'vrh1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'vrh1'
CRS-2677: Stop of 'ora.mdnsd' on 'vrh1' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'vrh1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'vrh1'
CRS-2677: Stop of 'ora.gpnpd' on 'vrh1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vrh1' has completed
CRS-4133: Oracle High Availability Services has been stopped.


[root@vrh1 ~]# crsctl start crs -excl -nocrs



CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'vrh1'
CRS-2676: Start of 'ora.mdnsd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'vrh1'
CRS-2676: Start of 'ora.gpnpd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vrh1'
CRS-2672: Attempting to start 'ora.gipcd' on 'vrh1'
CRS-2676: Start of 'ora.cssdmonitor' on 'vrh1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'vrh1'
CRS-2672: Attempting to start 'ora.diskmon' on 'vrh1'
CRS-2676: Start of 'ora.diskmon' on 'vrh1' succeeded
CRS-2676: Start of 'ora.cssd' on 'vrh1' succeeded
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'vrh1'
CRS-2672: Attempting to start 'ora.ctssd' on 'vrh1'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'vrh1'
CRS-2676: Start of 'ora.ctssd' on 'vrh1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'vrh1'
CRS-2676: Start of 'ora.asm' on 'vrh1' succeeded
[root@vrh1 ~]#


[root@vrh1 ~]# ps -ef|grep asm_
grid     23783     1  0 02:23 ?        00:00:00 asm_pmon_+ASM1
grid     23787     1  0 02:23 ?        00:00:00 asm_psp0_+ASM1
grid     23793     1  5 02:23 ?        00:00:05 asm_vktm_+ASM1
grid     23799     1  0 02:23 ?        00:00:00 asm_gen0_+ASM1
grid     23803     1  0 02:23 ?        00:00:00 asm_diag_+ASM1
grid     23807     1  0 02:23 ?        00:00:00 asm_ping_+ASM1
grid     23811     1  0 02:23 ?        00:00:00 asm_dia0_+ASM1
grid     23815     1  0 02:23 ?        00:00:00 asm_lmon_+ASM1
grid     23819     1  0 02:23 ?        00:00:00 asm_lmd0_+ASM1
grid     23823     1  0 02:23 ?        00:00:00 asm_lms0_+ASM1
grid     23829     1  0 02:23 ?        00:00:00 asm_lmhb_+ASM1
grid     23833     1  0 02:23 ?        00:00:00 asm_mman_+ASM1
grid     23837     1  0 02:23 ?        00:00:00 asm_dbw0_+ASM1
grid     23841     1  0 02:23 ?        00:00:00 asm_lgwr_+ASM1
grid     23845     1  0 02:23 ?        00:00:00 asm_ckpt_+ASM1
grid     23849     1  0 02:23 ?        00:00:00 asm_smon_+ASM1
grid     23853     1  0 02:23 ?        00:00:00 asm_rbal_+ASM1
grid     23857     1  0 02:23 ?        00:00:00 asm_gmon_+ASM1
grid     23861     1  0 02:23 ?        00:00:00 asm_mmon_+ASM1
grid     23865     1  0 02:23 ?        00:00:00 asm_mmnl_+ASM1
grid     23869     1  0 02:23 ?        00:00:00 asm_lck0_+ASM1
root     23983 22694  0 02:24 pts/0    00:00:00 grep asm_

[root@vrh1 ~]# su - grid

[grid@vrh1 ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     46080    42306                0           42306              0             N  BACKUPDG/
MOUNTED  EXTERN  N         512   4096  1048576     87040    40417                0           40417              0             N  DATA/
MOUNTED  HIGH    N         512   4096  1048576     25600    24344            10240            4701              0             Y  SYSTEMDG/


ASMCMD> cd systemdg
ASMCMD> ls
vrh-cluster/
ASMCMD> cd vrh-cluster
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd OCRFILE
ASMCMD> ls
REGISTRY.255.766612109




[root@vrh1 ~]# ocrconfig  -export ocr.exp
[root@vrh1 ~]# ocrdump ocr.bak

回复 只看该作者 道具 举报

3#
发表于 2012-4-6 15:04:33
tks.这样子asm是已经起来啦。
但是我发现我这个asm1上面:
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
CRS                            MOUNTED
DATA                           MOUNTED

但是我在asm2上面缺发现:
SQL> conn /as sysasm
Connected.
SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
CRS                            DISMOUNTED
DATA                           DISMOUNTED

SQL> alter diskgroup crs mount;
alter diskgroup crs mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "CRS" cannot be mounted
ORA-15003: diskgroup "CRS" already mounted in another lock name space

回复 只看该作者 道具 举报

4#
发表于 2012-4-6 15:06:19
crsctl start crs -excl -nocrs

是以exclusive 排他方式启动CRS,不允许其他node节点参与, 这种模式仅用来应对特殊场景。

回复 只看该作者 道具 举报

5#
发表于 2012-4-6 15:25:16
如果是这样子的话。crs还是启动不了.
通过你上面的方法asm两边都能起来。但是当我crsctl stop has -f以后
crsctl start crs应该是都能带起来的啊 。但是log里面还是一直
[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log
2012-04-06 15:20:17.569
[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log

回复 只看该作者 道具 举报

6#
发表于 2012-4-6 15:26:20
[cssd(9265)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /ora11g/app/11.2.0/grid/log/db07/cssd/ocssd.log

确认你的 Votedisk 完好

[root@vrh1 ~]# crsctl query  css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   a853d6204bbc4feabfd8c73d4c3b3001 (/dev/asm-diskh) [SYSTEMDG]
2. ONLINE   a5b37704c3574f0fbf21d1d9f58c4a6b (/dev/asm-diskg) [SYSTEMDG]
3. ONLINE   36e5c51ff0294fc3bf2a042266650331 (/dev/asm-diski) [SYSTEMDG]
4. ONLINE   af337d1512824fe4bf6ad45283517aaa (/dev/asm-diskj) [SYSTEMDG]
5. ONLINE   3c4a349e2e304ff6bf64b2b1c9d9cf5d (/dev/asm-diskk) [SYSTEMDG]
Located 5 voting disk(s).

回复 只看该作者 道具 举报

7#
发表于 2012-4-6 15:33:28
[root@ap07 bin]# ./crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'ap07'
CRS-2676: Start of 'ora.mdnsd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'ap07'
CRS-2676: Start of 'ora.gpnpd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ap07'
CRS-2672: Attempting to start 'ora.gipcd' on 'ap07'
CRS-2676: Start of 'ora.cssdmonitor' on 'ap07' succeeded
CRS-2676: Start of 'ora.gipcd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ap07'
CRS-2672: Attempting to start 'ora.diskmon' on 'ap07'
CRS-2676: Start of 'ora.diskmon' on 'ap07' succeeded
CRS-2676: Start of 'ora.cssd' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.drivers.acfs' on 'ap07'
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'ap07'
CRS-2672: Attempting to start 'ora.ctssd' on 'ap07'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'ap07'
CRS-2676: Start of 'ora.drivers.acfs' on 'ap07' succeeded
CRS-2676: Start of 'ora.ctssd' on 'ap07' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'ap07' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'ap07'
CRS-2676: Start of 'ora.asm' on 'ap07' succeeded

[root@ap07 bin]# ./crsctl query css votedisk
Located 0 voting disk(s).

[grid@ap07 ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  8388608      3064     2624                0            2624              0             N  CRS/
MOUNTED  EXTERN  N         512   4096  8388608    102392    45688                0           45688              0             N  DATA/
ASMCMD> exit
[grid@ap07 ~]$ crsctl query css votedisk
Located 0 voting disk(s).

怎么votedisk没有了那。asmdisk 都是mount的啊 。

回复 只看该作者 道具 举报

8#
发表于 2012-4-6 15:45:05
votedisk 是存放在那个DG上的?  如果确实没有了 ,需要restore voting disk

回复 只看该作者 道具 举报

9#
发表于 2012-4-6 15:48:58
votedisk,ocr全部都是放到asmdisk上面的。没有备份。
貌似要deleteroot.sh然后重新执行root.sh然后再将resource添加到crs里面啦。

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-15 10:40 , Processed in 0.058463 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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