Re: Strange RMAN error

Michael

Incidentally we had a similar error yesterday.I am not sure to what extent this will be of help.

RMAN-03009: failure of backup command on t1 channel at 01/21/2007 11:08:05

ORA-19513: failed to identify sequential file

ORA-27206: requested file not found in media management catalog continuing other job steps, job failed will not be re-run released channel: t1 released channel: t2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on t2 channel at 01/21/2007 11:08:20

ORA-19513: failed to identify sequential file

ORA-27206: requested file not found in media management catalog

We fixed it and this is what the Legato person had to say.

We had a problem with staging this weekend that resulted in are netapp mount filling up. This mount holds are index files so at 100% full legato could not write any new indexes so all jobs failed. This has been fixed and we will work on getting notified when a NFS mount starts getting full.

 HTH GovindanK
On Mon, 22 Jan 2007 12:08:33 -0500, "Kline.Michael" <Michael.Kline_at_SunTrust.com> said:

Metalink hasn’t been a whole lot of help. On one, it was false. Answer was:

o BACKUP_TAPE_IO_SLAVES is false. DBWR_IO_SLAVES is zero.

Veritas support will probably get a call.

System:

rarp:/u001/app/oracle/admin/rman> uname -a

HP-UX ga016de1 B.11.11 U 9000/800 1448194010 unlimited-user license

Database:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

NetBackup:

allocated channel: ch00

channel ch00: sid=129 devtype=SBT_TAPE

channel ch00: VERITAS NetBackup for Oracle - Release 5.1 (2005081403)

Error:

Between sets, we get this, yet the job keeps cooking.

input datafile fno=00070 name=/u004/oradata/rarp/ck_10405_indx_01.dbf

channel ch01: starting piece 1 at 2007-01-22:11:56:57

RMAN-03009: failure of backup command on ch00 channel at 01/22/2007 11:59:32

ORA-19513: failed to identify sequential file

ORA-27206: requested file not found in media management catalog

continuing other job steps, job failed will not be re-run

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

input datafile fno=00050 name=/u005/oradata/rarp/ck_10601_01.dbf

Command was:

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'

parms 'BLKSIZE=2097152';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'

parms 'BLKSIZE=2097152';

sql 'alter system archive log current';

BACKUP     $BACKUP_TYPE     FILESPERSET 5     FORMAT 'FULL_%s_%p_%t'

    DATABASE; RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

 1030 Wilmer Avenue

Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446

Cell: 804.744.1545
[1]michael.kline_at_suntrust.com

Seeing beyond Money(sm)

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]
References

1. mailto:michael.kline_at_suntrust.com

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