Data Backup and Recovery Discussions

SMO mount error in oracle using ASM

bjloveunix

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

Re: SMO mount error in oracle using ASM

neto

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

Re: SMO mount error in oracle using ASM

bjloveunix

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

Re: SMO mount error in oracle using ASM

neto

Hi my friend

This is neto from Brazil

How are you?

Worked?

All the best

neto

Re: SMO mount error in oracle using ASM

bjloveunix

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.?

Re: SMO mount error in oracle using ASM

jessick

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

Re: SMO mount error in oracle using ASM

bjloveunix

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

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

Re: SMO mount error in oracle using ASM

neto

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

Re: SMO mount error in oracle using ASM

bjloveunix

Hi, neto

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

Re: SMO mount error in oracle using ASM

neto

Could you please do me a favor

export ORACLE_SID=+ASM

sqlplus / as sysdba

show parameter asm

Re: SMO mount error in oracle using ASM

bjloveunix

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

Re: SMO mount error in oracle using ASM

neto

Could you please copy here the exactly error?

Re: SMO mount error in oracle using ASM

bjloveunix

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

Re: SMO mount error in oracle using ASM

neto

Could you please collect

Connect to ASM instance

select name, state from v$asm_diskgroup;

select name, path from v$asm_disk;

Re: SMO mount error in oracle using ASM

bjloveunix

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.

Re: SMO mount error in oracle using ASM

neto

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

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public