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, GiriSolved13KViews2likes6CommentsERROR: 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.Solved12KViews1like3Comments"EXIT STATUS 25: cannot connect on socket" while initiating a restore.
I am facing this issue as I am initiating this restore and receiving the following error: "EXIT STATUS 25: cannot connect on socket" I looked upon the bplogs for the restore script but couldn't find anything. Please suggest, it's urgent. Thanks in Advance!!! Regards, Harmanpreet SinghSolved9.3KViews1like31CommentsVM Restore from netbackup
Hi team, do we have any step by step document of Virtual machine(Netbackup client) restore . -restore to original VM - restore to another datastore Client OS type is windows and linux Or any suggested method of VM restore The backup is using VMware policy method. Nbu version 7.6.0.3 Master server is windows 2012Solved8.8KViews2likes12CommentsDifference between Retention preiod and Rentention level
Hi In netbackup linux file level back up policy i noticed in scheudled tab retion period is 1 year and retention level is 5. i understand Retention preiod is to hold backup upto 1 year and i would like to know here what is retention level and why we need this. Thanks in advanceSolved8.8KViews1like4Comments