Home » RDBMS Server » Backup & Recovery » RMAN System Copy Fails With ORA-19870 (Oracle 11h, Netbackup 7.1)
RMAN System Copy Fails With ORA-19870 [message #587446] Fri, 14 June 2013 15:58 Go to next message
QZ11
Messages: 1
Registered: June 2013
Junior Member
Hi,

We are running SAP with Oracle 11g with Netbackup 7.1.

We are using RMAN to copy a system from a full online to another server.

The procedure fails with the following:

channel ch00: starting datafile backup set restore
channel ch00: restoring control file

(
channel ch00: ORA-19870: error while restoring backup piece <backup piece>ORA-19507: failed to retrieve sequential file, handle="<backup piece>", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <backup piece> not found in NetBackup catalog.

However, when we issue the command " /usr/openv/netbackup/bin/bpclntcmd -ct Oracle -ml /<backup piece> ",
the tapes for the backup are listed accurately.

We think that the issue is that the ORA-19870errors occur a few seconds after "channel ch00
reading from backup piece <backup piece>" executes. However, the bpclntcmd command usually
takes 15 or 20 seconds to execute, so I think that the RMAN procedure times out.

Is there a way to configure RMAN or Netbackup to wait, say, a minute after the "channel ch00: reading from backup piece <backup piece>" statement until giving up with an ORA-19870 error.


Thanks,
QZ




Re: RMAN System Copy Fails With ORA-19870 [message #587460 is a reply to message #587446] Sat, 15 June 2013 01:14 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Not in RMAN, may be in NetBackup or MML between RMAN and NetBackup and you will then more likely get more and better help in a NetBackup forum or site.

Regards
Michel
Previous Topic: Backup and restore on different server
Next Topic: simulate recovery
Goto Forum:
  


Current Time: Sat Nov 23 06:20:55 CST 2024