Database

259 Topics

Duplication fails with database system error (220)
Hi there. I'm running Netbackup 7.1 on a RHEL 5 and I'm having the error "database system error (220)" when the duplication process runs. Here's the full log: 16/Jun/2011 15:19:43 - begin Duplicate 16/Jun/2011 15:19:43 - requesting resource backupserver-hcart3-robot-tld-0 16/Jun/2011 15:19:43 - requesting resource backupserver-hcart3-robot-tld-0 16/Jun/2011 15:19:43 - granted resource FC0281 16/Jun/2011 15:19:43 - granted resource HP.ULTRIUM3-SCSI.001 16/Jun/2011 15:19:43 - granted resource backupserver-hcart3-robot-tld-0 16/Jun/2011 15:19:43 - granted resource FC0330 16/Jun/2011 15:19:43 - granted resource HP.ULTRIUM3-SCSI.000 16/Jun/2011 15:19:43 - granted resource backupserver-hcart3-robot-tld-0 16/Jun/2011 15:20:54 - Info bpdbm (pid=20149) cataloguing file number 10000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=40B/CN=msExchOmaConnector-Display/classDisplayName 16/Jun/2011 15:21:29 - Info bpdbm (pid=20149) cataloguing file number 20000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=413/CN=serviceAdministrationPoint-Display/ 16/Jun/2011 15:22:21 - Info bpdbm (pid=20149) cataloguing file number 30000 path /System State/Active Directory/CN=Configuration/CN=DisplaySpecifiers/CN=816/CN=msExchIMGlobalSettingsContainer-Display/ 16/Jun/2011 15:23:00 - Info bpdbm (pid=20149) cataloguing file number 40000 path /System State/Active Directory/CN=Configuration/CN=Services/CN=Microsoft Exchange/CN=Universidade de Lisboa/CN=Addressing/CN=Display-Templates/CN=40F/displayName 16/Jun/2011 15:24:10 - Info bpdbm (pid=20149) cataloguing file number 50000 path /System State/Active Directory/CN=Configuration/CN=Services/CN=Microsoft Exchange/CN=Universidade de Lisboa/CN=ELC Folders Container/CN=Deleted Items/msExchELCFolderType 16/Jun/2011 15:25:15 - Info bpdbm (pid=20149) cataloguing file number 60000 path /System State/Active Directory/CN=Configuration/CN=Sites/CN=Subnets/CN=194.117.13.0\24/description 16/Jun/2011 15:25:40 - Info bpdbm (pid=20149) cataloguing file number 70000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=LIC/CN=Ana Maria Domingues Vieites/extensionAttribute1 16/Jun/2011 15:26:06 - Info bpdbm (pid=20149) cataloguing file number 80000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Ana Sofia Briosa e Scheltinga/givenName 16/Jun/2011 15:26:10 - Info bpdbm (pid=20149) cataloguing file number 90000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Diana Mileu Miranda Antunes/mailNickname 16/Jun/2011 15:26:16 - Info bpdbm (pid=20149) cataloguing file number 100000 path /System State/Active Directory/DC=alunos/OU=DBA/OU=Licenciatura/CN=Joana Santos Pinheiro AnastÃ¡cio/cn 16/Jun/2011 15:28:05 - Info bpdbm (pid=20149) cataloguing file number 200000 path /System State/Active Directory/DC=alunos/OU=DEGGE/OU=Licenciatura/CN=Jorge Miguel Nogueira Ponte/showInAddressBook 16/Jun/2011 15:29:35 - Info bpdbm (pid=20149) cataloguing file number 300000 path /System State/Active Directory/DC=alunos/OU=DG/OU=Licenciatura/CN=Joana Sofia Ferreira SimÃµes/msExchMailboxGuid 16/Jun/2011 15:31:59 - Info bpdbm (pid=20149) cataloguing file number 400000 path /System State/Active Directory/DC=alunos/OU=DI/OU=Licenciatura/CN=Tiago Alexandre da Costa Rodrigues/homeDrive 16/Jun/2011 15:33:49 - Info bpdbm (pid=20149) cataloguing file number 500000 path /System State/Active Directory/DC=alunos/OU=Externos/OU=Erasmus/CN=Giulia Bacchini/proxyAddresses 16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) db_IMAGE() failed: database system error (220) 16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Status = no images were successfully processed. 16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Duplicate of backupid alunos-dc01.hostname_1308108619 failed, database system error (220). 16/Jun/2011 15:41:54 - Error bpduplicate (pid=20142) Status = no images were successfully processed. 16/Jun/2011 15:41:54 - end Duplicate; elapsed time 0:22:11 no images were successfully processed (191) Can anyone give me a help here? Thanks. Regards, Ricardo Vilhena
Solved
vilhena
14 years ago Place NetBackup
9.4KViews
0likes
15Comments
Backup failing with error Network connection timed out(41)
Hi All need your help. when i am going to take backup of client.full backup for given mount points completed successfully. but when i am going to take incremental backup of same client for same mount point.backup going to stuck for interval after sometime its showing network connection timed out(41). in detailed status for that job as 08/07/2009 01:01:20 started process bpbrm (pid=12331) 08/07/2009 01:01:20 connecting 08/07/2009 02:01:20 end writing 08/07/2009 02:01:20 error bpsched (pid=8525) backup of client elroy exited with status 41(network connection timed out) I check network connectivity its fine. and full backup completed successfully. Please help Thanks & Regards Anjan Das
Solved
Anjan_Das
16 years ago Place NetBackup
7.5KViews
1like
7Comments
Checking Oracle RMAN backups for Restore with NetBackup
We are trying to run a test restore using VERITAS on an Oracle RMAN backup. We have an Oracle 10g database which is backed up using RMAN and VERITAS NetBackup via a backup agent on a different server to the client. On the client server, the Oracle database files are stored on a SAN (G:\) drive. This has VERITAS NetBackup Client 5.1 installed. On clicking <Select for Backup>, all drives (local and SAN), plus Oracle and the database and AS instances with their datafiles etc, are listed. However on clicking <Select for Restore>, only the local (C and D) drives are listed, Oracle and the SAN drives are not listed. Does this suggest a problem with the backup at all? I have consulted the Veritas NetBackup (tm) 6.5 for Oracle Administrator's Guide for Windows, which states that listing the Oracle backups in the Restore window is a required step. If I click on Actions -> Administer Database Templates -> Oracle, it shows a template called Oracle RAC.tpl. This file has been configured for the database being backed up. The master server uses VERITAS NetBackup Administration Console 5.1 to backup the client server over the network. The Activity Monitor option lists Oracle files backed up on the client server, but the details listed do not resemble what is listed by the RMAN command on the client. The master server also backs up some SQL-Server databases; but on the client servers, when running Veritas NetBackup MS-SQL Client, View -> Monitor Jobs provides a detailed listing of the backups on that server. Both servers run on a Microsoft Windows Server 2003 SP1 platform. Any advice gratefully appreciated please.
andrew584
16 years ago Place NetBackup
6.7KViews
0likes
4Comments
Error bpbrm: listen for client timeout during accept from data listen socket after 60 seconds
I keep receiving the error message in the title even though I have gone through and set my timeout settings to at least 900 seconds. I have also run all the bpclntcmd commands and all of them return appropriately. Is the 60 second timeout referred to in the error message a client side OS setting? I am running Red-Hat 5. Thanks
bsb
14 years ago Place NetBackup
6.3KViews
0likes
7Comments
NetBackup Windows admin console very slow
Hi all, We have NetBackup 6.5.4 Enterprise on a SPARC/Solaris 10 server here. Personally I use the Java client (jnbSA) to admin the server from my Linux workstation but some of our guys use the native Windows admin gui (i.e. not Java gui) from their PCs to do the same. This all worked fine until last monday. I had to rearrange the network interfaces on the server in advance of creating some trunked ports for extra bandwidth to the server so I moved the main NIC for the machine (i.e. the one that the backup and admin clients talk to it on) to a different physical port - in Solaris terms I renamed the "/etc/hostname.ce0" file to "/etc/hostname.ce2" and rebooted the machine. Prior to that the ce2 interface had been used for something else but that was moved to ce0 so in effect, I've swapped the two interfaces around (and obviously the cables too). Now, the windows admin gui runs very slow at certain things, in particular accessing the media on the server - the windows guys use this for doing daily tape ejects and imports, the windows gui sits there for ages saying "Opening EMM database". It does eventually get there after a couple of minutes or so. The Java gui that Iuse still works fine, however. Any ideas? Thanks in advance, Niall
Solved
Niall_Porter
15 years ago Place NetBackup
5.6KViews
1like
14Comments
Out of FS space for /usr/openv (NBU Production Server)
Ireceived an error from my Device Monitor - database system error. DSM is unable to connect to the DB, issue: connect - I have ran out of disk space and need to have our storage group "grow" more space for my FS. Netbackup 6.5.3 daemonsare currently at a "stop" state (inc. Media Servers). Iwas told that there is a temp fix from my UNIXAdmin. Iam currently "mirroring" /usr/openv. Is it possible (i'm sure, not recommended) to remove this mirror for a quick fix and continue my backups? Will Ineed to "re-zone" all my drives? Re-configure the Robot? Any insight would help. Thank you
Solved
Jay_Son
16 years ago Place NetBackup
4.8KViews
1like
7Comments
Removing and old media server after it was not decommissioned properly
Hello NetBackup Guru's We had a Unix media server in our environment that was turned off and removed before being decommissioned properly. Now, our NetBackup Administration Console is very slow because NetBackup is always looking for this server (named DPXSCH2). I know this is the reason, because in the NBCONSOLE logs, the following entry keeps coming up over and over when trying to open the NetBackup console... hosts_equal: gethostbyname failed for dpxsch2: The requested name is valid, but no data of the r (0) There are missing drives for this old media server in the admin console (listed there but listed as missing), and they cannot be deleted. The media server is still listed in devices as well, and when you try to delete it, the following error occurs... Unable to remove device host dpxsch2 from the Enterprise Media Manager server <master>: The EMM server failed to process the request(78) You can also still see the media server when you run nbemmcmd -listhosts command. I have tried to delete the media server with the command... nbemmcmd -deletehost -machinename dpxsch2 -machinetype media ... but I get the error... NBEMMCMD, Version:6.5.3 The function returned the following failure status: generic EMM SQL error (193) Command did not complete successfully. Our environment is NetBackup 6.5.3 Windows 2003 master server 4 x Windows 2003 media servers 1 x AIX master server My question: Does anyone know how to remove a media server out of the configuration after the server is gone? -Richard Harvey
Solved
Flappyhead
16 years ago Place NetBackup
4.5KViews
0likes
5Comments
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
NetBackup MSSQL not truncating log
Hello, I'm running NB log policy over several mssql servers, I'm having some problem because after log backup, the log is not truncated and I'm getting some space problems. NB 6.5.3 MSSQL client OK 6.5.3 files OK online OK diff OK full OK Log OK (but not truncate the log) Does anyone had these problem? Thanks.
Solved
Claudio_Veronez
16 years ago Place NetBackup
4.2KViews
0likes
19Comments
MS SQL database backup
Dear All, I have a problem with backup of a SQL database. I have created various scripts and they seem to be initiating the connection with the master server. But i can't figure-out the problem now. Check the error below. OPERATION BACKUP DATABASE "UAT" SQLHOST "dsrv10" NBSERVER "DDBBACKUP" MAXTRANSFERSIZE 6 BLOCKSIZE 7 NUMBUFS 2 ENDOPER TRUE ERR - Error in CDBbackrec::CDBbackrec: 6. CONTINUATION: - The system cannot find the file specified. ERR - Error in VxBSASetEnv(BSA_SERVICE_HOST): 6. CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid. INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\sqltest.bch>: <0> operations succeeded. <1> operations failed. INF - The following object(s) were not backed up successfully. INF - UAT
johnson_Mpaulo
16 years ago Place NetBackup
4.1KViews
0likes
2Comments