02-24-2016 10:15 AM
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
02-24-2016 10:17 AM
Hi,
Forgot to mention,
All backups are going to disk.
Tried a File system restore nad was successful.
02-24-2016 10:31 AM
First of all. Can you list the files using bplist from the client?
bplist -S masterservername -C client -t 4 -R /
02-24-2016 10:37 AM
Yes please. bplist is working fine from both source and destination.
02-24-2016 11:12 PM
Have you changed the client_name to the source client in the target client in bp.conf ?
02-24-2016 11:29 PM
02-25-2016 12:44 AM
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