oracle asm spfile丢失,11g ASM spfile控制磁盘组问题（已解决）

本帖最后由 charlie_qin 于 2014-11-4 10:08 编辑

这个调整好像也没有效果：

[root@rac1 ~]# srvctl start database -d racdb

[root@rac1 ~]# srvctl status database -d racdb

Instance racdb1 is running on node rac1

Instance racdb2 is running on node rac2

[root@rac1 ~]#

[root@rac1 ~]#

[root@rac1 ~]#

[root@rac1 ~]# srvctl config database -d racdb

Database unique name: racdb

Database name: racdb

Oracle home: /oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: +ORADATA/racdb/parameterfile/spfile.270.862054101

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdb

Database instances: racdb1,racdb2

Disk Groups: DATA,ARCH

Services:

Database is administrator managed

[root@rac1 ~]# srvctl modify database -d racdb -a "data,arch,ocr,oradata"

[root@rac1 ~]# srvctl config database -d racdb

Database unique name: racdb

Database name: racdb

Oracle home: /oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: +ORADATA/racdb/parameterfile/spfile.270.862054101

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: racdb

Database instances: racdb1,racdb2

Disk Groups: DATA,ARCH,OCR,ORADATA

Services:

Database is administrator managed

[root@rac1 ~]# srvctl stop database -d racdb

[root@rac1 ~]# srvctl status database -d racdb

Instance racdb1 is not running on node rac1

Instance racdb2 is not running on node rac2

[root@rac1 ~]# crsctl stop cluster -all

CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'

CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac2'

CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'rac2'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'

CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac2'

CRS-2673: Attempting to stop 'ora.ORADATA.dg' on 'rac2'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'

CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac1'

CRS-2673: Attempting to stop 'ora.ORADATA.dg' on 'rac1'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'

CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on 'rac2' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded

CRS-2677: Stop of 'ora.OCR.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ARCH.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.OCR.dg' on 'rac2' succeeded

CRS-2677: Stop of 'ora.ARCH.dg' on 'rac2' succeeded

CRS-2677: Stop of 'ora.ORADATA.dg' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ORADATA.dg' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac2'

CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'rac2'

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.eons' on 'rac2'

CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'

CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded

CRS-2677: Stop of 'ora.eons' on 'rac2' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed

CRS-2673: Attempting to stop 'ora.ons' on 'rac1'

CRS-2673: Attempting to stop 'ora.eons' on 'rac1'

CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac2'

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'

CRS-2673: Attempting to stop 'ora.asm' on 'rac2'

CRS-2677: Stop of 'ora.cssdmonitor' on 'rac2' succeeded

CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'

CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded

CRS-2677: Stop of 'ora.eons' on 'rac1' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded

CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'rac1'

CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'

CRS-2673: Attempting to stop 'ora.asm' on 'rac1'

CRS-2677: Stop of 'ora.cssdmonitor' on 'rac1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'

CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded

CRS-2673: Attempting to stop 'ora.diskmon' on 'rac2'

CRS-2677: Stop of 'ora.diskmon' on 'rac2' succeeded

CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.diskmon' on 'rac1'

CRS-2677: Stop of 'ora.diskmon' on 'rac1' succeeded

[root@rac1 ~]# ps -ef|grep ASM

root     11220  8814  0 09:59 pts/1    00:00:00 grep ASM

[root@rac1 ~]# crsctl start cluster -all

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac1'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'

CRS-2672: Attempting to start 'ora.cssd' on 'rac2'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac2'

CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded

CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'rac1'

CRS-2676: Start of 'ora.cssd' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'rac2'

CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'rac1'

CRS-2672: Attempting to start 'ora.evmd' on 'rac1'

CRS-2676: Start of 'ora.ctssd' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.evmd' on 'rac2'

CRS-2672: Attempting to start 'ora.asm' on 'rac2'

CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded

CRS-2676: Start of 'ora.evmd' on 'rac2' succeeded

CRS-2676: Start of 'ora.asm' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac1'

CRS-2676: Start of 'ora.asm' on 'rac2' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'rac2'

CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded

CRS-2676: Start of 'ora.crsd' on 'rac2' succeeded

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE

------------------------------ -----------

OCR                            MOUNTED

ORADATA                        DISMOUNTED

ARCH                           DISMOUNTED

DATA                           DISMOUNTED

而且今天仅做了这一个操作，再次重启CRS ASM后 spfile 对磁盘组的控制内容又变了 ：

+ASM1.__oracle_base='/grid/product/grid'#ORACLE_BASE set from in memory value

+ASM2.__oracle_base='/grid/product/grid'#ORACLE_BASE set from in memory value

*.asm_diskgroups='ORADATA','OCR','DATA','ARCH'

+ASM.asm_diskgroups='OCR','DATA','ARCH','ORADATA'

+ASM2.asm_diskgroups='OCR'#Manual Dismount

+ASM1.asm_diskgroups='OCR'#Manual Dismount

*.asm_diskstring='/dev/oracleasm/disks'

*.asm_power_limit=1

*.diagnostic_dest='/grid/product/grid'

*.instance_type='asm'

*.large_pool_size=12M

*.memory_max_target=5368709120

*.memory_target=5368709120

*.pga_aggregate_target=209715200

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=4294967296

*.sga_target=4294967296

[grid@rac1:/home/grid]$