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, HadiSolved36KViews1like8Comments
RMAN restore failing with ORA-27191: sbtinfo2 returned error
Hello, The DBAs are doing an RMAN restore which was taken on server 1 seprdu05. They are trying to restore on server 2 seppuu03. Both clients are Solaris 10 machines with oracle database 11.2.0. The master server is RHEL 5.9. The netbackup master server version is 7.5.0.7 The netbackup client version is 7.5.0.4 The error is as below: Oracle instance shut down RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/16/2015 06:57:26 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-27191: sbtinfo2 returned error Additional information: 3480 On the client, nothing is reported in the netbackup logs: /usr/openv/netbackup/logs/user_ops/dbext/logs/ It seems that the error "Additional information: 3480" would come from the MML (Media Manager Layer). Is there any logs on the master server that could give more details wether the RMAN job has interacted with netbackup so far? Any sugestion would be very helpful.27KViews0likes4Comments
Error Code 50 : (client process aborted(50)
Team, For soem of the client backups are failing with the error code 50. Please find the detials below : NB Master server: OS : Windows 2008 R2 NB Version : 7.5 Client : OS : Windows XP & Windows 2000. Backups are going directly to the Physical tape library. Help in resolving this issue. let me know if need any more informationSolved23KViews2likes8Comments
change the logon account service using command line netbackup
Hello all, innetbackup i want to change the logon account service using command line allthough i alreadyknow how to change the services manually but it is not helpful for my testing purpose. Manual procedure is mention below" To configure the log on account for the NetBackup Client Services Any one help me.......any kind of help is appreciated... Thanks Open the Windows Services application. Double-click on the NetBackup Client Service entry. Click on the Log On tab. If Local System account is not selected as the Log on as account, proceed with step 9. Provide the name of the user account that you created for the NetBackup Client Service. The account must include the domain name, followed by the user account, domain_name\account . For example, recovery\netbackup . Type the password. Click OK. Stop and start the NetBackup Client Service. Close the Services control panel application I want to done above mention procedure but using command.Solved23KViews0likes4Comments
ERROR: Error 1335.The cabinet file 'Data1.cab' required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package.
Hi all, through installation of netbackup softwareI got this message : ERROR: Error 1335.The cabinet file 'Data1.cab' required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package. I believe it is windows issue.kindly provide me steps needs to follow forsolvin this issue. I tried to disable and enable windows moduler but no result. Regards,Solved22KViews1like12Comments
Restore RMAN-06025: no backup of archived log
Hello Everyone I Need to restore an archive log when I try to find it out using RMAN i got someting like this BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 7386620 4.39G SBT_TAPE 00:04:17 31-JUL-14 BP Key: 7386631 Status: AVAILABLE Compressed: NO Tag: TAG20140731T170013 Handle: hepepnp0_1_1 Media: CS0650 List of Archived Logs in backup set 7386620 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 6636 199103405748 31-JUL-14 199109231888 31-JUL-14 When I run the restore using rman i got this RMAN-06025: no backup of archived log for thread 2 with sequence 4437 and starting SCN of 199093424179 found to restore Does anybody has faced whit this problem. Best RegardsSolved21KViews1like2CommentsORA-19506 ORA-27028 ORA-19511
NBU: 7.5 OS: AIX 6.1 DB: oracle 10.2.0.5 RAC This error message appears when I am trying level 0 backup. I do not know how to fix it,please help me,thanks released channel: ch01 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch00 channel at 10/16/2014 23:17:40 ORA-19506: failed to create sequential file, name="al_60179_1_861144290", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: VxBSACreateObject: Failed with error: Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serveSolved21KViews2likes16CommentsExit Status: 48 (client hostname could not be found)
Hi all, I have an environment consist of cluster master server windows 2008and 5 media servers and 2 5020 appliances.I installed agent on the linux redhat client and and i added all server list to bp.conf and etc/hosts in the client and i added the client name in the master server host file.when i'm trying to ping from the client every thing working fine,but i couldnot do this from the master to client.then when i configured the policy the jobs failed with status Exit Status: 48 (client hostname could not be found) then I ran command bptestbpcd -client from master with -debug i got this result: C:\Program Files\Veritas\NetBackup\bin\admincmd>bptestbpcd -client BEC13-ENC2-2 -debug 16:09:32.930 [3444.5668] <2> bptestbpcd: VERBOSE = 0 16:09:32.946 [3444.5668] <2> copy_preferred_network_list: ../../libvlibs/nbconf. c.1610: pseudo PN for : bec12-encx-v37 16:09:32.946 [3444.5668] <2> copy_preferred_network_list: ../../libvlibs/nbconf. c.1610: pseudo PN for : bec12-encx-v37 16:09:32.961 [3444.5668] <2> copy_preferred_network_list: ../../libvlibs/nbconf. c.1610: pseudo PN for : bec12-encx-v37 16:10:02.963 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:10:14.964 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:10:14.964 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:10:45.965 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:10:57.966 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:10:57.966 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:11:08.982 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:11:38.984 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:11:53.984 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:11:57.985 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:12:05.001 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:12:35.002 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:12:43.002 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:12:46.003 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:13:07.004 [3444.5668] <8> async_connect: [vnet_connect.c:1653] getsockopt SO_ ERROR returned 10060 0x274c 16:13:07.004 [3444.5668] <16> connect_to_service: connect failed STATUS (18) CON NECT_FAILED status: FAILED, (42) CONNECT_REFUSED; system: (10060) Connection timed o ut.; FROM 172.20.124.11 TO BEC13-ENC2-2 172.20.165.4 bpcd VIA pbx status: FAILED, (42) CONNECT_REFUSED; system: (10060) Connection timed o ut.; FROM 172.20.124.11 TO BEC13-ENC2-2 172.20.165.4 bpcd VIA vnetd status: FAILED, (42) CONNECT_REFUSED; system: (10060) Connection timed o ut.; FROM 172.20.124.11 TO BEC13-ENC2-2 172.20.165.4 bpcd 16:13:07.004 [3444.5668] <8> vnet_connect_to_bpcd: [vnet_connect.c:279] connect_ to_service() failed 18 0x12 16:13:07.004 [3444.5668] <2> local_bpcr_connect: Can't connect to client BEC13-E NC2-2 16:13:07.004 [3444.5668] <2> ConnectToBPCD: bpcd_connect_and_verify(BEC13-ENC2-2 , BEC13-ENC2-2) failed: 25 <16>bptestbpcd main: Function ConnectToBPCD(BEC13-ENC2-2) failed: 25 16:13:07.004 [3444.5668] <16> bptestbpcd main: Function ConnectToBPCD(BEC13-ENC2 -2) failed: 25 <2>bptestbpcd: cannot connect on socket 16:13:07.004 [3444.5668] <2> bptestbpcd: cannot connect on socket <2>bptestbpcd: EXIT status = 25 16:13:07.004 [3444.5668] <2> bptestbpcd: EXIT status = 25 cannot connect on socket C:\Program Files\Veritas\NetBackup\bin\admincmd> please advice what is missed??? Regards,Solved20KViews1like16CommentsDifference between Differential Inc backup and Cumulative Inc backup.
All my backups are archive bit dependant. Please let me know what is the difference we are backing up in Differential Inc backup and Cumulative Inc backup, if below definitions are correct. Please find the attachement. Thanks and regards, Bharath AcharSolved19KViews1like5Comments
RMAN restore failing with ORA-27191: sbtinfo2 returned error
Hello, The DBAs are doing an RMAN restore which was taken on server 1 seprdu05. They are trying to restore on server 2 seppuu03. Both clients are Solaris 10 machines with oracle database 11.2.0. The master server is RHEL 5.9. The netbackup master server version is 7.5.0.7 The netbackup client version is 7.5.0.4 The error is as below: Oracle instance shut down RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/16/2015 06:57:26 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-27191: sbtinfo2 returned error Additional information: 3480 On the client, nothing is reported in the netbackup logs: /usr/openv/netbackup/logs/user_ops/dbext/logs/ It seems that the error "Additional information: 3480" would come from the MML (Media Manager Layer). Is there any logs on the master server that could give more details wether the RMAN job has interacted with netbackup so far? Any sugestion would be very helpful.