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



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

Other related posts: