Oracle RMAN restore is failing with error "ORA-19507: failed to retrieve sequential file, ...."
Hi All, We are running netbackup for oracle agent. The oracle clients has four instance and each instance has its own backup policy. The backup is successful for all instances. But when it comes to restore, only one instance restore succeeds and 3 fails. below is the rman output: RMAN> run { 2> allocate channel ch1 type 'sbt_tape'; 3> SEND'NB_ORA_SERV=backup-server,NB_ORA_CLIENT=banner,NB_ORA_POLICY=banner-oracle-seed-policy,NB_ORA_SCHED=Default-Application-Backup'; 4> restore controlfile to '/tmp/my_controlfile_seed.ctl'; 5> release channel ch1; 6> } using target database control file instead of recovery catalog allocated channel: ch1 channel ch1: sid=155 devtype=SBT_TAPE channel ch1: Veritas NetBackup for Oracle - Release 7.5 (2012060520) sent command to channel: ch1 Starting restore at 22-MAR-13 channel ch1: starting datafile backupset restore channel ch1: restoring control file output filename=/tmp/my_controlfile_seed.ctl channel ch1: reading from backup piece cntrl_18_1_810725846 ORA-19870: error reading backup piece cntrl_18_1_810725846 ORA-19507: failed to retrieve sequential file, handle="cntrl_18_1_810725846", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <cntrl_18_1_810725846> not found in NetBackup catalog failover to previous backup channel ch1: starting datafile backupset restore channel ch1: restoring control file output filename=/tmp/my_controlfile_seed.ctl channel ch1: reading from backup piece bk_14_1_810725788 ORA-19870: error reading backup piece bk_14_1_810725788 ORA-19507: failed to retrieve sequential file, handle="bk_14_1_810725788", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <bk_14_1_810725788> not found in NetBackup catalog failover to previous backup . . . . released channel: ch1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/22/2013 11:35:44 RMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore I appreciate if somebody can assist in finding a solution for this problem. Many Thanks, HadiSolved36KViews1like8CommentsNetbackup restore failed - Restore error(2850)
Good day Guys, I am fairly new to Netbackup. Recently joined a company that uses it for it's backups. So far, all the problems I have experienced, I was able to find solutions for in these forums, but today I have one I am unable to solve. Background info: Server OS: MS Server 2008 R2 Ent 64bit Netbackup 7.6.0.4 Dell PowerVault TL2000 LTO5 Media tapes Senario: I did a full backup on a file server, which was also the media server to 2 tapes. I uninstalled netbackup from that server, as it is being decom-ed and didn't backup any settings for netbackup or even the catalog, which apperantly was done to the server's HDD, instead to tape. This server was then renamed to a new name and I did a BMR restore to a VM of the "old" server. Now I need to restore that complete backup to a 3rd server, which has enough disk space, over the network. The restore was started from the VM server and job is being monitored on the renamed server, where netbackup was re-installed. This is not the first problem I have run into with the restore, but I think most settings are correct now on Netbackup. Original server: ZAALIOSRV033 (Was media server, now VM with netbackup client) Renamed server: ZAALIOSRV001 (New media server, with NB Admin Console) Network server: ZAAAPJSRV001 (Server with the disk space) Error I am getting: 7/6/2015 7:40:03 AM - begin Restore 7/6/2015 7:41:05 AM - 1 images required 7/6/2015 7:41:05 AM - media 0048L5 required 7/6/2015 7:41:05 AM - media 0077L5 required 7/6/2015 7:41:06 AM - restoring image zaaliosrv033.zaa.xstrata.int_1434000278 7/6/2015 7:41:07 AM - Info bpbrm(pid=6036) zaaliosrv033.zaa.xstrata.int is the host to restore to 7/6/2015 7:41:07 AM - Info bpbrm(pid=6036) telling media manager to start restore on client 7/6/2015 7:41:10 AM - Info bpbrm(pid=4992) zaaliosrv033.zaa.xstrata.int is the host to restore to 7/6/2015 7:41:10 AM - connecting 7/6/2015 7:41:10 AM - requesting resource 0077L5 7/6/2015 7:41:10 AM - granted resource 0077L5 7/6/2015 7:41:10 AM - granted resource Drive2 7/6/2015 7:41:11 AM - Info bptm(pid=1912) Waiting for mount of media id 0077L5 (copy 1) on server zaaliosrv001.zaa.xstrata.int. 7/6/2015 7:41:11 AM - started process bptm (1912) 7/6/2015 7:41:11 AM - mounting 0077L5 7/6/2015 7:41:12 AM - Info bpbrm(pid=4992) start tar32 on client 7/6/2015 7:41:12 AM - Info bptm(pid=1912) INF - Waiting for mount of media id 0077L5 on server zaaliosrv001.zaa.xstrata.int for reading. 7/6/2015 7:41:16 AM - Info tar32(pid=3620) Restore started. 7/6/2015 7:41:16 AM - connected; connect time: 0:00:06 7/6/2015 7:41:53 AM - mounted; mount time: 0:00:42 7/6/2015 7:41:53 AM - Info bptm(pid=1912) 0077L5 7/6/2015 7:41:55 AM - Info bptm(pid=1912) INF - Waiting for positioning of media id 0077L5 on server zaaliosrv001.zaa.xstrata.int for reading. 7/6/2015 7:41:55 AM - positioning 0077L5 to file 789 7/6/2015 7:42:26 AM - positioned 0077L5; position time: 0:00:31 7/6/2015 7:42:41 AM - begin reading 7/6/2015 7:43:15 AM - positioning 0077L5 to file 790 7/6/2015 7:43:15 AM - positioned 0077L5; position time: 0:00:00 7/6/2015 7:43:36 AM - Info tar32(pid=3620) done. status: 0 7/6/2015 7:43:36 AM - Info tar32(pid=3620) done. status: 5 - the restore failed to recover the requested files 7/6/2015 7:43:36 AM - Info bpbrm(pid=6036) child done, status 5 7/6/2015 7:43:36 AM - Info bpbrm(pid=6036) sending message to media manager: STOP RESTORE zaaliosrv033.zaa.xstrata.int_1434000278 7/6/2015 7:43:36 AM - end reading; read time: 0:00:55 7/6/2015 7:43:37 AM - Info bpbrm(pid=6036) media manager for backup id zaaliosrv033.zaa.xstrata.int_1434000278 exited with status 0: the requested operation was successfully completed 7/6/2015 7:43:37 AM - restored image zaaliosrv033.zaa.xstrata.int_1434000278 - (the restore failed to recover the requested files(5)); restore time 0:02:31 7/6/2015 7:43:42 AM - end Restore; elapsed time: 0:03:39 Restore error(2850) I have checked, and there is no FORCE_RESTORE_MEDIA_SERVER entry in the registry. Please help. :)Solved15KViews0likes6CommentsOracle restore: ORA-19573: cannot obtain exclusive enqueue for datafile
**** Moved to new discussion from:https://www-secure.symantec.com/connect/forums/reg-oracle-db-backup**** i am getting the below error when try to restore ...kindly help me com09:oracle # /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh com09:oracle # cat database_restore.sh.out Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== started on Sun Aug 17 16:39:17 UTC 2014 ==== RMAN: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0/bin/rman ORACLE_SID: plxdb ORACLE_USER: oracle ORACLE_HOME: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0 Last login: Sun Aug 17 16:38:47 UTC 2014 Recovery Manager: Release 11.2.0.1.0 - Production on Sun Aug 17 16:39:17 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: PLXDB (DBID=3747984712) using target database control file instead of recovery catalog RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> allocated channel: ch00 channel ch00: SID=28 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020) allocated channel: ch01 channel ch01: SID=129 device type=SBT_TAPE channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013061020) Starting restore at 17-AUG-14 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00005 to /opt/PlexView/Oracle/ora02/oradata/plxdb/audit_data.dbf channel ch00: restoring datafile 00006 to /opt/PlexView/Oracle/ora02/oradata/plxdb/cfma01.dbf channel ch00: restoring datafile 00008 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_indx.dbf channel ch00: restoring datafile 00009 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_data.dbf channel ch00: restoring datafile 00010 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_indx.dbf channel ch00: reading from backup piece bk_84_1_855851605 channel ch01: starting datafile backup set restore channel ch01: specifying datafile(s) to restore from backup set channel ch01: restoring datafile 00001 to /opt/PlexView/Oracle/ora02/oradata/plxdb/system01.dbf channel ch01: restoring datafile 00002 to /opt/PlexView/Oracle/ora02/oradata/plxdb/sysaux01.dbf channel ch01: restoring datafile 00003 to /opt/PlexView/Oracle/ora02/oradata/plxdb/undotbs01.dbf channel ch01: restoring datafile 00004 to /opt/PlexView/Oracle/ora02/oradata/plxdb/users01.dbf channel ch01: restoring datafile 00007 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_data.dbf channel ch01: reading from backup piece bk_85_1_855851606 released channel: ch00 released channel: ch01 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/17/2014 16:39:27 ORA-19870: error while restoring backup piece bk_84_1_855851605 ORA-19573: cannot obtain exclusive enqueue for datafile 6 RMAN> RMAN> Recovery Manager complete. Last login: Sun Aug 17 16:38:47 UTC 2014 Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== ended in error on Sun Aug 17 16:39:27 UTC 2014 ==== com09:oracle # regards, GiriSolved13KViews2likes6CommentsSSR 2011 Symantec System Recovery Disk ISO download
I have SSR 2011 installed and would like to create a System Recovery disk, but i don't have the ISO. I know there's a download for that and I've seen a location for a 2013 version, but I assume I need a 2011 version. Where can I download one? Thanks, Rob13KViews1like15CommentsERROR: client is not validated to perform the requested operation
hello, i get this error when trying to restore from a hyper-v VM which has the netbackup client installed. in the hyper-v policy i have 3 clients (selected by hostname) and only one of them exhibits this error. output of bpclntcmd on the culprit machine: C:\Program Files\VERITAS\NetBackup\bin>bpclntcmd -self gethostname() returned: HOSTNAME host HOSTNAME: hostname.dom.corp.net at xx.xxx.xx.xxx aliases: hostname.dom.corp.net HOSTNAME xx.xxx.xx.xxx getfqdn(HOSTNAME) returned: hostname.dom.corp.net C:\Program Files\VERITAS\NetBackup\bin>bpclntcmd -pn expecting response from server masterserver.hki.com hostname.gt.es *NULL* xx.xxx.xx.xxx 3005 any thoughts? thanksSolved12KViews1like7CommentsVirtual Machines going out of network during snapshot backup
Has anyone experienced the Virtual machines going out of network during the backup using "VMware" policy. Apparently , the Windows VMs losing connectivity for a little while and coming back online and the Linux VMs becoming unresponsive.Solved12KViews1like7CommentsSteps to configure a client
i want to configure a client at netbackup level. Please correct if i am wrong. for Unix client 1)install the OS 2)we can ask network team to provide an IP and regestering the client in DNS server. Once regerstation done will get the FQDN to our system. 3)we will install netbackup client server software in the machine, it will ask licence key, master, media server names while installing and once installation done 4)we need to add client entries in master server bp.conf , etc/host file. 5)now will chek for the connectivity using ping, telnet and nslookup commands, Once the connectivity is fine will configure the server as netbackup client. For windows client. 1)install the OS 2)we can ask network team to provide an IP and regestering the client in DNS server. Once regerstation done will get the FQDN to our system. 3)we will install netbackup client server software in the machine, it will ask licence key, master, media server names while installing and once installation done 4)Need to add master, media server entries in registryHKEY_LOCAL_MACHINE\Software\VERITAS\NetBackup\CurrentVersion\Config\Server 5)now will chek for the connectivity using ping, telnet and nslookup commands, Once the connectivity is fine will configure the server asnetbackup client. EXPERTS... Please let me know if i am wrong/missed anything at any where or if am correct please give me some more detailed text.Solved12KViews1like3CommentsA guide to booting HP Elitepad to recovery environment using USB flash drive
Hi, Back in October 2013, a support case that I opened with Symantec in relation to failure of the Elitepad 900 G1 to boot into the Symantec recovery environment from a USB or DVD drive etc, was ultimately closed with no resolution due to a compatibility issue or similar. I recently decided to pick this up again and am pleased to report a successful outcome but not without issues. Here's what I did: > Note: I have SP2 installed on my SSR client (Ver. 11.0.2.49853)but this is immaterial to process described below. > Grabbed a copy of the latest 32bit recovery ISO (SSR11.0.2.49853_AllWin_English_SrdOnly.iso)from here:https://www4.symantec.com/Vrt/offer?a_id=88724 > Obtained and formatted thumb drive as FAT32 (I did not have to bother with the diskpart procedure that is referenced as required from several sources) > Used WinZip to extract the contents of the ISO to the USB flash drive. Note: DO NOT use the Customer Recovery Disk wizard in the SSR 2013 client. > That's it, plugged it in to one of 2 x USB sockets available on the Elitepad productivity jacket. (Note: if you don't have a jacket you might be in trouble having access to only 1 x USB port. > A USB keyboard needs to be connected to the 2nd USB port as there is no touch panel functionality in the recovery environment. Note that If you wish to use a USB Ext Drive to store the recovery points, the USB Boot Flash drive can be safely removed once the environment is entered, allowing you to connect your USB Ext Drive. > In Elitepad Advanced Startup options, selected USB EFI Boot Device option. > Elitepad booted into recovery environment with navigation by keyboard thereafter (Some useful keyboard shortcuts are:- TAB to cycle the focus between objects; enter to select; [space] to check/uncheck a checkbox; right arrow key to expand a file folder to show subfolder) > Ripped a Windows 8.1 image from one Elitepad and then restored using this image to a factory state Windows 8.0 device with no issues whatsoever, just had to re-activate Windows after the restore. So anyway, the critical step in the process described above is to use WinZip or a similar archiving utility to get the ISO contents onto the flash drive because for some bizarre reason, if you use the Symantec Custom Recovery Disk wizard to burn the ISO, this causes all of the files on the flash drive to become hidden (even with "Show Hidden Files / Folders" checked in file explorer?) with the exception of autorun.inf. The problem appears to be that the Elitepad 900 GI apparently can't see these files because it does not recognise a flash drive prepared in this manner, as a valid EFI USB boot device. It seems unlikely that the Elitepad 900 is the only tablet that might be affected by this issue. Hopefully this guide might save somebody some time at some stage. Orson.12KViews1like8CommentsRestore data from different backup exec server
hi all, i need to restore on new 2008 r2 server with bE 2010 R3,from a tape done withbackup exec 2010 r3. what is the correct procedure? in the backup job of the old server should i had to backup something elese, as catalog, or just the data? in the backup job i selected only data (files and folder) and nothing else. Thank you RegardsSolved11KViews0likes6Comments