Re: Legato choking on datafile restore

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Tue, 23 Dec 2008 02:51:31 -0800 (PST)
Message-ID: <196465.26278.qm@web82107.mail.mud.yahoo.com>


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

++
This file will self-destruct in five minutes.
++
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 23 2008 - 04:51:31 CST

Original text of this message