Re: Legato choking on datafile restore

Thanks,

They eventually knuckled down and fixed it, how I don't know. As I said that side is outsourced, and we don't have access to Legato directly.

Anyway, thanks, panic over.

Regards.
On Tue, 2008-12-23 at 02:51 -0800, Fuad Arshad wrote:
> 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_at_sequeira.org.uk> 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
++
I got a hint of things to come when I overheard my boss lamenting, 'The
books are done and we still don't have an author! I must sign someone
today!
		-- Tamim Ansary, "Edutopia Magazine, Issue 2, November 2004"
		   on the topic of school textbooks
++

--
http://www.freelists.org/webpage/oracle-l