Data Backup and Recovery Discussions

Highlighted

SMO mount error in oracle using ASM

Hi,everyone,

     I have error in mount a error in oracle using ASM,  how  can i solve this problem?

--[ INFO] SMO-13046: Operation GUID ff8080812890c089012890c08dd20001 starting on Profile PROFILEASM
--[ INFO] SD-00028: Beginning to connect device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f6c5801288f6c5dc20001_0.
--[ INFO] SD-00029: Finished connecting device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f6c5801288f6c5dc20001_0.
--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdb1" to raw device "/dev/raw/raw10".
--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1.
--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100513162059538_1 on host dell67.
--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.
--[ INFO] SD-00019: Discovering storage resources for all system devices.
--[ INFO] SD-00020: Finished storage discovery for all system devices.
--[ INFO] SD-00034: Beginning to disconnect device(s) [/dev/sdb].
--[ INFO] SD-00035: Finished disconnecting device(s) [/dev/sdb].
--[ WARN] FLOW-11011: Operation aborted
--[ERROR] FLOW-11008: Operation failed: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] SMO-13032: Cannot perform operation: Backup Mount.  Root cause: SMO-11007: Error cloning from snapshot: FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ INFO] SMO-13039: Successfully aborted operation: Backup Mount
--[ERROR] SMO-13048: Backup Mount Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:00:33.300

24 REPLIES 24
Highlighted

Re: SMO mount error in oracle using ASM

Hi All

This is neto from Brazil

How are you?

IMHO the issue is:

--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdb1" to raw device "/dev/raw/raw10".

Based on it, you have mounted sdb1 to raw10 and worked.

--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100513162059538_1 on host dell67.

--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100513162059538_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed

ORA-15024: discovered duplicately numbered ASM disk 0

Seems to me that ASM instance doesn't have configure the ASM disktring and ASM is trying to discover all disks and ASM could be discovering two disks with same id (sdb1 and raw10).

You could try to use the following on ASM configuration: (ASM disk string)

Add:

/dev/raw/, /opt/NetApp/mount/

Please let me know the results

All the best

neto

Highlighted

Re: SMO mount error in oracle using ASM

Thanks  neto

     Before test smo mount  for ASM,I have set ASM configure asm_diskstring='/dev/raw/raw*'

ALTER SYSTEM SET asm_diskstring='/dev/raw/raw*' SCOPE=BOTH

so ASM should not discovery other path, such as /dev/sdb1

--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1.
How smo change the header name disk /dev/raw/raw10 from DG1 to DG1_20100513162059538_1

Highlighted

Re: SMO mount error in oracle using ASM

Hi my friend

This is neto from Brazil

How are you?

Worked?

All the best

neto

Highlighted

Re: SMO mount error in oracle using ASM

my os is rhel5.4,and smo's version is 3.0.0 for linux

Automatic Storage Management support library (ASMLib) must be used when using ASM with iSCSI or FCP on Linux.?

Highlighted

Re: SMO mount error in oracle using ASM

And that version of SMO is not supported with RHEL 5U4. You need to be

on either 3.0.2 or, preferred, 3.0.3 and be using SDU 4.1.1.

-Mark

Highlighted

Re: SMO mount error in oracle using ASM

Sorry,my smo's version is 3.0.3, not 3.0.0

Does smo for linus only support asmlib, not support raw device?

Highlighted

Re: SMO mount error in oracle using ASM

But what I suggested worked or not? I didn't understand

Highlighted

Re: SMO mount error in oracle using ASM

Hi, neto

I set asm_diskstring  to  /dev/raw/, /opt/NetApp/mount/ ,but  smo mount report  the sam error.

Highlighted

Re: SMO mount error in oracle using ASM

Could you please do me a favor

export ORACLE_SID=+ASM

sqlplus / as sysdba

show parameter asm

Highlighted

Re: SMO mount error in oracle using ASM

The asm configure paremater,asm_diskstring has been set to /dev/raw/raw*

SQL>  show parameters asm

asm_diskgroups                       string                 DG1
asm_diskstring                       string                 /dev/raw/raw*
asm_power_limit                      integer                1

Highlighted

Re: SMO mount error in oracle using ASM

Could you please copy here the exactly error?

Highlighted

Re: SMO mount error in oracle using ASM

New error information for smo mount:

asm_diskstring has changed to /dev/raw/raw*

--[ INFO] SMO-13046: Operation GUID ff808081289458650128945869dd0001 starting on Profile PROFILEASM
--[ INFO] SD-00028: Beginning to connect device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f688501288f688a0a0001_0.
--[ INFO] SD-00029: Finished connecting device(s) [/dev/sdg] from snapshot smo_profileasm_orcl_f_h_1_ff808081288f688501288f688a0a0001_0.
--[ INFO] PLAT-00010: Creating mapping from disk "/dev/sdd1" to raw device "/dev/raw/raw11".
--[ INFO] ASM-00500: Changing ASM Disk Group name in header of disk /dev/raw/raw11 from DG1 to DG1_20100514090543623_1.
--[ INFO] ASM-00000: Mounting ASM Disk Group DG1_20100514090543623_1 on host dell67.
--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.
--[ INFO] SD-00019: Discovering storage resources for all system devices.
--[ INFO] SD-00020: Finished storage discovery for all system devices.
--[ INFO] SD-00034: Beginning to disconnect device(s) [/dev/sdd].
--[ INFO] SD-00035: Finished disconnecting device(s) [/dev/sdd].
--[ WARN] FLOW-11011: Operation aborted
--[ERROR] FLOW-11008: Operation failed: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ERROR] SMO-13032: Cannot perform operation: Backup Mount.  Root cause: SMO-11007: Error cloning from snapshot: FLOW-11019: Failure in ExecuteConnectionSteps: ORACLE-10003: Error executing SQL "ALTER DISKGROUP DG1_20100514090543623_1 MOUNT" against Oracle database +ASM: ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

--[ INFO] SMO-13039: Successfully aborted operation: Backup Mount
--[ERROR] SMO-13048: Backup Mount Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:00:23.617

Highlighted

Re: SMO mount error in oracle using ASM

Could you please collect

Connect to ASM instance

select name, state from v$asm_diskgroup;

select name, path from v$asm_disk;

Highlighted

Re: SMO mount error in oracle using ASM

SQL> select name, state from v$asm_diskgroup;


DG1
MOUNTED


SQL> SQL> select name, path from v$asm_disk;


/dev/raw/raw8


/dev/raw/raw7


/dev/raw/raw6


/dev/raw/raw3

/dev/raw/raw4


/dev/raw/raw2


/dev/raw/raw10

DG1_0000
/dev/raw/raw1


8 rows selected.

Highlighted

Re: SMO mount error in oracle using ASM

Please do me a favor

Disconnect /dev/raw/raw10

Run the same commands again

SQL> select name, state from v$asm_diskgroup;

SQL> SQL> select name, path from v$asm_disk;

Make sure that raw10 is disconnected

raw -qa

Check also if the clone has been disconnected.

Try again, because seems to me that the rename worked (see DG1_0000)

Please run again and collect the SMO diagnostics

Check out the KB!
Knowledge Base
All Community Forums