Home » RDBMS Server » Backup & Recovery » ORA-19513: failed to identify sequential file (Oracle 10g, Suse Linux)
ORA-19513: failed to identify sequential file [message #347967] Mon, 15 September 2008 03:56 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
During incremental backup i got the following error today morning.
Before that everything was going well but today i got the unexpected error.
Please tell me how can i resolve the error?

Is it related to media management? or anything else; please calrify.

RMAN> # INCREMENTAL LEVEL 1 
2> RUN
3> {
4>      ALLOCATE CHANNEL c1 DEVICE TYPE 'sbt_tape'PARMS
5>     'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
6> 
7>     BACKUP INCREMENTAL LEVEL 1 FILESPERSET 1
8>     TAG = 'INC LVL 1 DB BKUP' DATABASE INCLUDE CURRENT CONTROLFILE
9>     FORMAT = 'Inc_1_%U_%T.bkp';
10>     
11> 
12>     BACKUP FILESPERSET 10
13>     FORMAT = 'Arch_%U_%T.bkp'
14>     ARCHIVELOG ALL 
15>     DELETE INPUT;
16>     #DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-1';
17>     RELEASE CHANNEL c1;
18> }
allocated channel: c1
channel c1: sid=105 devtype=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.3.3.0

Starting backup at 15-SEP-08
channel c1: starting incremental level 1 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00016 name=/u01/test/oracle/oradata/ora01/TEST_M_IND/TEST_M_IND_01.dbf
channel c1: starting piece 1 at 15-SEP-08
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 09/15/2008 01:05:25
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
ORA-19502: write error on file "Inc_1_u2jqk3op_1_1_20080915.bkp", blockno 513 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure

Re: ORA-19513: failed to identify sequential file [message #347982 is a reply to message #347967] Mon, 15 September 2008 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ANS1017E (RC-50) Session rejected: TCP/IP connection failure

TSM can't access backup server.
Check your backup server, network, TSM parameters, TSM error logs, tdpo.log...
This is NOT an Oracle error.

Regards
Michel

[Updated on: Mon, 15 September 2008 04:37]

Report message to a moderator

Re: ORA-19513: failed to identify sequential file [message #347990 is a reply to message #347967] Mon, 15 September 2008 04:48 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Michel for yor quick reply.

Quote:
TSM can't access backup server.

Please tell me more about the TSM.
How to check it and what to check it?

Thanks,


[Updated on: Mon, 15 September 2008 04:51]

Report message to a moderator

Re: ORA-19513: failed to identify sequential file [message #347996 is a reply to message #347990] Mon, 15 September 2008 05:45 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Sorry, it was about 10 years I didn't use it. Ask your sys admin.
There is some logs such as tdpo.log, I don't remember the other ones.

Regards
Michel
Previous Topic: spfile recovery
Next Topic: backup files size
Goto Forum:
  


Current Time: Fri Nov 22 12:28:01 CST 2024