Home » RDBMS Server » Backup & Recovery » RMAN-03009/ORA-19513 (Failed to identify sequential file)
RMAN-03009/ORA-19513 [message #300934] Mon, 18 February 2008 14:46 Go to next message
DrNeko
Messages: 17
Registered: January 2007
Location: NJ
Junior Member
I've been running into a problem with my backup script. Everything was working until the hard drives containing the archive log filled before being backed up to the backup server and purged from the hard drive. Some of the archive logs were moved to a temporary hard drive (via OS command), and updated the RMAN repository by using CROSSCHECK, and DELETE OBSOLETE. Now when I run the backup script, I get this error:

channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00031 name=E:\ORACLE\DATAFILE\ORCL\FILE2F3.DBF
input datafile fno=00079 name=E:\ORACLE\DATAFILE\ORCL\FILE_LRG10.DBF
input datafile fno=00094 name=E:\ORACLE\DATAFILE\ORCL\FILE2F26.DBF
channel t1: starting piece 1 at 2008-02-17:13:36:22
RMAN-03009: failure of backup command on t1 channel at 02/17/2008 13:46:17
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 t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00029 name=E:\ORACLE\DATAFILE\ORCL\FILE2F1.DBF
input datafile fno=00032 name=E:\ORACLE\DATAFILE\ORCL\FILEF8.DBF
input datafile fno=00092 name=F:\ORACLE\DATAFILE\ORCL\FILE2F25.DBF

channel t1: starting piece 1 at 2008-02-17:13:46:17
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 02/17/2008 13:55:12
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog


All the datafiles exist, and I have no idea how to fix this problem. I'm running Veritas Netbackup. Any help? Thanks.

[Updated on: Mon, 18 February 2008 14:52]

Report message to a moderator

Re: RMAN-03009/ORA-19513 [message #301116 is a reply to message #300934] Tue, 19 February 2008 04:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you backing to tape?
Re: RMAN-03009/ORA-19513 [message #301196 is a reply to message #301116] Tue, 19 February 2008 08:38 Go to previous messageGo to next message
DrNeko
Messages: 17
Registered: January 2007
Location: NJ
Junior Member
According to the backup admin, he says that although the script says, "allocate channel t1 type 'SBT_TAPE';", it's actually backing up to a hard drive. Below is the script that's being run:
run {
# Hot database level 0 whole backup
 
allocate channel t1 type 'SBT_TAPE'; 
 
send 'NB_ORA_SERV=host1, NB_ORA_CLIENT=host2, NB_ORA_CLASS=IP_ORACLE_HOST2, NB_ORA_SCHED=Default-Policy'; 
 
#allocate channel t2 type 'SBT_TAPE'; 
 
 backup
   incremental level 0
   skip inaccessible
   tag hot_db_bk_level0
   filesperset 10
   # recommended format
   format 'bk_%s_%p_%t'
     (database);
 
   sql 'alter system archive log current';
 
   # backup all archive logs
   backup
    filesperset 25
    format 'al_%s_%p_%t'
    (archivelog all
     delete input);
 }
Re: RMAN-03009/ORA-19513 [message #301202 is a reply to message #301196] Tue, 19 February 2008 09:21 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Well,
according to the posted script, you are backing to tapes.
This has to do with Veritas MML.
Ask your backup administrator to check the Veritas environment.

Previous Topic: Incremental backups are huge
Next Topic: Do the long time affect to restore datafile?
Goto Forum:
  


Current Time: Sat Dec 03 10:15:36 CST 2016

Total time taken to generate the page: 0.06276 seconds