Forum Discussion

shahriar_sadm's avatar
8 years ago

Failed to open backup file for restore (RMAN)

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

 

 

 

 

  • 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. 

  • 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. 

    • Michael_G_Ander's avatar
      Michael_G_Ander
      Level 6

      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.

  • 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.