Hi All,
This is neto from Brazil
How are you?
Here you go an example about remote connection using SnapDrive for Windows installed on Backup Server to connect consistent snapshots from SnapManager for Oracle 2.2 to be used for TAPE Backups.
Thank you very much my friends Ederson and Kleber for the pleasure and all support on this work.
Script to Connect
REM ##############################################################
@echo off
REM
REM CREATED BY Ederson Crippa (BSH CONTINENTAL), neto from Brazil (NetApp) and Kleber Silva (Columbia Storage)
REM
echo *** Setting Global Variables ***
echo ********************************
SET FILER=HORNA002
SET BACKUPSERVER=HORWNW01
SET CLUSTER=HORWDBCL01
SET VIRTUALSERVER=HORWDBCL01VS01
echo.
echo *** Mapping DATAFILES for Backup ***
echo ************************************
SET VOL=/vol/gfadata/.snapshot
SET LUN=GFADATA.lun
SET DEST_MAP=G:\HORPGFA\HORPGFA
SET DEST_SNAP=G:\HORPGFA
SET FILE=GF_RECENT_DATA.TXT
sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%
FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%
echo.
echo *** Mapping LOGS for Backup ***
echo ********************************
SET VOL=/vol/gfalogs/.snapshot
SET LUN=GFALOGS.lun
SET DEST_MAP=G:\HORPGFA\ORALOGS
SET DEST_SNAP=G:\HORPGFA\ORALOGS
SET FILE=GF_RECENT_LOGS.TXT
sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%
FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%
echo.
echo *** Mapping ARCHIVES for Backup ***
echo ************************************
SET VOL=/vol/gfaarch/.snapshot
SET LUN=GFAARCH.lun
SET DEST_MAP=G:\HORPGFA\ORAARCH
SET DEST_SNAP=G:\HORPGFA\ORAARCH
SET FILE=GF_RECENT_ARCH.TXT
sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%
FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%
REM ##############################################################
Script to Disconnect
REM ##############################################################
@echo off
REM
REM CREATED BY Ederson Crippa (BSH CONTINENTAL), neto from Brazil (NetApp) and Kleber Silva (Columbia Storage)
REM
echo *** Disconnecting DATAFILES ***
echo *******************************
sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\HORPGFA\
echo.
echo *** Disconnecting LOGS ***
echo **************************
sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\ORALOGS\
echo.
echo *** Disconnecting ARCHIVES ***
echo ******************************
sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\ORAARCH\
REM ##############################################################
All the best
neto
NetApp - I love this company!
Comments