Hmmmm, this is pretty advanced scripting ! I'm very curious about the actual script.
I've done my sahre of scripting snaps with VMware virtual machines RDM's in order to backup whole disks, so perhaps then I can add some helpful comments on your story.

Hi RRR,

Thanks for the reply, I could post the script but I don't think it would make much sense! We use AppWorx as our batch scheduler for all our internal scripts, and are able to pass the following variables into the job in order to choose the DB, Clone type (Start of Day, End of Day, Reporting Set, Archive, Website etc), if we are mounting for backup or for normal use and the action (MOUNT or UNMOUNT) etc.

rem %1 Database Name (DBNAME)
rem %2 CloneName (DB,EOD,SOD,ARC,REP,WEB)
rem %3 Mount Folder (ORACLEDATABASES OR ORACLEBACKUPS)
rem %4 DISK Type (DATA,INDEX,REDO-TEMP,UNDO)
rem %5 Clone Device ID (CDI)
rem %6 ACTION (Mount or Unmount)
rem %7 PowerMT File

so the job is just a list of %this and %that and the calling of various batch files to achieve this process.

Below is the output script of the failed job, which I think shows all the commands being executed in full.

It is failing due to powerpath/naviagent not picking up the undo LUN.

I can reboot the server, the undo disk appears, rerun the job which then completes successfully, run the job with the unmount command, and everything disappears correctly, then rerun and powerpath only seems to pick up the DATA/INDEX/REDO-TEMP disks but never the UNDO until I reboot the server again???

The first half of the job just checks to find the ids of the luns then checks the clone status and then the second half (where it states "Publish Clone Starts") is the adding to storage group and the mount of thr disks to a folder.

Enjoy!

Pid 3112
Copyright 2001 AppWorx Corporation
FILEID:19756041
source MPABAT Operator S7-EMC
program d:\apps\sanemcaw\bin\SANEMC_ORADB_MAINT_CLONE.bat
application UTL_SANEMC
module TEMSDBA_EOD_MOUNT job_number 30815 jobid 20707573.00
batch_home D:\apps\appworx\agent\s7-emc output D:\apps\appworx\agent\s7-emc\out
rpf_options printer ''
app_path d:\apps\sanemcaw
file TEMSDBA_EOD_MOUNT.20707573.00 command_dir \bin copies 1 user SQLOPER
function STORE log run Y output required N
netconnect
LOGIN serviceSysAW DBTYPE HOST
parameter file Pid 3112
BMH-CX380-SPA
TEMSDBA
EOD
PUBLISH
ORACLEDATABASES
Processing TEMSDBA_EOD_MOUNT
calling awexe command: D:\apps\appworx\agent\s7-emc\c\awexe UPD_JQ SO_JOBID=20707573.00 SO_STATUS=31 SO_JOB_PID=3112 SO_SEQ_NO=19756040 awexe RUNNING return 0 ## In MPABATS VERSION 2009 Starts at Wed 02/27/2008__11:06:14.07
.aw_get_basemodule VERSION 2001 Starts D:\oraclesoftware\9Ihome0\bin;D:\oraclesoftware\9Ihome0\bin;D:\apps\appworx\agent\s7-emc\bin;D:\apps\appworx\agent\s7-emc\exec;D:\apps\appworx\agent\s7-emc\bin;D:\apps\appworx\agent\s7-emc\exec;C:\Program Files\EMC\PowerPath\;d:\oraclesoftware\9IHome1\jre\1.4.2\bin\client;d:\oraclesoftware\9IHome1\jre\1.4.2\bin;d:\oraclesoftware\9IHome1\bin;d:\oraclesoftware\9IHome0\jre\1.4.2\bin\client;d:\oraclesoftware\9IHome0\jre\1.4.2\bin;d:\oraclesoftware\9IHome0\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;d:\APPS\OPS\BIN;d:\APPS\OPS\W2KRESKIT
..utl_givedatetimestamp VERSION 2008 Starts
..utl_givedatetimestamp VERSION 2008 (ERRORLEVEL RETURNED 0) Ends
.aw_get_basemodule VERSION 2001 (ERRORLEVEL RETURNED 0) Ends 'calling'd:\apps\sanemcaw\bin\SANEMC_ORADB_MAINT_CLONE.bat
First pass: "BMH-CX380-SPA
"
later pass: " TEMSDBA
"
later pass: " EOD
"
later pass: " PUBLISH
"
later pass: " ORACLEDATABASES
"
!----------------------------------------------------------------------------------------------------------
! MCPS-PRS-Alliance Appworx job runtime details !
! Environment Details
! Computername : SYSTEMS7-EMC AGENT : S7-EMC
! Domain\Username : ALLIANCE\ServiceTestAW DNS : alliance.co.uk
! Module Details
! Application : UTL_SANEMC
! Program Type : MPABATS.BAT
! Module Name : TEMSDBA_EOD_MOUNT Base Module : SANEMC_ORADB_MAINT_CLONE
! Command : SANEMC_ORADB_MAINT_CLONE.bat
! Program : d:\apps\sanemcaw\bin\SANEMC_ORADB_MAINT_CLONE.bat
! Database Details
! Oracle_Home :
! DB_LOGIN : serviceSysAW DBA :
! Instance :
! SQL_RUN :
! Appworx Details
! Spawd_PID : 3112
! Jobid : 20707573.00 Jobnumber : 30815 Sequence : 19756040
! Chain_id : 0 Chain_seq : 0
! AW_HOME : D:\apps\appworx\agent\s7-emc
! STDOUT : D:\apps\appworx\agent\s7-emc\out\TEMSDBA_EOD_MOUNT.20707573.00.log
!
!----------------------------------------------------------------------------------------------------------
NTSPAWN pid 3712:e80
JOBID 20707573.00
Spawned process with ID 836 344
## SOBATS VERSION 2003 Starts at Wed 02/27/2008__11:06:14.35 ## SOBATS 'calling'd:\apps\sanemcaw\bin\SANEMC_ORADB_MAINT_CLONE.bat BMH-CX380-SPA TEMSDBA EOD PUBLISH ORACLEDATABASES SOBATS ERRORLEVEL=0 ! .UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0 D:\oraclesoftware\9Ihome0\bin;D:\oraclesoftware\9Ihome0\bin;D:\apps\appworx\agent\s7-emc\bin;D:\apps\appworx\agent\s7-emc\exec;D:\apps\appworx\agent\s7-emc\bin;D:\apps\appworx\agent\s7-emc\exec;C:\Program Files\EMC\PowerPath\;d:\oraclesoftware\9IHome1\jre\1.4.2\bin\client;d:\oraclesoftware\9IHome1\jre\1.4.2\bin;d:\oraclesoftware\9IHome1\bin;d:\oraclesoftware\9IHome0\jre\1.4.2\bin\client;d:\oraclesoftware\9IHome0\jre\1.4.2\bin;d:\oraclesoftware\9IHome0\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;d:\APPS\OPS\BIN;d:\APPS\OPS\W2KRESKIT
.sanemc_oradb_maint_clone VERSION 2001 Starts
.sanemc_oradb_maint_clone Source Database TEMSDBA
.sanemc_oradb_maint_clone Clone Data LUN TEMSDBA-DATA-EOD
.sanemc_oradb_maint_clone Clone Index LUN TEMSDBA-INDEX-EOD
.sanemc_oradb_maint_clone Clone Redo-Temp LUN TEMSDBA-REDO-TEMP-EOD
.sanemc_oradb_maint_clone Clone Undo LUN TEMSDBA-UNDO-EOD
.sanemc_oradb_maint_clone Clone Action PUBLISH
.sanemc_oradb_maint_clone Lookup File:
.sanemc_oradb_maint_clone d:\apps\sanemcaw\status\BMH-CX380-SPA.Lookup
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Looking DB Luns Starts
.sanemc_oradb_maint_clone
..sanemc_get_luninfo_oradb VERSION 2001 Starts
..sanemc_get_luninfo_oradb Scan d:\apps\sanemcaw\status\BMH-CX380-SPA.Lookup
..sanemc_get_luninfo_oradb VERSION 2001 (ERRORLEVEL RETURNED 0) Ends
.sanemc_oradb_maint_clone DATA Target LUN Id 98
.sanemc_oradb_maint_clone DATA Target UId 6006016049A61E00D4DDF9803B82DC11
.sanemc_oradb_maint_clone INDEX Target LUNId 323
.sanemc_oradb_maint_clone INDEX Target UId 6006016049A61E003EF095E73E82DC11
.sanemc_oradb_maint_clone REDO Target LUN Id 117
.sanemc_oradb_maint_clone REDO Target UId 6006016049A61E0008D2EC6D3D82DC11
.sanemc_oradb_maint_clone UNDO Target LUN Id 108
.sanemc_oradb_maint_clone UNDO Target UId 6006016049A61E0010DACCAB3C82DC11
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Looking DB Luns Complete
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Looking Up Clone id's ... Starts
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Source TEMSDBA-DATA
naviseccli -h BMH-CX380-SPA snapview -listclone -name TEMSDBA-DATA ! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_get_cloneinfo VERSION 2001 Starts
..sanemc_get_cloneinfo Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-DATA.Status
..sanemc_get_cloneinfo for LUNTLUNID 98
..sanemc_get_cloneinfo VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone DATA Clone LUN Id 98
.sanemc_oradb_maint_clone DATA Clone ID 0100000000000000
! .sanemc_oradb_maint_clone LUN 98 Checked
.sanemc_oradb_maint_clone Source TEMSDBA-INDEX
naviseccli -h BMH-CX380-SPA snapview -listclone -name TEMSDBA-INDEX ! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_get_cloneinfo VERSION 2001 Starts
..sanemc_get_cloneinfo Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-INDEX.Status
..sanemc_get_cloneinfo for LUNTLUNID 323
..sanemc_get_cloneinfo VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone INDEX Clone LUN Id 323
.sanemc_oradb_maint_clone INDEX Clone ID 0100000000000000
! .sanemc_oradb_maint_clone LUN 323 Checked
.sanemc_oradb_maint_clone Source TEMSDBA-REDO-TEMP
naviseccli -h BMH-CX380-SPA snapview -listclone -name TEMSDBA-REDO-TEMP ! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_get_cloneinfo VERSION 2001 Starts
..sanemc_get_cloneinfo Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-REDO-TEMP.Status
..sanemc_get_cloneinfo for LUNTLUNID 117
..sanemc_get_cloneinfo VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone REDO Clone LUN Id 117
.sanemc_oradb_maint_clone REDO Clone ID 0100000000000000
! .sanemc_oradb_maint_clone LUN 117 Checked
.sanemc_oradb_maint_clone Source TEMSDBA-UNDO
naviseccli -h BMH-CX380-SPA snapview -listclone -name TEMSDBA-UNDO ! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_get_cloneinfo VERSION 2001 Starts
..sanemc_get_cloneinfo Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-UNDO.Status
..sanemc_get_cloneinfo for LUNTLUNID 108
..sanemc_get_cloneinfo VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone UNDO Clone LUN Id 108
.sanemc_oradb_maint_clone UNDO Clone ID 0100000000000000
! .sanemc_oradb_maint_clone LUN 108 Checked
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Looking Up Clone id's ... Complete
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone CLONE STATUS Starts
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone TEMSDBA-DATA
..sanemc_get_clonestatus VERSION 2001 Starts
..sanemc_get_clonestatus Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-DATA.Status
..sanemc_get_clonestatus for CLONEID 0100000000000000
..sanemc_get_clonestatus VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone TEMSDBA-DATA-EOD
.sanemc_oradb_maint_clone STATUS=Consistent
.sanemc_oradb_maint_clone CONDITION=AdministrativelyFractured
.sanemc_oradb_maint_clone TEMSDBA-INDEX
..sanemc_get_clonestatus VERSION 2001 Starts
..sanemc_get_clonestatus Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-INDEX.Status
..sanemc_get_clonestatus for CLONEID 0100000000000000
..sanemc_get_clonestatus VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone TEMSDBA-INDEX-EOD
.sanemc_oradb_maint_clone STATUS=Consistent
.sanemc_oradb_maint_clone CONDITION=AdministrativelyFractured
.sanemc_oradb_maint_clone TEMSDBA-REDO-TEMP
..sanemc_get_clonestatus VERSION 2001 Starts
..sanemc_get_clonestatus Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-REDO-TEMP.Status
..sanemc_get_clonestatus for CLONEID 0100000000000000
..sanemc_get_clonestatus VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone TEMSDBA-REDO-TEMP-EOD
.sanemc_oradb_maint_clone STATUS=Consistent
.sanemc_oradb_maint_clone CONDITION=AdministrativelyFractured
.sanemc_oradb_maint_clone TEMSDBA-UNDO
..sanemc_get_clonestatus VERSION 2001 Starts
..sanemc_get_clonestatus Scan ..d:\apps\sanemcaw\status\20707573_TEMSDBA-UNDO.Status
..sanemc_get_clonestatus for CLONEID 0100000000000000
..sanemc_get_clonestatus VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
.sanemc_oradb_maint_clone TEMSDBA-UNDO-EOD
.sanemc_oradb_maint_clone STATUS=Consistent
.sanemc_oradb_maint_clone CONDITION=AdministrativelyFractured
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone CLONE STATUS Complete
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Publish Clone Starts
.sanemc_oradb_maint_clone
..sanemc_get_lunsin_stgr VERSION 2001 Starts
..sanemc_get_lunsin_stgr Output Generated to d:\apps\sanemcaw\status\20707573_TEMSDBA_BMH-CX380-SPASGs.out
navicli -h BMH-CX380-SPA storagegroup -list to d:\apps\sanemcaw\status\20707573_storagegroups.out
...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_get_lunsin_stgr VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_check_lunsin_stgr VERSION 2001 Starts 98 TEMSDBA-DATA-EOD
..sanemc_check_lunsin_stgr VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_check_lunsin_stgr VERSION 2001 Starts 323 TEMSDBA-INDEX-EOD
..sanemc_check_lunsin_stgr VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_check_lunsin_stgr VERSION 2001 Starts 117 TEMSDBA-REDO-TEMP-EOD
..sanemc_check_lunsin_stgr VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_check_lunsin_stgr VERSION 2001 Starts 108 TEMSDBA-UNDO-EOD
..sanemc_check_lunsin_stgr VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_get_max_lun_id VERSION 2001 Starts
..sanemc_get_max_lun_id VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends ! .sanemc_oradb_maint_clone SYSTEMS7-EMC MAXHLU=0
.sanemc_MOUNTSET VERSION 2001 Starts
CALLING \\SYSTEMS7-EMC\APPS\sanemcaw\BIN\sanemc_mountset.kix $app=TEMSDBA_EOD $server=SYSTEMS7-EMC

SANEMC_MOUNT_SET STARTS SYSTEMS7-EMC SANEMCMOUNT_SYSTEMS7-EMC *SANEMCMOUNT_SYSTEMS7-EMC Value='FREE'0 *SANEMCMOUNT_SYSTEMS7-EMC updated with TEMSDBA_EOD

SANEMC_MOUNT_SET ENDS .sanemc_MOUNTSET VERSION 2001 (ERRORLEVEL RETURNED 0) Ends naviseccli -h BMH-CX380-SPA storagegroup -addhlu -gname SYSTEMS7-EMC -hlu 1 -alu 98

! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0 naviseccli -h BMH-CX380-SPA storagegroup -addhlu -gname SYSTEMS7-EMC -hlu 2 -alu 323

! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0 naviseccli -h BMH-CX380-SPA storagegroup -addhlu -gname SYSTEMS7-EMC -hlu 3 -alu 117

! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0 naviseccli -h BMH-CX380-SPA storagegroup -addhlu -gname SYSTEMS7-EMC -hlu 4 -alu 108

! ..UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Publish Clone Complete
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone
.sanemc_oradb_maint_clone Mount Clone Starts
.sanemc_oradb_maint_clone
..sanemc_mount_unmount_disk VERSION 2000 Starts
..sanemc_mount_unmount_disk D:\ORACLEDATABASES\TEMSDBAEOD\DATA01 Not Currently Mounted
..sanemc_mount_unmount_disk Diskpart Check Path
..sanemc_mount_unmount_disk Undefined cmd_proc
..sanemc_mount_unmount_disk Resolved d:\apps\OPS\W2KRESKIT\diskpart.exe
..sanemc_mount_unmount_disk Diskpart Rescan Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Please wait while DiskPart scans your configuration...
..........
DiskPart has finished scanning your configuration.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Rescan Complete In Sleep.bat
..sanemc_mount_unmount_disk PowerMT Starts ! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk PowerMT Complete
...sanemc_mount_unmount_disk_sub VERSION 2001 Starts
...sanemc_mount_unmount_disk_sub DB: TEMSDBA
...sanemc_mount_unmount_disk_sub CLONE: EOD
...sanemc_mount_unmount_disk_sub DBL: ORACLEDATABASES
...sanemc_mount_unmount_disk_sub DBF: D:\ORACLEDATABASES\TEMSDBAEOD
...sanemc_mount_unmount_disk_sub CDI: 6006016049A61E00D4DDF9803B82DC11
...sanemc_mount_unmount_disk_sub PWRMT:
...sanemc_mount_unmount_disk_sub d:\apps\sanemcaw\status\20707573_powermt.txt
...sanemc_mount_unmount_disk_sub TLUN: TEMSDBA-DATA-EOD
...sanemc_mount_unmount_disk_sub
...sanemc_mount_unmount_disk_sub Scanning ....
disk id 6006016049A61E00F6E60F096EE0DC11 diskname SYSTEMS7-EMC disk id 6006016049A61E00D4DDF9803B82DC11 diskname TEMSDBA-DATA-EOD disk id 6006016049A61E003EF095E73E82DC11 diskname TEMSDBA-INDEX-EOD disk id 6006016049A61E0008D2EC6D3D82DC11 diskname TEMSDBA-REDO-TEMP-EOD
...sanemc_mount_unmount_disk_sub VERSION 2001 Diskpart Script Generated
...sanemc_mount_unmount_disk_sub VERSION 2001 d:\apps\sanemcaw\status\20707573_TEMSDBA_EOD_DATA.txt
...sanemc_mount_unmount_disk_sub VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends SELECT DISK 4 SELECT PARTITION 1 REMOVE

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 4 is now the selected disk.

Partition 1 is now the selected partition.

The selected volume has no letter to remove.
SELECT DISK 4
SELECT PARTITION 1
ASSIGN mount=D:\ORACLEDATABASES\TEMSDBAEOD\DATA01
..sanemc_mount_unmount_disk Diskpart Mount Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 4 is now the selected disk.

Partition 1 is now the selected partition.

DiskPart successfully assigned the drive letter or mount point.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Mount Complete
..sanemc_mount_unmount_disk VERSION 2000 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_mount_unmount_disk VERSION 2000 Starts
..sanemc_mount_unmount_disk D:\ORACLEDATABASES\TEMSDBAEOD\INDEX01 Not Currently Mounted
..sanemc_mount_unmount_disk Diskpart Check Path
..sanemc_mount_unmount_disk Undefined cmd_proc
..sanemc_mount_unmount_disk Resolved d:\apps\OPS\W2KRESKIT\diskpart.exe
..sanemc_mount_unmount_disk Diskpart Rescan Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Please wait while DiskPart scans your configuration...
..........
DiskPart has finished scanning your configuration.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Rescan Complete In Sleep.bat
..sanemc_mount_unmount_disk PowerMT Starts ! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk PowerMT Complete
...sanemc_mount_unmount_disk_sub VERSION 2001 Starts
...sanemc_mount_unmount_disk_sub DB: TEMSDBA
...sanemc_mount_unmount_disk_sub CLONE: EOD
...sanemc_mount_unmount_disk_sub DBL: ORACLEDATABASES
...sanemc_mount_unmount_disk_sub DBF: D:\ORACLEDATABASES\TEMSDBAEOD
...sanemc_mount_unmount_disk_sub CDI: 6006016049A61E003EF095E73E82DC11
...sanemc_mount_unmount_disk_sub PWRMT:
...sanemc_mount_unmount_disk_sub d:\apps\sanemcaw\status\20707573_powermt.txt
...sanemc_mount_unmount_disk_sub TLUN: TEMSDBA-INDEX-EOD
...sanemc_mount_unmount_disk_sub
...sanemc_mount_unmount_disk_sub Scanning ....
disk id 6006016049A61E00F6E60F096EE0DC11 diskname SYSTEMS7-EMC disk id 6006016049A61E00D4DDF9803B82DC11 diskname TEMSDBA-DATA-EOD disk id 6006016049A61E003EF095E73E82DC11 diskname TEMSDBA-INDEX-EOD disk id 6006016049A61E0008D2EC6D3D82DC11 diskname TEMSDBA-REDO-TEMP-EOD
...sanemc_mount_unmount_disk_sub VERSION 2001 Diskpart Script Generated
...sanemc_mount_unmount_disk_sub VERSION 2001 d:\apps\sanemcaw\status\20707573_TEMSDBA_EOD_INDEX.txt
...sanemc_mount_unmount_disk_sub VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends SELECT DISK 5 SELECT PARTITION 1 REMOVE

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 5 is now the selected disk.

Partition 1 is now the selected partition.

The selected volume has no letter to remove.
SELECT DISK 5
SELECT PARTITION 1
ASSIGN mount=D:\ORACLEDATABASES\TEMSDBAEOD\INDEX01
..sanemc_mount_unmount_disk Diskpart Mount Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 5 is now the selected disk.

Partition 1 is now the selected partition.

DiskPart successfully assigned the drive letter or mount point.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Mount Complete
..sanemc_mount_unmount_disk VERSION 2000 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_mount_unmount_disk VERSION 2000 Starts
..sanemc_mount_unmount_disk D:\ORACLEDATABASES\TEMSDBAEOD\REDO-TEMP01 Not Currently Mounted
..sanemc_mount_unmount_disk Diskpart Check Path
..sanemc_mount_unmount_disk Undefined cmd_proc
..sanemc_mount_unmount_disk Resolved d:\apps\OPS\W2KRESKIT\diskpart.exe
..sanemc_mount_unmount_disk Diskpart Rescan Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Please wait while DiskPart scans your configuration...
..........
DiskPart has finished scanning your configuration.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Rescan Complete In Sleep.bat
..sanemc_mount_unmount_disk PowerMT Starts ! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk PowerMT Complete
...sanemc_mount_unmount_disk_sub VERSION 2001 Starts
...sanemc_mount_unmount_disk_sub DB: TEMSDBA
...sanemc_mount_unmount_disk_sub CLONE: EOD
...sanemc_mount_unmount_disk_sub DBL: ORACLEDATABASES
...sanemc_mount_unmount_disk_sub DBF: D:\ORACLEDATABASES\TEMSDBAEOD
...sanemc_mount_unmount_disk_sub CDI: 6006016049A61E0008D2EC6D3D82DC11
...sanemc_mount_unmount_disk_sub PWRMT:
...sanemc_mount_unmount_disk_sub d:\apps\sanemcaw\status\20707573_powermt.txt
...sanemc_mount_unmount_disk_sub TLUN: TEMSDBA-REDO-TEMP-EOD
...sanemc_mount_unmount_disk_sub
...sanemc_mount_unmount_disk_sub Scanning ....
disk id 6006016049A61E00F6E60F096EE0DC11 diskname SYSTEMS7-EMC disk id 6006016049A61E00D4DDF9803B82DC11 diskname TEMSDBA-DATA-EOD disk id 6006016049A61E003EF095E73E82DC11 diskname TEMSDBA-INDEX-EOD disk id 6006016049A61E0008D2EC6D3D82DC11 diskname TEMSDBA-REDO-TEMP-EOD
...sanemc_mount_unmount_disk_sub VERSION 2001 Diskpart Script Generated
...sanemc_mount_unmount_disk_sub VERSION 2001 d:\apps\sanemcaw\status\20707573_TEMSDBA_EOD_REDO-TEMP.txt
...sanemc_mount_unmount_disk_sub VERSION 2001 (ERRORLEVEL RETURNED 0 ) Ends SELECT DISK 6 SELECT PARTITION 1 REMOVE

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 6 is now the selected disk.

Partition 1 is now the selected partition.

The selected volume has no letter to remove.
SELECT DISK 6
SELECT PARTITION 1
ASSIGN mount=D:\ORACLEDATABASES\TEMSDBAEOD\REDO-TEMP01
..sanemc_mount_unmount_disk Diskpart Mount Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Disk 6 is now the selected disk.

Partition 1 is now the selected partition.

DiskPart successfully assigned the drive letter or mount point.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Mount Complete
..sanemc_mount_unmount_disk VERSION 2000 (ERRORLEVEL RETURNED 0 ) Ends
..sanemc_mount_unmount_disk VERSION 2000 Starts
..sanemc_mount_unmount_disk D:\ORACLEDATABASES\TEMSDBAEOD\UNDO01 Not Currently Mounted
..sanemc_mount_unmount_disk Diskpart Check Path
..sanemc_mount_unmount_disk Undefined cmd_proc
..sanemc_mount_unmount_disk Resolved d:\apps\OPS\W2KRESKIT\diskpart.exe
..sanemc_mount_unmount_disk Diskpart Rescan Starts

Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: SYSTEMS7-EMC

DiskPart is starting the disk management services.

Please wait while DiskPart scans your configuration...
..........
DiskPart has finished scanning your configuration.
! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk Diskpart Rescan Complete In Sleep.bat
..sanemc_mount_unmount_disk PowerMT Starts ! ...UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0
..sanemc_mount_unmount_disk PowerMT Complete
...sanemc_mount_unmount_disk_sub VERSION 2001 Starts
...sanemc_mount_unmount_disk_sub DB: TEMSDBA
...sanemc_mount_unmount_disk_sub CLONE: EOD
...sanemc_mount_unmount_disk_sub DBL: ORACLEDATABASES
...sanemc_mount_unmount_disk_sub DBF: D:\ORACLEDATABASES\TEMSDBAEOD
...sanemc_mount_unmount_disk_sub CDI: 6006016049A61E0010DACCAB3C82DC11
...sanemc_mount_unmount_disk_sub PWRMT:
...sanemc_mount_unmount_disk_sub d:\apps\sanemcaw\status\20707573_powermt.txt
...sanemc_mount_unmount_disk_sub TLUN: TEMSDBA-UNDO-EOD
...sanemc_mount_unmount_disk_sub
...sanemc_mount_unmount_disk_sub Scanning ....
disk id 6006016049A61E00F6E60F096EE0DC11 diskname SYSTEMS7-EMC disk id 6006016049A61E00D4DDF9803B82DC11 diskname TEMSDBA-DATA-EOD disk id 6006016049A61E003EF095E73E82DC11 diskname TEMSDBA-INDEX-EOD disk id 6006016049A61E0008D2EC6D3D82DC11 diskname TEMSDBA-REDO-TEMP-EOD
...sanemc_mount_unmount_disk_sub TLUNNAME TEMSDBA-UNDO-EOD NOT Located
...sanemc_mount_unmount_disk_sub CDI 6006016049A61E0010DACCAB3C82DC11 NOT Located
...sanemc_mount_unmount_disk_sub VERSION 2001 Diskpart Script Generated
...sanemc_mount_unmount_disk_sub VERSION 2001 d:\apps\sanemcaw\status\20707573_TEMSDBA_EOD_UNDO.txt
...sanemc_mount_unmount_disk_sub VERSION 2001 (ERRORLEVEL RETURNED 11) Ends ! ..sanemc_mount_unmount_disk ERROR sanemc_mountdisks_sub ! ..sanemc_mount_unmount_disk ERROR AT
..sanemc_mount_unmount_disk VERSION 2000 (ERRORLEVEL RETURNED 5) Ends
.sanemc_oradb_maint_clone ERROR sanemc_mount_unmount_disk ERRORLEVEL=5
.sanemc_MOUNTRESET VERSION 2001 Starts CALLING \\SYSTEMS7-EMC\APPS\SANEMCAW\BIN\sanemc_mountreset.kix $app=TEMSDBA_EOD $server=SYSTEMS7-EMC

SANEMC_MOUNTRESET STARTS
*SANMOUNT Value='TEMSDBA_EOD'0
SANEMCMOUNT_SYSTEMS7-EMC Reset as FREE
SANEMC_MOUNTRESET ENDS .sanemc_MOUNTRESET VERSION 2001 (ERRORLEVEL RETURNED 0) Ends ! .sanemc_oradb_maint_clone ERROR AT
.sanemc_oradb_maint_clone VERSION 2001 (ERRORLEVEL RETURNED 5) Ends ## SOBATS ERRORLEVEL=5 ! .UTL_ERRORLEVEL ERRORLEVEL SETS VC_ERRORLEVEL=0 ## SOBATS VERSION 2003 Complete MPABATS errorlevel triggered at sobats VAR:errorlevel=5 err=0 ! d:\apps\sanemcaw\bin\SANEMC_ORADB_MAINT_CLONE.bat START:Wed 02/27/2008__11:06:14.07 FINISH:Wed 02/27/2008__11:13:11.59 ## MPABATS VERSION 2001 Complete end of D:\apps\appworx\agent\s7-emc\exec\BODY.BAT status 5 ## TROUBLE.BAT 2000 Starts at Wed 02/27/2008__11:13:11.59 In D:\apps\appworx\agent\s7-emc\exec\TROUBLE.BAT
copy D:\apps\appworx\agent\s7-emc\out\TEMSDBA_EOD_MOUNT.20707573.00.log to: D:\apps\appworx\agent\s7-emc\tmp\TEMSDBA_EOD_MOUNT.20707573.00.log.tmp

ok, I have just installed SAN Surfer on the server and it can see all the LUN's in the storage group, so I think this maybe a PowerPath issue?

Nope from here all I can see is:

Possible values for VolumeName along with current mount points are:

\\?\Volume{3f5c6a0b-0364-11dc-8e80-806d6172696f}\
C:\

\\?\Volume{d47d7071-03a5-11dc-a9fc-001279d3ee3e}\
D:\

\\?\Volume{be262c7a-07a9-11dc-aa07-001279d3ee3e}\
E:\

\\?\Volume{9881c88c-e06f-11dc-aa22-001279d3ee3f}\
X:\

\\?\Volume{3f5c6a0a-0364-11dc-8e80-806d6172696f}\
Z:\

\\?\Volume{d506ffb2-e067-11dc-a41f-806d6172696f}\
D:\oracledatabases\TEMSDBAEOD\data01\

\\?\Volume{dacc9bef-deea-11dc-aa1f-001279d3ee3f}\
D:\oracledatabases\TEMSDBAEOD\index01\

\\?\Volume{dacc9bec-deea-11dc-aa1f-001279d3ee3f}\
D:\oracledatabases\TEMSDBAEOD\redo-temp01\

can you identify them if you run mountvol command ?

Dan,
I have run into this before with some snapshot automation on our Windows hosts and maybe this will help. We are one Windows Server 2003, which is much better then Windows 2000 at the refresh of LUNs to the OS, but this may work for you.

It sounds silly but I found that if I run "admsnap rescan_devices" twice with a pause in between the commands after removing the snapshots from the storage group, and then run the command after adding each snapshot to the storage group with a short pause before adding the next snapshot, all of the snapshots would show up fine.

...worth a shot.

Aran

That's what I thought as well... Windows is terrible at doing a rescan and actually discovering new luns. It's a very small and possibly not a very satifying answer, but it's the best I can do too......

Thanks for advice I shall give this a go, as you say it's not the most satisfactory answer, but as long as I can make it reliable and repeatable then it should suffice.

I'm not sure I completely agree with the fact that windows is terrible when picking up new luns, I have worked with HP EVA and Compaq HSG80's and windows NT/2000/2003 for about 4 years now and have not had this kind of issue with them?

Aha! It looks like my problem has been fixed by the lovely EMC support people!

All I had to do was follow emc110898 and change some parameters on my qlogic HBA's.

It's now been running mount/unmounts every 10 mins for a couple of hours now.

If I'm correct some of these values are set by a simple firmware upgrade.
I've also seen the "execution throttle = 256" and "max luns per target = 256" to be needed to be able to boot from SAN.... Both that is. Just setting one didn't help.

quite possibly, I've had this on 3 servers now where the box just won't "see" and disks despite multiple rescans so I'm now carrying this out on all qlogic cards rather than just the ones mentioned in the article as I have a couple of different models and they all seem to suffer with out this change being made.

Let me know if it worked