RMAN redirected restore failing

[anishC1]

Hello experts,

i am facing some issues with a RMAN reirected restore.

The previous issue on a LINUX server was resolved by giving permission to the entire netbackup directory on the destination server.

This restore is happening over SOLARIS 10 and even though the error is same, permission to netbackup directory is not solving the case.

ANy ideas please?

no logs are getting generated in the client server.

master: NBU7602, SLES10 SP2

media: NBU7602, SLES10 SP2

Client: Solaris 10 5/09 s10s_u7wos_08 SPARC, NetBackup-Solaris10 7.1.0.3

SID is the same for both backup and restore.

Error at client end:

Error:

bash-3.2$ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 24 10:51:03 2016

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

RMAN> connect target sys/dictionary@COLT.PRODUCTION

connect catalog rman1/board@rmancatconnected to target database: COLT (DBID=3815752705)

RMAN>

connected to recovery catalog database

RMAN> connect auxiliary sys/dictionary@COLT.QA-Svr

connected to auxiliary database: COLT (DBID=3815752705, not open)

RMAN> run{
allocate channel ch1 type SBT_TAPE;
set UNTIL TIME "to_date('Feb 11 2016 16:00:00','Mon DD YYYY HH24:MI:SS')";
restore database;
}2> 3> 4> 5>

starting full resync of recovery catalog
full resync complete
allocated channel: ch1
channel ch1: SID=507 device type=SBT_TAPE
channel ch1: Veritas NetBackup for Oracle - Release 7.1 (2011120716)

executing command: SET until clause

Starting restore at 24-FEB-16

channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00002 to /TDB/tdb1/ORACLE/COLT/DBS/undots1_.dbf
channel ch1: restoring datafile 00156 to /TDB/tdb12/ORACLE/COLT/DBS/imagespace79.dbf
channel ch1: restoring datafile 00163 to /TDB/tdb12/ORACLE/COLT/DBS/imagespace80a.dbf
channel ch1: restoring datafile 00166 to /TDB/tdb12/ORACLE/COLT/DBS/imagespace88.dbf
channel ch1: reading from backup piece 2eqtjmos_1_1
channel ch1: ORA-19870: error while restoring backup piece 2eqtjmos_1_1
ORA-19507: failed to retrieve sequential file, handle="2eqtjmos_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

No restore jobs in master server.

logs created on client:

drwxrwxrwx   2 root     root          96 Feb 24 00:00 bpcd
drwxrwxrwx   2 root     root          96 Feb 23 16:37 bpdbsbora
drwxrwxrwx   2 root     root          96 Feb 23 16:37 bphdb
drwxrwxrwx   2 root     root          96 Feb 23 16:37 dbclient
drwxrwxrwx   2 root     bin           96 Jul  6  2012 nbliveup
drwxrwxrwx   3 root     bin           96 May  7  2010 user_ops
drwxrwxrwx   2 root     root          96 Feb 24 00:00 vnetd

none had any data when created and ran the restore.

please help.

Thanks,

Anish

[anishC1]

Hi,

Forgot to mention,

All backups are going to disk.

Tried a File system restore nad was successful.

[RiaanBadenhorst]

First of all. Can you list the files using bplist from the client?

bplist -S masterservername -C client -t 4 -R /

[anishC1]

Yes please. bplist is working fine from both source and destination.

[Michael_G_Ander]

Have you changed the client_name to the source client in the target client in bp.conf ?

[Marianne]

Filesystem backup does not initiate connection from client to the master. Oracle backup and restore does. Confirm forward and reverse name lookup between master and client and port connectivity on 1556. Please run the bplist command as per Riaan's post and bpclntcmd -pn

[Michal_Mikulik1]

Hello Anish,

I think there are two points to correct:

1/ if source and destination server differ, you must use NB_ORA_CLIENT directive in allocate channel command before the restore so that correct client images are found

2/ RMAN "duplicate database" command is determined for this type of restore, not "restore database" command

Rgds

Michal