Database

259 Topics

Symantec Netbackup 7 licensing
Hi All, I'd like to know if I'm getting this correctly. I'm planning to getNetbackup 7 Starter Editionaccording tob-symc_netbackup_7_core_DS_12995286-2.en-us.pdf(http://eval.symantec.com/mktginfo/enterprise/fact_sheets/b-symc_netbackup_7_core_DS_12995286-2.en-us.pdf)Table 2. the Edition comparison the Starter Edition can have 5 Server (supported clients) does this means i can have the following backup items: 1x ESXi 4 server (using vStorage API for inline deduplication - Change Block Tracking) 1x Solaris SPARC + Oracle DB 10gR2 1x Linux 1x Windows Server + Share Point 2007 (Granular restore) 1x Windows Server + Exchange Server 2007(Granular restore) all of the above with bare metal restore capability. Since it is said that i could have: Server Clients, Tape Drive and Database Agents included ? yes I understand that Deduplication is not included here since it will need another license to spend. I'm getting confused here of which product that i should get :-| Would be good if anyone can clarify this please ?
Solved
Symanticus
15 years ago Place NetBackup
1.2KViews
4likes
6Comments
Oracle "Check Logical" parameter - 4X times faster if not active!
Imoved an oracle database from network to Fiber channel and saw no speed improvement, and after many painful days of tuning, the DBAremoved the "Check Logical" parameter. My 7 hour backup completed in 1.5 hours! 4.6Xfaster. My larger databases actually started to overrun the disk arrays. Nice when backups run too fast and you have to slow them up! Thought Iwould throw this info out there, if you are not getting 50+MB/Sec throughput per child job...
Solved
David_McMullin
15 years ago Place NetBackup
596Views
3likes
2Comments
Oracle Backup Issue | NBU ver 6.5
Hi Guru's Recently had issue with an oracle backup, Sorry if the information given is insufficient but will try my best. As per what the structure is currently (Provided with the backup selection list in bracket): 1st DB Backup Runs (/usr/local/nb/scripts/oracle_rman_hot.uaedb1) 2nd RMAN Logs (Backup selection list is empty) 3rd DB Files ( / ) 4th OS Files ( / ) ========================= When a Oracle backup is triggered, the others gets triggered automaticly until it completes. And all these are in a different policy: e.g 1.DB Backup = (DB_ORA_UAE) 2.RMAN Logs = (UAE_RMAN_LOGS_DW) 3.DB Files = (DB_Files) 4.OS Files = (FS_UAE_UNIX_1) ========================== My concern is, how to make the rman log, db files and os files jobs to run automated upon triggering the DB backup? is it by script? On another note, DBA team informed me that all the backups in order, but i cant seem to see that in netbackup. Thank You Guru's
T3chBallad
12 years ago Place NetBackup
1.1KViews
2likes
5Comments
Netbackup Licensing
Hi every1, This is my first write to any Discussion forum, i will need ur help on many topics. i want to know information about the Netbackup Licensing. Does someone has any idea how can i do licensing when i have a new datacentre environment ? will someone help me out on following queries ? 1) Netbackup agents and their licensing ? 2) Does separate license will be required for adding clients like UNIX (Solaris, Linux), Windows , Databases (Oracle, Sybase etc), ESX (Vmware) 3) like in my environment, i have 4 Oracle databases running on SUN E2900 system and only 1 license is purchased. My query is that, if i want to run another database like SYBASE on sameserver, do i have to buy another license ? orper server license willbe enough ? Another query related to databse is that, 4 database are runningon Primary Site, and 1 system V890 is on DR site as a Standby, Does thatV890 system will reqiure a separate NBUdatabase License ? same case for MS-SQL. 4) If in NBU environment, i have a TAPE Library like SL500 with 4 drives and i want to add more drives ? whats in this scenario ? 5) Does a special License will be required for a single Tape library with NO Drive ? Specially i want to know informationaboutlicensing in tape Library environment.
Shakil_Qureshi
15 years ago Place NetBackup
2.4KViews
2likes
5Comments
bpflist returns "no entity was found" for existing backup id
Background: I have an Oracle 10gR2 database that runs on a Solaris 10 server. Backups go through NetBackup 7.1 which runs on a Windows server. When I run the bpimmedia command for my production Oracle database, I see information like this: bpimmedia -policy ORA_PASPROD -L Backup-ID Policy Type RL Files C E T PC Expires Copy Frag KB Type Density FNum Off Host DWO MPX Expires RL MediaID ------------------------------------------------------------------------------------------------ st31bora01_135409264 ORA_PASPRO UBAK 0 1 N N R 1 01:50 12/05/2012 1 1 1075488 Disk - - - inf-srv17 - N 01:50 12/05/2012 0 @aaaac 2 1 1075488 Disk - - - inf-srv17 - N 01:50 12/05/2012 0 @aaaae 3 1 1075488 RMed hcart 329 23495432 inf-srv17 2 N 01:50 12/05/2012 0 APA159 ... st31bora01_135262369 ORA_PASPRO UBAK 1 1 N N R 3 01:48 12/12/2012 3 1 102432 RMed hcart 78 8086718 inf-srv17 1 N 01:48 12/12/2012 3 APA208 On the first backup ID, I have a copy on the local DataDomain (Media ID @aaaac), a copy of the DataDomain at the disaster recovery site (MediaID @aaaae) and a copy on physical tape (MediaID APA159). For the second backupid shown, I see only one copy on physical tape (MediaID APA208). I need to be able to see the actual file(s) that are within these backups. I have searched on this issue and found replies that reference the "bpflist" command. I can run the command without specifying a backup ID and get about 900 line returned. Unfortunately when I try to specify a backup ID, I consistently get "no entity was found". The following commands were run from D:\Program Files\Veritas\NetBackup\bin\admincmd on my NetBackup 7.1 admin server. -- Show the command works bpflist -client st31bora01 FILES 8 4 0 1354093506 2 st31bora01 ORA_PASPROD st31bora01_1354093506 - *NULL* 1 0 unknown unknown 0 0 pasprod 1 28049408 33 130 0 1 0 0 -1 /PASPROD_c-1968089396-20121128-01 33200 oraprod dbaprod 28049408 1354093500 1354093500 1354093500 1 0 0 15 13 0 0 3 1354093500 1 4 Oracle Database Oracle Backup ... and so on for 900 lines ... -- Try client and backupid bpflist -client st31bora01 -backupid st31bora01_135409264 no entity was found -- Try policy and backupid bpflist -policy ORA_PASPROD -backupid st31bora01_135409264 no entity was found -- Try backupid with some dates bpflist -backupid st31bora01_135409264 -d 01/01/2010 00:00:00 -e 11/28/2012 09:08:00 no entity was found -- Maybe the dates reference the expiry time, put the end 2 years into the future bpflist -backupid st31bora01_135409264 -d 01/01/2010 00:00:00 -e 11/28/2014 09:08:00 no entity was found -- Try adding policy type of Oracle bpflist -backupid st31bora01_135409264 -d 01/01/2010 00:00:00 -e 11/28/2014 09:08:00 -pt Oracle no entity was found -- Policy type of Oracle and client but no dates bpflist -backupid st31bora01_135409264 -client st31bora01 -pt Oracle no entity was found -- put the dates back in bpflist -client st31bora01 -backupid st31bora01_135409264 -d 01/01/2010 00:00:00 -e 11/28/2014 09:08:00 -pt Oracle no entity was found -- Try just the -d date that exactly matches the date from the bpimmedia command bpflist -backupid st31bora01_135409264 -client st31bora01 -d 12/05/2012 invalid command parameter -- "invalid command parameter" , weird So I'm stumped. What does it take to get the bpflist to work? Ken
Solved
khemmerl
12 years ago Place NetBackup
2KViews
1like
5Comments
Find out the exact backup id(s) associated with specific files/folders that have been backed up
Hi all, When I configure a restore in BAR for a client, say, for the MS-Windows policy type, I can select a specific folder or file, click Actions > Preview Media and it would tell me which media id(s) the folder/file is associated with. Since BAR knows which media id(s) my selected file is stored in, it obviously knows which backup id(s) (image id) the file is associated with. Because if it doesn't, then it shouldn't be able to tell me which media id(s) the file is stored in. What I want to find out, is the backup id(s) associated with the file I selected for restore. The Preview Media option in BAR only tells me the associated media id(s) for the file, but I also want to know its associated backup id(s). If I use the "Images on Tape" report, or the catalog "verify" feature against a media id, it would tell me all the backup ids associated with that media id. But picture this problem: A single backup policy backs up one client: somesvr The selection list contains different drives and folders for somesvr. If the media ABC011 contains ten backup ids, and they all begin with somesvr_xxxxxxxxxx (x = ctime code). Then which backup id(s) out of the ten contains the file C:\test.txt on the server "somesvr" ? In BAR, if I select the file C:\test.txt (for a specific day and time), then use Preview Media, it tells me this file is stored in ABC011. But the problem is, I want to know which backup id(s) out of all backup id(s) inside ABC011 this file is really associated with. Thanks for your time! P.S. I know I could use bpflist to find out what folder/files each backup id contains, but I consider this an inefficient solution when I have hundereds of backup ids to go through. RLeon
Solved
RLeon
13 years ago Place NetBackup
3KViews
1like
11Comments
VxBSACreateObject: Failed with error
Hi all, I need your help, my manager Netbackup on a Windows 2008 operating system and Netbackup 7. We have an integration with RMAN but when I run the backup sguente send us the error. The owner forOracle engine is ORACLE and the NetBackup with another user named NetBackup, and integrate the same group of DBA but still sends me the same error. INF - Begin progress logging for process: (14464.15088) INF - Using policy BMB_SMCHFMPROD4_HFM_Ora_Onl_D to perform a user directed Oracle Stream Based backup. INF - Starting Oracle Recovery Manager. INF - Using: "f:\app\hfm\product\11.2.0\dbhome_1\bin\rman.exe" INF - Connection info: target 'netbackup/*****@HFM' rcvcat 'RMANHFM/*****@rmanbm' INF - Start of Recovery Manager input. INF - # ----------------------------------------------------------------- INF - # RMAN command section INF - # ----------------------------------------------------------------- INF - RUN { INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - INCREMENTAL LEVEL=0 INF - FORMAT 'bk_u%u_s%s_p%p_t%t' INF - TAG 'rl_t%t_s%s_p%p' INF - DATABASE; INF - RELEASE CHANNEL ch00; INF - # Backup Archived Logs INF - sql 'alter system archive log current'; INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - FORMAT 'arch_u%u_s%s_p%p_t%t' INF - ARCHIVELOG INF - ALL INF - DELETE INPUT; INF - RELEASE CHANNEL ch00; INF - # Control file backup INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - FORMAT 'ctrl_u%u_s%s_p%p_t%t' INF - CURRENT CONTROLFILE; INF - RELEASE CHANNEL ch00; INF - } INF - End of Recovery Manager input. INF - Start of Recovery Manager output. INF - Recovery Manager: Release 11.2.0.1.0 - Production on Fri Feb 3 23:27:50 2012 INF - connected to target database: HFM (DBID=1249472717) INF - connected to recovery catalog database INF - allocated channel: ch00 INF - channel ch00: SID=696 device type=SBT_TAPE INF - channel ch00: starting incremental level 0 datafile backup set INF - input datafile file number=00012 name=I:\HFM\DATAFILE\CISFM.DMP INF - input datafile file number=00014 name=H:\HFM\DATAFILE\CISODIWORK.DMP INF - input datafile file number=00015 name=I:\HFM\DATAFILE\CISFM01.DMP INF - input datafile file number=00016 name=I:\HFM\DATAFILE\CISFM02.DMP INF - input datafile file number=00017 name=I:\HFM\DATAFILE\CISFM03.DMP INF - input datafile file number=00019 name=G:\HFM\DATAFILE\CISEA01.ORA INF - input datafile file number=00020 name=G:\HFM\DATAFILE\CISEA02.ORA INF - input datafile file number=00021 name=G:\HFM\DATAFILE\CISEA03.ORA INF - input datafile file number=00022 name=G:\HFM\DATAFILE\CISEA04.ORA INF - Begin progress logging for process: (2436.13472) INF - Start backup of backup piece: (bk_u0vn2e6rs_s31_p1_t774314876) INF - Server status = 241 ERR - Server exited with status 241: the specified schedule is the wrong type for this request INF - input datafile file number=00007 name=H:\HFM\DATAFILE\CISEPMA.DMP INF - input datafile file number=00018 name=H:\HFM\DATAFILE\CISODIWORK2.DMP INF - input datafile file number=00003 name=E:\HFM\DATAFILE\O1_MF_UNDOTBS1_78OBHVV8_.DBF INF - input datafile file number=00013 name=H:\HFM\DATAFILE\CISODI.DMP INF - input datafile file number=00001 name=E:\HFM\DATAFILE\O1_MF_SYSTEM_78OBH3V0_.DBF INF - input datafile file number=00002 name=E:\HFM\DATAFILE\O1_MF_SYSAUX_78OBHK1G_.DBF INF - input datafile file number=00005 name=J:\HFM\DATAFILE\CISHSS.DMP INF - input datafile file number=00008 name=J:\HFM\DATAFILE\CISHBI.DMP INF - input datafile file number=00011 name=E:\HFM\DATAFILE\CISFDM.DMP INF - input datafile file number=00004 name=E:\HFM\DATAFILE\O1_MF_USERS_78OBJ9N7_.DBF INF - released channel: ch00 INF - RMAN-00571: =========================================================== INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== INF - RMAN-00571: =========================================================== INF - RMAN-03009: failure of backup command on ch00 channel at 02/03/2012 23:28:12 INF - ORA-19506: failed to create sequential file, name="bk_u0vn2e6rs_s31_p1_t774314876", parms="" INF - ORA-27028: skgfqcre: sbtbackup returned error INF - ORA-19511: Error received from media manager layer, error text: INF - VxBSACreateObject: Failed with error: INF - Server Status: the specified schedule is the wrong type for this request INF - Recovery Manager complete. INF - End of Recovery Manager output. INF - End Oracle Recovery Manager.
Korio
13 years ago Place NetBackup
4.2KViews
1like
3Comments
Backup of really huge database using Netbackup 7
Hi I would like to have your valuable views and suggestions regarding Oracle backups. Oracle version : Oracle 11g R2 configured in 2 node RAC on RHEL 6 Number of DB instances : 2 DB size : Instance 1: 7 TB Instance 2: 12 TB I would like to know what will be the best way to backup these databases using Netbackup like RMAN or RMAN with Snapshot client or any other method like storage based snapshot using Snapshot client option and having it moved to tape. Thanks Giri B
giri_b
13 years ago Place NetBackup
1.6KViews
1like
6Comments
rman problem with Netbackup 6.5.6
Do notknow much aboutOracleDBA. Hehas a policyfor the bankonline (rman)and appearsthis errorORA-00230: INF - RMAN-00571: =========================================================== INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== INF - RMAN-00571: =========================================================== INF - RMAN-03009: failure of Control File and SPFILE Autobackup command on ch00 channel at 05/24/2012 01:22:45 INF - ORA-00230: operation disallowed: snapshot control file enqueue unavailable INF - Recovery Manager complete. Need a solution..
Luiz_LD
13 years ago Place NetBackup
802Views
1like
3Comments
NetBackup 7.1.0.3 Release Schedule
Does anyone have any information on a release date for NetBackup 7.1.0.3? We're dealing with the SQL 2008 bug in 7.1. We can wait for the update if it's scheduled soon. Otherwise we'll review the other options. Thanks!
Solved
pwwagner
13 years ago Place NetBackup
900Views
1like
3Comments