| RMAN-03009/ORA-19513 [message #300934] |
Mon, 18 February 2008 14:46  |
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 #301196 is a reply to message #301116] |
Tue, 19 February 2008 08:38  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
