My Oracle DBA received an error (see below) while running an RMAN
recover from tape. We're using 7.2.2 with NMO 4.2. The recovery was
chugging along but at some point generated the error.
Here's the RMAN recover script:
run {
set until sen 430640;
set until time "todate ('AUG 10 2007 10:20:00','Mon DD YYYY HH24:MI:SS')";
allocate channel T1 type SBTTAPE;
restore control file;
}
channel t1: reading from backup piece host_DBNAME_df_level0_3nioerpo_119.1
ORA-19870: error reading backup piece host_NODCDEV_df_level0_3nioerpo_119.1
ORA-19507: failed to retrieve sequential file,
handle="host_DBNAME_df_level0_3nioerpo_119.1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
A backup or restore session is already in progress. (100:17:0)
failover to previous backup
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/17/2007 14:46:19
ORA-27191: sbtinfo2 returned error
Additional information: 2
Anyone have any ideas of what might cause this? He inquired about
retrying from the clone copy, but I don't see anything in the media
database or the NetWorker logs (messages, daemon.log) to suggest there's
anything wrong with the original tape?
Maybe we should try to recover this as a save set to disk and then point
RMAN to the recovered data on disk?
George
--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145 | Voice: (301) 713-3284 x210
1315 East West Highway | Fax: (301) 713-3301
Silver Spring, MD 20910-3282 | Web Site: http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|