RE: ASM problems
- From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
- To: "'Johan Eriksson'" <valpis@xxxxxxxxx>
- Date: Thu, 5 Oct 2006 16:24:09 +0100
Hi,
since I'm stuck with Outlook, I can't reply inline so ...
- /etc/init.d/oracleasm listdisks should show you _disks_ not diskgroups - so
the disk ORADATA2 is not showing up on the second node. Is it properly
presented at the operating system level? I think this is the root of the
ORA-15075.
- on the first node, try alter diskgroup ORADATA1 drop disk ORADATA2 to see
whether you can drop the disk out of the disk group. It's possible this will
work now, or maybe only after you get the disk presented correctly on the
second node and run a fresh scandisks.
HTH,
Duncan.
-----Original Message-----
From: Johan Eriksson [mailto:valpis@xxxxxxxxx]
Sent: 05 October 2006 15:10
To: Lawie, Duncan
Cc: fairlie rego; oracle-l@xxxxxxxxxxxxx
Subject: Re: ASM problems
Hi
On 10/5/06, Lawie, Duncan <duncan.lawie@xxxxxxxxxxxxxxxxx> wrote:
> Johan,
>
> have you tried an /etc/init.d/oracleasm scandisks on the second node? This
> should, at least, allow the disk to be seen from both nodes.
>
On the second node:
[oracle@vobgperfmsdb02 ~]$ /etc/init.d/oracleasm scandisks
Scanning system for ASM disks: [ OK ]
[oracle@vobgperfmsdb02 ~]$ /etc/init.d/oracleasm listdisks
ORADATA1
But given the error I made I think it is ok, I did add the new disk to
diskgroup ORADATA1
> It looks like the select from v$asm_disk is being done in the RDBMS. What do
> you get if you do the select in your ASM instance? Does it show the second
> disk? Is it a member of a disk group?
>
> select d.name, d.state, g.name from
> v$asm_disk d, v$asm_diskgroup g
> where d.group_number = g.group_number
>
SQL> select d.name, d.state, g.name from
v$asm_disk d, v$asm_diskgroup g
where d.group_number = g.group_number 2 3 ;
NAME STATE NAME
------------------------------ -------- ------------------------------
ORADATA1 NORMAL ORADATA1
ORADATA2 FORCING ORADATA1
So yes, It is a member of the group ORADATA1
> If the second disk isn't a member of a disk group you are OK.
>
> If it is a member of a disk group, try dropping it from that group
>
> alter diskgroup ORADATA1 drop disk WHATEVER;
>
and in this case the WHATEVER is ? not the devicename I suppose but the disk
name ORADATA2?
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
