Security expolit on Netbackup (No.Restrictions)

Sometimes we or some consultants put No.Restrictions file in “INSTALL DIR\netbackup\db\altnames” directory, this option  makes our work easier. But it is a security risk, because of every netbackup client on the your network can restore data from any other clients. So, anybody can restore data of your important servers, then they can lookup and/or copy your important datas. To close this security exploit, you must delete the file No.Restrictions.


Netbackup status code 239

Problem Tanımı: Günlerce, haftalarca hatta aylarca düzgün yedek aldıktan sonra birden bire aşağıdaki hata kodunu ve ekran görüntüsünü almaya başladıysanız, bu çözüm sizin için:

Hata Kodu: 239

Ekran Görüntüsü:

 hatakodu239

Ana job:
4/19/2014 11:43:48 PM - Info nbjm(pid=5772) starting backup job (jobid=1627586) for client clientname, policy MSSQL_clientname_DBNAME_test, schedule Full_1M 4/19/2014 11:43:48 PM - Info nbjm(pid=5772) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1627586, request id:{30E2C633-C9C4-4520-9F0B-F291957FDA12})
4/19/2014 11:43:48 PM - requesting resource stu_disk_sp-nbappliance21
4/19/2014 11:43:48 PM - requesting resource masterserver.domain.com.NBU_CLIENT.MAXJOBS.clientname
4/19/2014 11:43:48 PM - requesting resource masterserver.domain.com.NBU_POLICY.MAXJOBS.MSSQL_clientname_DBNAME_test
4/19/2014 11:43:48 PM - granted resource masterserver.domain.com.NBU_CLIENT.MAXJOBS.clientname
4/19/2014 11:43:48 PM - granted resource masterserver.domain.com.NBU_POLICY.MAXJOBS.MSSQL_clientname_DBNAME_test
4/19/2014 11:43:48 PM - granted resource stu_disk_sp-nbappliance21
4/19/2014 11:43:48 PM - estimated 0 Kbytes needed
4/19/2014 11:43:48 PM - Info nbjm(pid=5772) started backup (backupid=clientname_1397940228) job for client clientname, policy MSSQL_clientname_DBNAME_test, schedule Full_1M on storage unit stu_disk_sp-nbappliance21
4/19/2014 11:43:49 PM - started process bpbrm (9628)
4/19/2014 11:43:54 PM - connecting
4/19/2014 11:43:54 PM - Info bpbrm(pid=9628) clientname is the host to backup data from    
4/19/2014 11:43:54 PM - Info bpbrm(pid=9628) reading file list for client       
4/19/2014 11:43:55 PM - Info bpbrm(pid=9628) starting bphdb on client        
4/19/2014 11:43:55 PM - Info bphdb(pid=15948) Backup started          
4/19/2014 11:43:55 PM - connected; connect time: 0:00:01
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) INF - BACKUP STARTED USING       
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) Microsoft SQL Server 2012 (SP1) - 11.0.3381.0 (X64)    
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) Aug 23 2013 20:08:13        
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) Copyright (c) Microsoft Corporation        
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) Batch = C:\Nbu_Scripts\full_dbname.bch, Op# = 1      
4/19/2014 11:43:57 PM - Info dbclient(pid=17552) INF - Using backup images SP-clientNODEB.MSSQL7.clientname.db.dbname.~.7.001of008.20140419234356..C to SP-clientNODEB.MSSQL7.clientname.db.North008of008.20140419234356.C    
4/19/2014 11:43:58 PM - Info dbclient(pid=17552) INF - backup database "dbname" to VIRTUAL_DEVICE='VNBU0-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU1-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU2-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU3-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU4-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU5-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU6-17552-15940-1397940237', VIRTUAL_DEVICE='VNBU7-17552-15940-1397940237' with  stats = 10, blocksize = 65536, maxtransfersize = 65536, buffercount = 16
4/19/2014 11:43:58 PM - Info dbclient(pid=17552) INF - Number of stripes: 8, Number of buffers per stripe 2.
4/19/2014 11:43:58 PM - Info dbclient(pid=17552) INF - Created VDI object for SQL Server instance <clientname.anadolu.com>. Connection timeout is <300> seconds.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in GetCommand: 0x80770004.      
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/19/2014 11:44:17 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:18 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:19 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:19 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:20 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:20 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:20 PM - Info dbclient(pid=17552) INF - OPERATION #1 of batch C:\Nbu_Scripts\full_dbname.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 24(24) seconds.
4/19/2014 11:44:21 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:21 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:22 PM - Info dbclient(pid=17552) ERR - Error in VxBSACreateObject: 3.      
4/19/2014 11:44:22 PM - Info dbclient(pid=17552)     CONTINUATION: - System detected error, operation aborted. 
4/19/2014 11:44:22 PM - Info dbclient(pid=17552) INF - Results of executing <C:\Nbu_Scripts\full_dbname.bch>:      
4/19/2014 11:44:22 PM - Info dbclient(pid=17552) <0> operations succeeded. <1> operations failed.      
4/19/2014 11:44:22 PM - Info dbclient(pid=17552) INF - The following object(s) were not backed up successfully.  
4/19/2014 11:44:22 PM - Info dbclient(pid=17552) INF - dbname         
4/19/2014 11:44:22 PM - Error bpbrm(pid=9628) from client clientname: ERR - command failed: none of the requested files were backed up (2)
4/19/2014 11:44:22 PM - Error bpbrm(pid=9628) from client clientname: ERR - bphdb exit status = 2: none of the requested files were backed up
4/19/2014 11:44:27 PM - Info bphdb(pid=15948) done. status: 2: none of the requested files were backed up 
4/19/2014 11:44:27 PM - end writing
none of the requested files were backed up(2)


Child job:


 hatakodu239_child_job

Çözüm:

MSSQL yedeklerinde kullandığınız script içerisindeki sunucu adı ile politika içerisindeki sunucu adı birebir aynı olmasını sağlayın. Birinin sonunda domain adı var diğerinde yok ise eksik olana domain adını ekleyin. Biri küçük harf, diğeri büyük harfler ile yazılmış ise ikisininde karakter büyüklüklerini birebir aynı yapın. Sorun düzelecektir.

 


“Policy Storage” değiştirildikten sonra eski “storage unit” ten yedek almaya devam etme problemi

Netbackup Version: 7.6.0.1

Hata Tanımı: Politika içerisinden “policy storage” kısmındaki yedekleme yapılacak yeri değiştirmemize rağmen yedeği eski yere almaya devam etmesi.

Geçici Çözüm: Politikaya sağ tıklayarak “Copy to New Policy” seçeneğini seçmek, yeni politika üzerinden yedeklemeye devam etmek.

Kalıcı çözüm: Her zaman olduğu gibi, muhtemelen versiyon güncelleme gerekmektedir 🙂 Bulanlar bana e-posta atar ise burda yayımlarım.


Netbackup ‘ da senelerdir uğraştıran MSSQL yedeğinde yarıda kesilme problemi ve çözümü

Netbackup kullanmaya başladım başlayalı bir yarıda kesilme problemidir, gidiyordu. Açılan caseler, yapılan çalışmalar fayda vermiyordu ki en son yurt dışından gelen mühendis kök sebebi tam olarak bulamasada bir çözüme kavuşturdu. Ben çektim, siz çekmeyin. Buyrun çözüm:

Read More


interrupt when backup large SQL databases

netbackup appliance test results

 

Yaptığımız tüm testlere rağmen 3 ay boyunca problem networkten dediler, en son sunucu ile netbackup appliance’i arka arkaya bağlayınca yukardaki sonuç göründü.  Bundan sonraki aşamada bulunanları bir sonraki makalede yazacağım.

Link: http://www.symantec.com/connect/forums/interrupt-when-backup-large-sql-databases