Re: Legato choking on datafile restore
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: "tony@xxxxxxxxxxxxxxx" <tony@xxxxxxxxxxxxxxx>
- Date: Tue, 23 Dec 2008 02:51:31 -0800 (PST)
You might be missing legato indexes run an mminfo command on the backup piece
you can get the backup piece from the rman catalog. Also check to make sure the
nsr_client is the same as on backup
Fuad
On Dec 23, 2008, at 2:29, "S. Anthony Sequeira" <tony@xxxxxxxxxxxxxxx> wrote:
Hi,
I have an SR open, just wanted to know if anyone had seen this before?
Oracle EE 10.2.0.3, Windows Server 2003. The Legato side is managed by
a third party, so am unable to provide any more details, though I can
ask if anything is required.
RMAN catalog resides in a 9.2.0.8 database. Backup went OK.
Starting restore at 23 DEC 2008 07:12:27
channel tap1: starting datafile backupset restore
channel tap1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to H:\ORACLE\ORADATA\DWHQ\COGNOS02.DBF
channel tap1: reading from backup piece gfk2plgf_1_1
channel tap2: starting datafile backupset restore
channel tap2: specifying datafile(s) to restore from backup set
restoring datafile 00009 to H:\ORACLE\ORADATA\DWHQ\COGNOS03.DBF
channel tap2: reading from backup piece ggk2plgf_1_1
channel tap3: starting datafile backupset restore
channel tap3: specifying datafile(s) to restore from backup set
restoring datafile 00007 to H:\ORACLE\ORADATA\DWHQ\COGNOS01.DBF
channel tap3: reading from backup piece gek2plgf_1_1
channel tap4: starting datafile backupset restore
channel tap4: specifying datafile(s) to restore from backup set
restoring datafile 00011 to H:\ORACLE\ORADATA\DWHQ\DWHTEMP02.DBF
channel tap4: reading from backup piece gik2pml1_1_1
ORA-19870: error reading backup piece gfk2plgf_1_1
ORA-19507: failed to retrieve sequential file, handle="gfk2plgf_1_1",
parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: phgbfr-s2979 could not find backup file
gfk2plgf_1_1
ORA-19870: error reading backup piece ggk2plgf_1_1
ORA-19507: failed to retrieve sequential file, handle="ggk2plgf_1_1",
parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: phgbfr-s2979 could not find backup file
ggk2plgf_1_1
ORA-19870: error reading backup piece gek2plgf_1_1
ORA-19507: failed to retrieve sequential file, handle="gek2plgf_1_1",
parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: phgbfr-s2979 could not find backup file
gek2plgf_1_1
ORA-19870: error reading backup piece gik2pml1_1_1
ORA-19507: failed to retrieve sequential file, handle="gik2pml1_1_1",
parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
nwora_open_restore: phgbfr-s2979 could not find backup file
gik2pml1_1_1
--
S. Anthony Sequeira
++
This file will self-destruct in five minutes.
++
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
