Forum Discussion

kongasix's avatar
kongasix
Level 3
10 years ago

ORA-19511: non RMAN, but media manager or vendor specific failure, error text: Failed to process backup file <c-2057956423-20150516-0c>

Hi All,

I'm trying to restore Oracle 12c database backup, but unable to restore it,

script using for restoring controlfile :-

run
{
set until time "to_date('2015/05/15 18:40:00','YYYY/MM/DD HH24:MI:SS')";
allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ONLINE, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
restore controlfile;
alter database mount;
}

 

Error : -

channel ch1: ORA-19870: error while restoring backup piece c-2057956423-20150516-0d
ORA-19507: failed to retrieve sequential file, handle="c-2057956423-20150516-0d", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Failed to process backup file <c-2057956423-20150516-0d>

 

Detailed log :-

abcbkp02:> rman target / catalog rman/xxx@rmancat

Recovery Manager: Release 12.1.0.2.0 - Production on Fri May 15 20:10:23 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DSTGEDV (not mounted)
connected to recovery catalog database

run
{
set until time "to_date('2015/05/15 18:40:00','YYYY/MM/DD HH24:MI:SS')";
allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ONLINE, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
restore controlfile;
alter database mount;
}

executing command: SET until clause

allocated channel: ch1
channel ch1: SID=122 device type=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 7.6 (2015021210)

Starting restore at 15-MAY-15

new media label is "@aaaah" for piece "c-2057956423-20150515-2b"
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-2057956423-20150515-2b
channel ch1: ORA-19870: error while restoring backup piece c-2057956423-20150515-2b
ORA-19507: failed to retrieve sequential file, handle="c-2057956423-20150515-2b", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Failed to process backup file <c-2057956423-20150515-2b>

failover to previous backup

new media label is "@aaaah" for piece "c-2057956423-20150515-2a"
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-2057956423-20150515-2a
channel ch1: ORA-19870: error while restoring backup piece c-2057956423-20150515-2a
ORA-19507: failed to retrieve sequential file, handle="c-2057956423-20150515-2a", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Failed to process backup file <c-2057956423-20150515-2a>

failover to previous backup

^C
user interrupt received
PSDRPC returns significant error 1013.
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/15/2015 20:10:33
RMAN-03099: job cancelled at user request

**************************

Please let me know incase if any other info needed for this.

Thanks in advance for your suggestions/recommendations/solution.!

 

 

 

7.6
Agents
Backup and Recovery
NetBackup
Solaris
Upgrade
  • Roger_C's avatar
    Roger_C
    10 years ago


    If you are doing alternative client restore
    Try create a folder
    <Install path>\NetBackup\db\altnames
    \usr\openv\netbackup\db\altnames
    Create a file named "No.Restrictions"

    Also, Check that
    NB_ORA_SERV=abcbkp02

    Reflects the first entry in bp.conf
    SERVER=abcbkp02

12 Replies

Sort By
  • Roger_C's avatar
    Roger_C
    Level 4
    10 years ago

    Seem like an issue with the Oracle APi for NBU,

    Can you try restoring the controlfile to file destination?
    * restore controlfile to "/tmp/control.bak" from "c-2057956423-20150515-2b";

    Can you check the dbclient at the time of failure:
    (chmod 777 /usr/openv/netbackup/logs/dbclient)

    Show us the error that is being reported there.

     

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    Is this a redirected restore?

    If so, have you created altnames file(s) on the master server to allow redirected restore?

    Are you starting the restore as the same user id that performed the backup?

    Can you browse/list images on destination client with bplist?

    To troubleshoot, you need the following log folders (as a start) under netbackup/logs :

    On destination client: dbclient (777 permissions on folder).

    On master: bprd (restart NBU after creating the folder).

  • kongasix's avatar
    kongasix
    Level 3
    10 years ago

     

    dbclinet folder has full permissions i.e 777

     

    when it comes to ther error in dbclient logs

     

     

    20:07:30.570 [15870] <2> int_GetMMInfo: INF - Initialized Signal
    20:07:30.570 [15870] <2> int_GetMMInfo: INF - support for Proxy Copy enabled
    20:07:31.522 [15870] <2> logconnections: BPRD CONNECT FROM 10.200.50.70.36601 TO 10.200.50.70.13720 fd = 10
    20:07:31.545 [15870] <2> int_logDateRange: INF - Start Time = 05/14/15 12:00:00
    20:07:31.545 [15870] <2> int_logDateRange: INF - End Time = 05/16/15 20:07:31
    20:07:31.546 [15870] <2> logconnections: BPRD CONNECT FROM 10.200.50.70.36602 TO 10.200.50.70.13720 fd = 10
    20:07:32.594 [15870] <2> int_logDateRange: INF - Start Time = 05/14/15 12:00:00
    20:07:32.594 [15870] <2> int_logDateRange: INF - End Time = 05/16/15 20:07:32
    20:07:32.595 [15870] <2> logconnections: BPRD CONNECT FROM 10.200.50.70.36604 TO 10.200.50.70.13720 fd = 10
    20:07:32.608 [15870] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135
    20:07:32.608 [15870] <16> xbsa_QueryObject: ERR - VxBSAQueryObject: Failed with error:
       Server Status:  client is not validated to perform the requested operation
    20:07:32.608 [15870] <16> int_StartJob: ERR - Failed to process backup file <c-2057956423-20150515-2b>

  • kongasix's avatar
    kongasix
    Level 3
    10 years ago

    Got the same error while restoring it to temp location.!

     

    RMAN> run
    {
    allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ONLINE, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
    restore controlfile to "/tmp/control.bak" from "c-2057956423-20150515-2b";
    }2> 3> 4> 5>

    allocated channel: ch1
    channel ch1: SID=122 device type=SBT_TAPE
    channel ch1: Veritas NetBackup for Oracle - Release 7.6 (2015021210)

    Starting restore at 21-MAY-15

    channel ch1: restoring control file
    released channel: ch1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 05/21/2015 08:42:32
    ORA-19870: error while restoring backup piece c-2057956423-20150515-2b
    ORA-19507: failed to retrieve sequential file, handle="c-2057956423-20150515-2b", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
       Failed to process backup file <c-2057956423-20150515-2b>

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    Any possibility you can copy the entire log to dbclient.txt and upload as File attachment? We will need bprd log on the master server as well. Is the Oracle client perhaps a node in a cluster? Or multiple NICs/IPs? Or Client browse/restore disabled on Master's Client Attributes?
  • Roger_C's avatar
    Roger_C
    Level 4
    10 years ago


    If you are doing alternative client restore
    Try create a folder
    <Install path>\NetBackup\db\altnames
    \usr\openv\netbackup\db\altnames
    Create a file named "No.Restrictions"

    Also, Check that
    NB_ORA_SERV=abcbkp02

    Reflects the first entry in bp.conf
    SERVER=abcbkp02

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    You have not answered questions regarding redirected restore.. . Are you restoring to same client that did original backup or to different client? Please have another look at my post of 20 May.
  • kongasix's avatar
    kongasix
    Level 3
    10 years ago

    regarding redirected restore?

    it's an alternative restore.

    Are you restoring to same client that did original backup or to different client?

    I'm trying to restore on to  a different server so that will be different client too.

     

    If so, have you created altnames file(s) on the master server to allow redirected restore?

    I'm not sure, Please help me in  checking this info?

     

    Are you starting the restore as the same user id that performed the backup?

    yes.

     

    Can you browse/list images on destination client with bplist?

    not sure again how to do this

     

    On destination client: dbclient (777 permissions on folder).

    Yes folder having 777 permissions

     

    On master: bprd (restart NBU after creating the folder).

    Don't know how to do this.

    To troubleshoot, you need the following log folders (as a start) under netbackup/logs :

    Please see the attached log "dbclient.txt"

     

     

  • kongasix's avatar
    kongasix
    Level 3
    10 years ago

    NB_ORA_SERV=abcbkp02

    we don't have this entry

     

    Reflects the first entry in bp.conf
    SERVER=abcbkp02 ---> Yes we have the entry

     

    Note :- i just chaged the servername to abcbkp02 .. the original name is different.

     

     

     

  • kongasix's avatar
    kongasix
    Level 3
    10 years ago

    Hi,

    I just copied it an d attached as "dbclient.txt"

     

    *We will need bprd log on the master server as well. ?

    I have a small confusion here ... what is the master server..?

     

    *Is the Oracle client perhaps a node in a cluster? Or multiple NICs/IPs?
    Or Client browse/restore disabled on Master's Client Attributes?

    + It is not a node is a cluster.

    +There *are* multiple nics.

    + Client browse restore is not disabled on Master's Client attributes.