How to empty file without delete/recreate or VI

This is simpler way to empty a file in bash, few options for you to choose:

Option 1:

bash# cat /dev/null > [filename]

Option 2:

bash# > [filename]

Option 3:

bash# echo -n > [filename]

Option 4:

bash# cat > [filename]
and then Press Ctrl -D

Netbackup MS-SQL Backup Processes

If you tried to cancelled backup jobs from NBU GUI but the next stream still keep spawned a new job (in a case where many Database in one server).  This process call dbbackex.exe on the MS SQL Client will still be listed as running in Task Manager. If several MS SQL backups have failed, an identical number of dbbackex.exe instances will be listed in Task Manager. These can safely be killed.  The reason for the hang is that the error message returned by the SQL Server is not being handled by dbbackex.exe and this process dbbackex.exe  can be killed if the MS-SQL backup job wont killed.


The correct behavior in such a situation is that dbbackex.exe should skip the database and continue to back up the remaining databases




More details on DBBACKEX.exe Taken from NBU for MS-SQL Server admin Guide.

■ The NetBackup for SQL Server GUI (dbbackup.exe) allows you to browse for

SQL Server objects, normally, databases, filegroups, and database files.

dbbackup.exe invokes dbbackmain.dll (8) for accessing the SQL Server

master database. NetBackup for SQL Server accesses information about SQL

Server using ODBC.

■ The NetBackup for SQL Server GUI (dbbackup.exe) also allows you to browse

for SQL backup images. The NetBackup catalog contains the images you can

browse. To access the contents of the catalog the GUI invokes

dbbackmain.dll, which uses VxBSA function calls to access the NetBackup

Server database manager.

Symantec NetBackup Ends the Backup Window with 100 Times Faster Backups

Symantec is delivering a new approach to data protection and introducing NetBackup 7.5 with new options, including NetBackup Accelerator to speed backups by up to 100 times while delivering “Instant Full Recovery” capability, NetBackup Replication Director to integrate NetApp® Snapshots™ with backup, and NetBackup Search to allow simple search and recovery of backup data and selective legal hold. Unlike other backup technology that relies on the IT team to integrate multiple disparate backup solutions, NetBackup is available as a single integrated appliance for the data center, remote office and virtual environments, providing customers with simplified deployment and operations.




Read more on Symantec Press Release HERE

Netbackup Media in use

ERROR: When attempting a restore, the required media will not mount, stating "Media is in use", when it is known that the media is not physically in use. The restore appears to hang.

We can release the media by the allocationKey :

backupserver-root /usr/openv/netbackup/bin/admincmd: ./nbrbutil -dump > /var/tmp/nbrb.out

 Media ID in this case is SL2531

backupserver-root /usr/openv/netbackup/bin/admincmd: cat /var/tmp/nbrb.out |grep SL2531
         index=0 (Request provider=TapeSpanProvider resourcename=NEXT MEDIA RESOURCE  userSequence=0 (mediatapespanrequest: request=(MediaRequest: mediaId=SL2531 mediaServer=mediaserver1.int.com mediaKey=0 userReservationId= assignedTime=1324299337 client=uk1us00001.corpnet2.com usageType=2 mustBeNdmp=no driveName=STVDSADI001_P1_20 drivePath= mediaPool= robotNumber=-1 slotNumber=-1 density=-1 ndmpControlHost= failIfNoMedia=yes externalFile= mediaType=2 mediaSubType=0 isNdmp=false isTirRestore=false isFlashbackupRestore=false isBlockMapRead=false isCatalogBackup=false isGcsCatalogBackup=false isVMWare=false isLifeCycle=false preferVtlToDirectAttachedTape=true) previousid={E371B58A-1DD1-11B2-913D-0003BA36C061} previousFailed=no)))
        MdsAllocation: allocationKey=455557 jobType=2 mediaKey=4005380 mediaId=SL2531 driveKey=0 driveName= drivePath= stuName= masterServerName=stvsxbak03.ggr.co.uk mediaServerName=mediaserver1.int.com ndmpTapeServerName= diskVolumeKey=0 mountKey=0 linkKey=0 fatPipeKey=0 scsiResType=0 serverStateFlags=0

Now release the media by referring its allocation ID which is 455557:

backupserver-root /usr/openv/netbackup/bin/admincmd: ./nbrbutil -releaseMDS 455557

Refer here for more information.

How to verify backup status using Avamar MCCLI

This guide is to help you to verify backup status from Avamar Utility Node. If you find using GUI is too slow to validate backup of hundreds of failed client, you can use this command which later you can customize a script and sent to your email etc2.

Syntax:
mccli activity show [GLOBAL-OPTIONS] [--active=Boolean(false)]
[--completed=Boolean(false)] [--domain=STRING]
[--queued=Boolean(false)] --name=STRING [--verbose=Boolean(false)]
[DISPLAY-OPTIONS]

--active=Boolean(false) If set true, only currently running activities are returned.
--completed=Boolean(false) If set true, only completed activities are returned.
--domain=STRING Specifies Avamar server domain containing the client specified by the --name argument.
If this option is suppled and --name is not supplied, all activities within that domain are shown.
--name=STRING Specifies client for which activities should be shown.
IMPORTANT: If a fully-qualified client name (for example, /clients/MyClient) is supplied, the --domain argument is ignored.
--queued=Boolean(false) If set true, only queued activities are returned.
--verbose=Boolean(false) If set true, detailed (verbose) activity information is returned. If set false or not supplied, summary
information is returned.

Example:

root@AVAMAR2-01:~/#:  mccli activity show --domain=/clients --name=petai.internal.com0,23000,CLI command completed successfully.ID               Status          Error Code Start Time           Elapsed     End Time             Type               Progress Bytes New Bytes---------------- --------------- ---------- -------------------- ----------- -------------------- ------------------ -------------- ---------1325749602471357 Completed       0          2012-01-05 02:46 GMT 00h:00m:30s 2012-01-05 02:47 GMT Replication Source 17,785,115,628 0.3%9132563981301809 Completed       0          2012-01-03 20:22 GMT 00h:10m:16s 2012-01-03 20:32 GMT Scheduled Backup   10,058,429,430 0.2%9132555240085809 Completed       0          2012-01-02 20:13 GMT 00h:10m:13s 2012-01-02 20:23 GMT Scheduled Backup   10,048,182,833 0.1%9132572629437809 Completed       0          2012-01-04 20:23 GMT 00h:12m:45s 2012-01-04 20:36 GMT Scheduled Backup   10,364,971,854 0.2%9132563880102609 Dropped Session 0          2012-01-03 20:00 GMT 00h:16m:50s 2012-01-03 20:16 GMT Scheduled Backup   228,208,607    <0.05%9132572520094709 Dropped Session 0          2012-01-04 20:00 GMT 00h:18m:12s 2012-01-04 20:18 GMT Scheduled Backup   205,595,909    <0.05%9132574628474509 Completed       0          2012-01-05 01:51 GMT 00h:03m:22s 2012-01-05 01:54 GMT On-Demand Backup   10,384,285,025 0.3%1325663022756671 Completed       0          2012-01-04 02:43 GMT 00h:00m:30s 2012-01-04 02:44 GMT Replication Source 8,604,757,950  0.2%1325573948329840 Completed       0          2012-01-03 01:59 GMT 00h:00m:00s 2012-01-03 01:59 GMT Replication Source 8,687,492,631  0.2% 

If you want to filter only the complete session add –completed argument:

root@AVAMAR2-01:~/#: mccli activity show --domain=/clients --name=petai.internal.com --completed=true
0,23000,CLI command completed successfully.
ID               Status          Error Code Start Time           Elapsed     End Time             Type               Progress Bytes New Bytes
---------------- --------------- ---------- -------------------- ----------- -------------------- ------------------ -------------- ---------
1325574080407145 Completed       0          2012-01-03 02:01 GMT 00h:00m:00s 2012-01-03 02:01 GMT Replication Source 8,772,149,532  0.2%
1325749741228668 Completed       0          2012-01-05 02:49 GMT 00h:00m:00s 2012-01-05 02:49 GMT Replication Source 8,943,263,903  0.2%
9132563520048709 Dropped Session 0          2012-01-03 19:00 GMT 00h:16m:45s 2012-01-03 19:16 GMT Scheduled Backup   240,225,638    <0.05%
9132572160051009 Dropped Session 0          2012-01-04 19:00 GMT 00h:16m:49s 2012-01-04 19:16 GMT Scheduled Backup   210,904,174    0%
9132563620592309 Completed       0          2012-01-03 19:24 GMT 00h:20m:11s 2012-01-03 19:44 GMT Scheduled Backup   9,834,628,293  0.2%
1325663189759348 Completed       0          2012-01-04 02:46 GMT 00h:00m:00s 2012-01-04 02:46 GMT Replication Source 8,642,061,742  0.3%
9132572261614109 Completed       0          2012-01-04 19:27 GMT 00h:21m:39s 2012-01-04 19:48 GMT Scheduled Backup   10,155,148,114 0.2% 

How to initiate image clean up manually

How to initiate image clean up manually against all media server.

#/usr/openv/netbackup/bin/admincmd/bpimage -cleanup -allclients

NBU 7.X: All UNIX 32-bit system support has been discontinued

 From the NetBackup 7.0 Release Notes: "...
All UNIX 32-bit system support has been discontinued. To upgrade these systems to NetBackup 7.0, you must first migrate your current NetBackup 6.x catalogs and databases to a system with a supported platform. However, 32-bit media servers and clients that use NetBackup 6.x are compatible with 64-bit master servers that use NetBackup 7.0.

How to add new alias into existing Zone

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

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