cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to open backup file for restore (RMAN)

shahriar_sadm
Level 6

Hi dear all, we trying to restore Oracle database with RMAN, backup is table space backup and no control file included, but restore failed and no restore job starting on master server,

 

RMAN Log:

RMAN> catalog device type 'SBT_TAPE' backuppiece '0gs8m6dh_1_1';

released channel: ORA_SBT_TAPE_1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=2643 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 7.7.2 (2016011116)
ORA-19870: error while restoring backup piece 0gs8m6dh_1_1
ORA-19507: failed to retrieve sequential file, handle="0gs8m6dh_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Failed to open backup file for restore.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 07/09/2017 13:19:47
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: —------------- —-------------------------------------------------
RMAN-06214: Backup Piece 0gs8m6dh_1_1

-------------------------

restore client bprd log:

15:22:37.461 [862] <8> xbsa_GetEnv: WRN - NBBSA_SCHEDULE not found in environment block
15:22:37.461 [862] <2> int_LogSystemInfo: INF - Veritas NetBackup for Oracle - Release 7.7.2 (2016011116) System name: SunOS Node name: restore_client_hostname Release: 5.10 Version: Generic_147147-26 Machine: sun4u User name: oracle Client Host: restore_client_hostname
15:22:37.461 [862] <2> int_GetMMInfo: INF - Initialized Signal
15:22:37.461 [862] <2> int_GetMMInfo: INF - support for Proxy Copy enabled
15:22:37.463 [862] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_SERV> cmd_val=<master_hostname>
15:22:37.463 [862] <2> int_ProcessCommand: INF - Server <master_hostname> will be used for this API session.
15:22:37.463 [862] <4> int_ProcessCommandString: INF - cmd_key=<NB_ORA_CLIENT> cmd_val=<orginal_server_hostname>
15:22:37.463 [862] <2> int_ProcessCommand: INF - Client <orginal_server_hostname> will be used for this API session.
15:22:37.801 [862] <2> vnet_pbxConnect: pbxConnectEx Succeeded
15:22:37.801 [862] <2> logconnections: BPRD CONNECT FROM restore_client_IP.65397 TO master_IP.1556 fd = 12
15:22:37.810 [862] <2> int_GetBfsDateRange: INF - Using default date range
15:22:37.810 [862] <2> int_logDateRange: INF - Start Time = 12/26/95 03:30:00
15:22:37.810 [862] <2> int_logDateRange: INF - End Time = 07/10/17 15:22:37
15:22:37.812 [862] <2> vnet_pbxConnect: pbxConnectEx Succeeded
15:22:37.812 [862] <2> logconnections: BPRD CONNECT FROM restore_client_IP.65398 TO master_IP.1556 fd = 12
15:22:37.900 [862] <2> vnet_pbxConnect: pbxConnectEx Succeeded
15:22:37.900 [862] <2> logconnections: BPRD CONNECT FROM restore_client_IP.65399 TO master_IP.1556 fd = 12
15:22:38.035 [862] <2> xbsa_ProgressLogSetup: INF - No progress log: Job will proceed without progress logging
15:22:38.036 [862] <4> sendRequest: request: <oracle oinstall orginal_server_hostname restore_client_hostname restore_client_hostname restore_client_hostname /usr/openv/netbackup/logs/user_ops/dbext/logs/862.0.1499597558 NONE NONE 0 1499597558 1499337234 1499337234 1499597558 4 0 0 0 0 12 0 4 0 100 101 0 0 0 C C C C C 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NONE -1 0 0 0 0 NONE NONE -1 4 NONE>
15:22:38.037 [862] <2> vnet_pbxConnect: pbxConnectEx Succeeded
15:22:38.037 [862] <2> logconnections: BPRD CONNECT FROM restore_client_IP.65400 TO master_IP.1556 fd = 13
15:23:26.514 [862] <16> serverResponse: ERR - server exited with status 2850: Restore error
15:23:26.514 [862] <16> RestoreFileObjects: ERR - serverResponse() failed
15:23:26.514 [862] <16> VxBSAGetObject: ERR - System error occurred trying to retrieve object in RestoreFileObject. Status: 3
15:23:26.515 [862] <16> xbsa_GetObject: ERR - VxBSAGetObject: Failed with error: Server Status: Restore error
15:23:26.515 [862] <16> int_StartJob: ERR - Failed to open backup file for restore.

( orginal server=client that we backed up from, restore client=destination)

and I cant find anything on master bprd,

Thanks

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

So, this is a redirected restore?

orginal_server_hostname  .....  restore_client_hostname 

Have you created the necessary files in altnames folder on the master? 
Detailed instructions in NetBackup for Oracle Administrator's Guide 

PS:
bprd log on the master will only start logging restore info after restart of NBU on the master (or if you know how to restart bprd only). 
dbclient on the destination client is the client log to be checked. 

View solution in original post

4 REPLIES 4

Mike_Gavrilov
Moderator
Moderator
Partner    VIP    Accredited Certified
Does your master server know about restore_client_hostname? Try to run:
#bpplclients | grep restore_client_hostname
and if it doesn't know add the client to any non-active policies and try to start restore again.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

So, this is a redirected restore?

orginal_server_hostname  .....  restore_client_hostname 

Have you created the necessary files in altnames folder on the master? 
Detailed instructions in NetBackup for Oracle Administrator's Guide 

PS:
bprd log on the master will only start logging restore info after restart of NBU on the master (or if you know how to restart bprd only). 
dbclient on the destination client is the client log to be checked. 

Looking at the file handle in the RMAN log, it looks very much like a control file handle.

So if that is not included in the backup you need your DBA to (re)create a control file at the destination client.

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

It works for me!