cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

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

kongasix
Level 3

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Roger_C
Level 4
Employee


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

View solution in original post

12 REPLIES 12

Roger_C
Level 4
Employee

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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
Level 3

 

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
Level 3

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
Moderator
Moderator
Partner    VIP    Accredited Certified
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
Level 4
Employee


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
Moderator
Moderator
Partner    VIP    Accredited Certified
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
Level 3

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
Level 3

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
Level 3

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.

 

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Detailed steps to restore to same or to different client can be found in NetBackup for Oracle Administrator's Guide http://www.symantec.com/docs/DOC5175

kongasix
Level 3

Controlfile restoration issue has been resolved after adding No.restricstions file, but still i am facing the problem while restoring database!

 

Below is the logfile,

 

abcbkp02:> rman target / catalog rman/xxxx@rman12
 
Recovery Manager: Release 12.1.0.2.0 - Production on Thu May 28 05:47: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
 
RMAN> run
{
set until time "to_date('2015/05/25 20:30: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;
}
2> 3> 4> 5> 6>
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 28-MAY-15
 
new media label is "@aaaah" for piece "c-2057956423-20150525-2a"
channel ch1: starting datafile backup set restore
channel ch1: restoring control file
channel ch1: reading from backup piece c-2057956423-20150525-2a
channel ch1: piece handle=c-2057956423-20150525-2a tag=TAG20150525T200244
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:01:05
output file name=/u03/dstgedv/data01/control01.ctl
output file name=/u03/dstgedv/redo01/control02.ctl
output file name=/u03/dstgedv/redo02/control03.ctl
Finished restore at 28-MAY-15
released channel: ch1
 
RMAN> alter database mount;
 
Statement processed
 
RMAN> run
2> {
set until time "to_date('2015/05/25 20:30:00','YYYY/MM/DD HH24:MI:SS')";
3> 4> allocate channel ch1 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
5> allocate channel ch2 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
6> allocate channel ch3 type 'sbt_tape' parms="ENV=(NB_ORA_CLASS=AIR_ABCDB12_DB_DSTGEDV_ARCH, NB_ORA_SERV=abcbkp02, NB_ORA_CLIENT=abcdb12)";
7> restore  database;}
 
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)
 
allocated channel: ch2
channel ch2: SID=178 device type=SBT_TAPE
channel ch2: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
 
allocated channel: ch3
channel ch3: SID=241 device type=SBT_TAPE
channel ch3: Veritas NetBackup for Oracle - Release 7.6 (2015021210)
 
Starting restore at 28-MAY-15
 
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to /u03/dstgedv/data01/system01.dbf
channel ch1: restoring datafile 00006 to /u03/dstgedv/data01/users01.dbf
channel ch1: restoring datafile 00009 to /u03/dstgedv/data01/DSODBSPACE.dbf
channel ch1: reading from backup piece DSTGEDV_879778653_10307_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00002 to /u03/dstgedv/data01/iaspace.dbf
channel ch2: restoring datafile 00007 to /u03/dstgedv/data01/xmetasrsp.dbf
channel ch2: restoring datafile 00008 to /u03/dstgedv/data01/dseodb01.dbf
channel ch2: reading from backup piece DSTGEDV_879778653_10306_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00003 to /u03/dstgedv/data01/sysaux01.dbf
channel ch3: restoring datafile 00004 to /u03/dstgedv/undo01/undotbs01.dbf
channel ch3: restoring datafile 00005 to /u03/dstgedv/data01/xmetaspace.dbf
channel ch3: reading from backup piece DSTGEDV_879778653_10305_1
channel ch1: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10307_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10307_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879778653_10307_1> not found in NetBackup catalog
 
channel ch2: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10306_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10306_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879778653_10306_1> not found in NetBackup catalog
 
channel ch3: ORA-19870: error while restoring backup piece DSTGEDV_879778653_10305_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879778653_10305_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879778653_10305_1> not found in NetBackup catalog
 
failover to previous backup
 
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00001 to /u03/dstgedv/data01/system01.dbf
channel ch1: restoring datafile 00006 to /u03/dstgedv/data01/users01.dbf
channel ch1: restoring datafile 00009 to /u03/dstgedv/data01/DSODBSPACE.dbf
channel ch1: reading from backup piece DSTGEDV_879696472_10210_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00002 to /u03/dstgedv/data01/iaspace.dbf
channel ch2: restoring datafile 00007 to /u03/dstgedv/data01/xmetasrsp.dbf
channel ch2: restoring datafile 00008 to /u03/dstgedv/data01/dseodb01.dbf
channel ch2: reading from backup piece DSTGEDV_879696472_10209_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00003 to /u03/dstgedv/data01/sysaux01.dbf
channel ch3: restoring datafile 00004 to /u03/dstgedv/undo01/undotbs01.dbf
channel ch3: restoring datafile 00005 to /u03/dstgedv/data01/xmetaspace.dbf
channel ch3: reading from backup piece DSTGEDV_879696472_10208_1
channel ch1: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10210_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10210_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879696472_10210_1> not found in NetBackup catalog
 
channel ch2: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10209_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10209_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879696472_10209_1> not found in NetBackup catalog
 
channel ch3: ORA-19870: error while restoring backup piece DSTGEDV_879696472_10208_1
ORA-19507: failed to retrieve sequential file, handle="DSTGEDV_879696472_10208_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
   Backup file <DSTGEDV_879696472_10208_1> not found in NetBackup catalog
 
failover to previous backup
 
released channel: ch1
released channel: ch2
released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/28/2015 05:50:37
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

 

 

Please suggest what can be done to get out of this error.