How to add new alias into existing Zone

Posted by Syed .Z on Tuesday, October 25, 2011
Labels: , / Comments: (0)
Example:

Existing Zone name: Z_NBU_serverA_hba1

In this example, i want to add one more alias with name NBU_targets_2

Add alias into existing zone

FabricA:

FabricA:admin> zoneshow  Z_NBU_serverA_hba1
 zone:  Z_NBU_serverA_hba1
                NBU_targets_1; serverA_hba1_fab_b

Syntax:
zoneadd "ZONE_NAME", "NEW_ALIAS_NAME"

FabricA:admin> zoneadd "Z_NBU_serverA_hba1", "NBU_targets_2"

Now, we verify the zone name with newly added alias:

FabricA:admin> zoneshow  Z_NBU_serverA_hba1
 zone:  Z_NBU_serverA_hba1
                NBU_targets_1; serverA_hba1_fab_b;NBU_targets_2

MySQL Dump Script for Windows

Posted by Syed .Z on Saturday, October 08, 2011
Labels: / Comments: (0)
This is my simple script used to do a mysqldump on Windows server and then associate it with Windows Scheduler task. 

Mysqldump syntax, there are three general ways to invoke mysqldump: 
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] --databases db_name1 [db_name2 db_name3...]
shell> mysqldump [options] --all-databases


I found few other script here and there and i combine it in one script here:


REM [at] echo off

for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i

for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i
for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i
for /f %%i in ('time /t') do set DATE_TIME=%%i
for /f %%i in ('echo %date_time::=-%') do set DATE_TIME=%%i

"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqldump" -u root -p207007 --all-databases> "C:\mySQL_Backup\%DATE_DAY%_%DATE_TIME%_db.sql"

"C:\Program Files\7-Zip\7z.exe" a -t7z "C:\mySQL_Backup\%DATE_DAY%_%DATE_TIME%_db.7z" "C:\mySQL_Backup\%DATE_DAY%_%DATE_TIME%_db.sql"

del "C:\mySQL_Backup\%DATE_DAY%_%DATE_TIME%_db.sql"
 Here is the sample output on Windows command :
C:\>REM [at] echo off
C:\>for /F "tokens=1" %i in ('date /t') do set DATE_DOW=%i
C:\>set DATE_DOW=Wed
C:\>for /F "tokens=2" %i in ('date /t') do set DATE_DAY=%i
C:\>set DATE_DAY=10/05/2011
C:\>for /F %i in ('echo 10-05-2011') do set DATE_DAY=%i
C:\>set DATE_DAY =10-05-2011
C:\>for /F %i in  ('time /t') do set DATE_TIME=%i
C:\>set DATE_TIME=04:48
C:\>for /F %i in  ('echo 04-48') do set DATE_TIME=%i
C:\>set DATE_TIME=04-48
C:\>"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqldump" -u root -p207007 --all-databases 1>"C:\mySQL_Backup\10-05-2011_04-48_db.sql"

C:\>"C:\Program Files\7-Zip\7z.exe" a -t7z "C:\mySQL_Backup\10-05-2011_04-48_db.7z" "C:\mySQL_Backup\10-05-2011_04-48_db.sql"

7-Zip 9.20  Copyright (c) 1999-2010 Igor Pavlov  2010-11-18
Scanning

Creating archive C:\mySQL_Backup\10-05-2011_04-48_db.7z

Compressing  10-05-2011_04-48_db.sql   56%


The compressing will show you the percentage complete, and once compressing complete it will delete the original sql dump file.

7-Steps :Continual Service Improvement

Posted by Syed .Z on Sunday, September 25, 2011
Labels: / Comments: (0)

4 P’s of IT Service Management

Posted by Syed .Z
Labels: / Comments: (0)
  • People (including skills, experience, knowledge, culture and communication)
  • Processes (including policies, role descriptions, usability and measurability)
  • Products (technology, including performance, price and support)
  • Partners (suppliers, including contracts, monitoring and reporting)

FT pipes are in use

Posted by Syed .Z on Saturday, September 24, 2011
Labels: / Comments: (0)
In a SAN Client environment, sometime we will see this errors while the jobs seems running but actually its queuing waiting for the FT Pipes to be opened.  But, often the FT pipes are available but some of them has been orphaned due to CORBA exception during cleanup. And if its reached time out you will get error code 83 on netbackup job.

In the Job Details, this will indicates and show you the FT Pipes are in use:
Sep 23, 2011 7:02:09 AM - awaiting resource stug-dpad_nbx_01. Waiting for resources.
          Reason: FT pipes are in use, Media server: nbu004.net2.com,
          Robot Type(Number): NONE(N/A), Media ID: N/A, Drive Name: N/A,
          Volume Pool: NetBackup, Storage Unit: stu-dpad_nbu004_01, Drive Scan Host: N/A,
          Disk Pool: dpad_nbu004_01, Disk Volume: /opt/openv/dpad_nbu004_01_06
Now, we list the orphaned pipes:
# /usr/openv/netbackup/bin/admincmd/nbrbutil -listOrphanedPipes

Pipe ID         Pipe State              Media Server
==============================================================================
3               PIPE_ORPHANED           nbu002.net2.com
10              PIPE_ORPHANED           nbu005.net2.com
12              PIPE_ORPHANED           nbu005.net2.com
13              PIPE_ORPHANED           nbu005.net2.com
14              PIPE_ORPHANED           nbu005.net2.com
15              PIPE_ORPHANED           nbu005.net2.com
16              PIPE_ORPHANED           nbu005.net2.com
4               PIPE_ORPHANED           nbu006.net2.com
5               PIPE_ORPHANED           nbu006.net2.com
6               PIPE_ORPHANED           nbu006.net2.com
7               PIPE_ORPHANED           nbu006.net2.com
8               PIPE_ORPHANED           nbu006.net2.com
9               PIPE_ORPHANED           nbu006.net2.com
10              PIPE_ORPHANED           nbu006.net2.com
11              PIPE_ORPHANED           nbu006.net2.com
12              PIPE_ORPHANED           nbu006.net2.com
13              PIPE_ORPHANED           nbu006.net2.com
15              PIPE_ORPHANED           nbu006.net2.com
16              PIPE_ORPHANED           nbu006.net2.com
16              PIPE_ORPHANED           nbu008.net2.com
1               PIPE_ORPHANED           nbu009.net2.com
3               PIPE_ORPHANED           nbu009.net2.com
4               PIPE_ORPHANED           nbu009.net2.com
5               PIPE_ORPHANED           nbu009.net2.com
6               PIPE_ORPHANED           nbu009.net2.com
7               PIPE_ORPHANED           nbu009.net2.com
8               PIPE_ORPHANED           nbu009.net2.com
9               PIPE_ORPHANED           nbu009.net2.com
14              PIPE_ORPHANED           nbu009.net2.com
15              PIPE_ORPHANED           nbu009.net2.com
16              PIPE_ORPHANED           nbu009.net2.com
8               PIPE_ORPHANED           nbu002.net2.com
12              PIPE_ORPHANED           nbu002.net2.com
1               PIPE_CLIENT_ORPHANED    nbu003.net2.com
2               PIPE_CLIENT_ORPHANED    nbu003.net2.com
3               PIPE_CLIENT_ORPHANED    nbu003.net2.com
4               PIPE_CLIENT_ORPHANED    nbu003.net2.com
5               PIPE_CLIENT_ORPHANED    nbu003.net2.com
6               PIPE_CLIENT_ORPHANED    nbu003.net2.com
7               PIPE_CLIENT_ORPHANED    nbu003.net2.com
8               PIPE_CLIENT_ORPHANED    nbu003.net2.com
9               PIPE_CLIENT_ORPHANED    nbu003.net2.com
10              PIPE_CLIENT_ORPHANED    nbu003.net2.com
11              PIPE_CLIENT_ORPHANED    nbu003.net2.com
12              PIPE_CLIENT_ORPHANED    nbu003.net2.com
13              PIPE_CLIENT_ORPHANED    nbu003.net2.com
14              PIPE_CLIENT_ORPHANED    nbu003.net2.com
15              PIPE_CLIENT_ORPHANED    nbu003.net2.com
16              PIPE_CLIENT_ORPHANED    nbu003.net2.com
1               PIPE_CLIENT_ORPHANED    nbu004.net2.com
2               PIPE_CLIENT_ORPHANED    nbu004.net2.com
3               PIPE_CLIENT_ORPHANED    nbu004.net2.com
4               PIPE_CLIENT_ORPHANED    nbu004.net2.com
6               PIPE_CLIENT_ORPHANED    nbu004.net2.com
7               PIPE_CLIENT_ORPHANED    nbu004.net2.com
8               PIPE_CLIENT_ORPHANED    nbu004.net2.com
9               PIPE_CLIENT_ORPHANED    nbu004.net2.com
10              PIPE_CLIENT_ORPHANED    nbu004.net2.com
11              PIPE_CLIENT_ORPHANED    nbu004.net2.com
12              PIPE_CLIENT_ORPHANED    nbu004.net2.com
13              PIPE_CLIENT_ORPHANED    nbu004.net2.com
14              PIPE_CLIENT_ORPHANED    nbu004.net2.com
15              PIPE_CLIENT_ORPHANED    nbu004.net2.com
16              PIPE_CLIENT_ORPHANED    nbu004.net2.com
1               PIPE_CLIENT_ORPHANED    nbu005.net2.com
2               PIPE_CLIENT_ORPHANED    nbu005.net2.com
3               PIPE_CLIENT_ORPHANED    nbu005.net2.com
4               PIPE_CLIENT_ORPHANED    nbu005.net2.com
5               PIPE_CLIENT_ORPHANED    nbu005.net2.com
6               PIPE_CLIENT_ORPHANED    nbu005.net2.com
7               PIPE_CLIENT_ORPHANED    nbu005.net2.com
8               PIPE_CLIENT_ORPHANED    nbu005.net2.com
9               PIPE_CLIENT_ORPHANED    nbu005.net2.com
11              PIPE_CLIENT_ORPHANED    nbu005.net2.com
2               PIPE_CLIENT_ORPHANED    nbu006.net2.com
1               PIPE_CLIENT_ORPHANED    nbu006.net2.com
14              PIPE_CLIENT_ORPHANED    nbu006.net2.com
1               PIPE_CLIENT_ORPHANED    nbu007.net2.com
2               PIPE_CLIENT_ORPHANED    nbu007.net2.com
3               PIPE_CLIENT_ORPHANED    nbu007.net2.com
4               PIPE_CLIENT_ORPHANED    nbu007.net2.com
5               PIPE_CLIENT_ORPHANED    nbu007.net2.com
6               PIPE_CLIENT_ORPHANED    nbu007.net2.com
7               PIPE_CLIENT_ORPHANED    nbu007.net2.com
8               PIPE_CLIENT_ORPHANED    nbu007.net2.com
9               PIPE_CLIENT_ORPHANED    nbu007.net2.com
10              PIPE_CLIENT_ORPHANED    nbu007.net2.com
11              PIPE_CLIENT_ORPHANED    nbu007.net2.com
12              PIPE_CLIENT_ORPHANED    nbu007.net2.com
13              PIPE_CLIENT_ORPHANED    nbu007.net2.com
14              PIPE_CLIENT_ORPHANED    nbu007.net2.com
15              PIPE_CLIENT_ORPHANED    nbu007.net2.com
16              PIPE_CLIENT_ORPHANED    nbu007.net2.com
1               PIPE_CLIENT_ORPHANED    nbu008.net2.com
2               PIPE_CLIENT_ORPHANED    nbu008.net2.com
3               PIPE_CLIENT_ORPHANED    nbu008.net2.com
4               PIPE_CLIENT_ORPHANED    nbu008.net2.com
5               PIPE_CLIENT_ORPHANED    nbu008.net2.com
6               PIPE_CLIENT_ORPHANED    nbu008.net2.com
7               PIPE_CLIENT_ORPHANED    nbu008.net2.com
8               PIPE_CLIENT_ORPHANED    nbu008.net2.com
9               PIPE_CLIENT_ORPHANED    nbu008.net2.com
10              PIPE_CLIENT_ORPHANED    nbu008.net2.com
11              PIPE_CLIENT_ORPHANED    nbu008.net2.com
12              PIPE_CLIENT_ORPHANED    nbu008.net2.com
13              PIPE_CLIENT_ORPHANED    nbu008.net2.com
14              PIPE_CLIENT_ORPHANED    nbu008.net2.com
15              PIPE_CLIENT_ORPHANED    nbu008.net2.com
6               PIPE_CLIENT_ORPHANED    nbu002.net2.com
10              PIPE_CLIENT_ORPHANED    nbu002.net2.com
14              PIPE_CLIENT_ORPHANED    nbu002.net2.com
16              PIPE_CLIENT_ORPHANED    nbu002.net2.com


As you can see, i have a lot of orphaned PIPES to be cleared.  Run below command to release the orphaned pipes:
# /usr/openv/netbackup/bin/admincmd/nbrbutil  -releaseOrphanedPipes
 List back if there's anymore orphaned pipes , it should be gone by now:
# /usr/openv/netbackup/bin/admincmd/nbrbutil -listOrphanedPipes

RACI Matrix for ITIL v3

Posted by Syed .Z
Labels: / Comments: (0)

Unix command to list based on the file size

Posted by Syed .Z
Labels: / Comments: (0)
Unix command to list based on the file size:
ls -al | sort -rn +4

Example:
bash-2.03#  ls -al | sort -rn +4
-rw-rw-r--   1 root     sys       811680 Sep 12 10:01 ups_data
-rw-rw-rw-   1 root     root      131244 Sep  7 16:49 .Perflib
-rw-rw-r--   1 root     sys        76764 Sep 21 22:51 mibiisa_ps_data
-rw-r-----   1 root     other      35454 Sep 23 14:23 net.client.list
drwxrwxrwt  25 root     sys         6344 Sep 24 11:00 .
drwxr-xr-x  66 root     root        2560 Sep 23 07:11 ..
-rw-r--r--   1 root     other       2470 Sep 23 08:30 cleaning_tape_status.txt
-rw-rw-r--   1 root     sys         1740 Sep  7 16:49 ps_data
-rw-r--r--   1 root     other        473 Sep 23 13:30 mail_available_scratch_tapes.txt
-rw-r--r--   1 root     other        372 Sep 23 07:11 jrd_get_daily_backup_data.log
-rwxr-x---   1 root     other        268 Sep 23 14:07 client.list
drwx------   2 root     root         182 Sep  7 16:51 smc898
drwxrwxr-x   2 root     root         176 Sep  7 16:52 .X11-unix
drwxrwxr-x   2 root     root         176 Sep  7 16:52 .X11-pipe
-rw-r--r--   1 root     other        168 Sep 23 08:30 cleaning_tape_status2.txt
-rw-r-----   1 root     root         167 Sep 22 01:02 homes.5324
-rw-r-----   1 root     root         167 Sep  8 01:02 homes.19705
-rw-------   1 root     other        160 Sep 20 13:54 .dr_extra_info

Tech Support Cheat Sheet

Posted by Syed .Z on Wednesday, September 14, 2011
/ Comments: (0)
Hahaha: http://xkcd.com/627/

How to get total usage of disk space

Posted by Syed .Z
/ Comments: (0)
How to get total usage of disk space

This is my df -k output:

bash-2.03# df -kl
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/md/dsk/d1       6198606 4706544 1430076    77%    /
/proc                      0       0       0     0%    /proc
mnttab                     0       0       0     0%    /etc/mnttab
fd                         0       0       0     0%    /dev/fd
/dev/md/dsk/d2       6198606 1295354 4841266    22%    /var
swap                 28122232      24 28122208     1%    /var/run
dmpfs                28122208       0 28122208     0%    /dev/vx/dmp
dmpfs                28122208       0 28122208     0%    /dev/vx/rdmp
swap                 28158368   36160 28122208     1%    /tmp
/dev/vx/dsk/datadg/pk1env
                       61440    2168   55573     4%    /pk1env
/dev/vx/dsk/datadg/RD
                     26288128  337377 24329013     2%    /RD
/dev/vx/dsk/datadg/saswork
                     104857600   29157 98277953     1%    /saswork
/dev/vx/dsk/data2dg/arenv_dev
                     52428800   96912 49062058     1%    /arenv_dev
/dev/vx/dsk/datadg/ora_vol
                     10485760 3238372 6794469    33%    /oracle
/dev/vx/dsk/datadg/arenv_uat
                     104857600 51733220 49809874    51%    /arenv_uat
/dev/vx/dsk/datadg/dmenv
                     316518719 218121659 92248055    71%    /dmenv
/dev/vx/dsk/datadg/inet
                     419430400 156786469 246229944    39%    /inet
/dev/vx/dsk/datadg/arenv
                     311907385 233406838 73606015    77%    /arenv
/dev/md/dsk/d4       1021735  439771  520660    46%    /opt/patrol
/dev/vx/dsk/datadg/usrlocal
                      122880   38592   80015    33%    /usr/local
/dev/vx/dsk/datadg/localapps
                     14680064 8824440 5490473    62%    /local/apps

This is the script:

bash-2.03#  df -kl | awk '/^\/dev\// { avail += $3/1024 } END { printf("%d Mb used\n",avail)} '
663141 Mb used
Source

BESR (Backup Exec Server Recovery) - Recover from Physical Server to Hyper-V VM

Posted by Syed .Z on Friday, May 20, 2011
Labels: / Comments: (1)

 

It takes me few weeks of WebEx and the case was pass from Support team to Sr Advance Team engineer to tell me this:

- The previous system being a EFI based 64 bit machine the 32 bit  bootloader of the SRD is not able to recognize the command bcdedit and bootrec.
- The EFI based systems are not supported.
- That is why on the original system BESR is unable to see the EFI (system reserved partition) and on the restored hyper-V virtual machine the the bcdedit and bootrec is not working.

Below are my discussion with fellow Symantec forum members:

https://www-secure.symantec.com/connect/forums/besr-physical-server-hyper-v#comment-5591131

 I will write a full articles on Backup Exec Server Recovery 2010 with Hyper-V on PowerEdge R710 connected to DELLMD1200.

Notes: Windows 2003 server with Dell Utility partition works like charm