Re: Legato choking on datafile restore

  • From: "S. Anthony Sequeira" <tony@xxxxxxxxxxxxxxx>
  • To: Oracle List <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 Dec 2008 11:44:54 +0000

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@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
++
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
++

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


Other related posts: