RMAN restore not working

RMAN restore not working

  • Article ID:100025207
  • Last Published:
  • Product(s):NetBackup

Problem

A test restore of an Oracle database to it's original location fails with the following error:

 

Error Message

 ORA-19507: failed to retrieve sequential file, handle="bk_u03mg4o7q_s3_p1_t755130618", parms=""
 ORA-27029: skgfrtrv: sbtrestore returned error
 ORA-19511: Error received from media manager layer, error text:
    Failed to open backup file for restore.

 

Cause

Backup traffic was being routed through a backup interface.


The dbclient log from the Oracle client shows:

15:16:39.007 [1856.856] <4> dbc_GetServerClientConfig: ServerName: <master-bkup>, ClientName: <client-bkup>
15:16:39.007 [1856.856] <8> dbc_GetServerClientConfig: WARNING - NBU's client name= <client-bkup> differs from gethostname()= <client.xyz.com>
15:16:39.007 [1856.856] <4> RestoreFileObjects: INF - restoring File:</bk_u0bmgn6re_s11_p1_t755735406>
15:16:39.007 [1856.856] <2> vnet_async_connect: ..\libvlibs\vnet_vnetd.c.4033: connect in progress: 0 0x00000000
15:16:39.023 [1856.856] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2046: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006

15:16:39.023 [1856.856] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2060: service: bprd
15:16:39.241 [1856.856] <2> logconnections: BPRD CONNECT FROM 192.168.1.2.2531 TO 192.168.1.5.13724

15:16:49.523 [1856.856] <16> serverResponse: ERR - server exited with status 37: operation requested by an invalid server
15:16:49.523 [1856.856] <16> RestoreFileObjects: ERR - serverResponse() failed
15:16:49.523 [1856.856] <4> closeApi: INF - EXIT STATUS 5: the restore failed to recover the requested files
15:16:49.523 [1856.856] <16> VxBSAGetObject: ERR - System error occurred trying to retrieve object in RestoreFileObject.  Status: 3
15:16:49.523 [1856.856] <16> xbsa_GetObject: ERR - VxBSAGetObject: Failed with error:
  Server Status:  operation requested by an invalid server
15:16:49.523 [1856.856] <16> int_StartJob: ERR - Failed to open backup file for restore

 

 

The bprd log from the Master server shows:

15:16:39.114 [9272.9856] <2> logconnections: BPRD ACCEPT FROM 192.168.1.2.2531 TO 192.168.1.5.13724 fd = 672
15:16:39.114 [9272.9856] <2> process_request: setsockopt SO_LINGER on 672 succeeded.
15:16:39.114 [9272.9856] <2> connected_peer: Connection from host client.xyz.com, 192.168.1.2, on non-reserved port 2531
15:16:39.114 [9272.9856] <2> db_valid_master_server: winkitty-bkup.dtric.com is not a valid server
15:16:39.285 [9272.9856] <2> process_request: command C_BPRESTORE_6_5_2_2 (126) received
15:16:39.285 [9272.9856] <2> ConnectionCache::connectAndCache: Acquiring new connection for host netbackup125, query type 84
15:16:39.285 [9272.9856] <2> vnet_pbxConnect: pbxConnectEx Succeeded
15:16:39.285 [9272.9856] <2> logconnections: BPDBM CONNECT FROM 192.168.20.5.57056 TO 192.168.20.5.1556 fd = 652
15:16:39.348 [9272.9856] <2> db_end: Need to collect reply
15:16:39.363 [9272.9856] <2> db_valid_master_server: client.xyz.com is not a valid server
15:16:39.363 [9272.9856] <2> get_type_of_client_list_restore: db_getCLIENT() failed: no entity was found (227)
15:16:39.363 [9272.9856] <2> get_type_of_client_list_restore: db_getCLIENT_by_hostname() failed: no entity was found (227)

 

Solution

It is necessary to add both hostnames and  IP addresses for the NetBackup Master\Media
server and the Oracle Client to the Client's hosts file.

    C:\WINDOWS\system32\drivers\etc\hosts
E.g.

127.0.0.1      localhost
192.168.20.5   client         client.xyz.com
192.168.1.5    client-bkup    client-bkup.xyz.com
192.168.20.2   master         master.xyz.com
192.168.1.2    master-bkup    master-bkup.xyz.com


Applies To

NetBackup  6.5   7. 0
Windows 2003  Windows 2008
Oracle 9.2.0.8

Was this content helpful?