| ORA-19513: failed to identify sequential file [message #355589] |
Sat, 25 October 2008 16:15  |
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
|
Member |
|
|
Experts,
i am getting following error while taking archive backup.
all the backup ran successfully in the past, last one day we are getting this problem. i check in the metalink, and this problem is more relates to MM catalog. i check with my backup team, they are saying that every thing are ok at their end.
please find the error message
can any one give me guidelines where oracle is failing to identify sequential file
Starting backup at 25-OCT-08
channel dev1: starting full datafile backupset channel dev1: specifying datafile(s) in backupset including current control file in backupset channel dev1: starting piece 1 at 25-OCT-08 released channel: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev1 channel at 10/25/2008 19:33:20
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
Recovery Manager complete.
i found this information from netbackup log files
UMGPRD2:{bass}79% tail log.102508
04:35:04.720 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61348 TO 10.10.6.34.13720
04:35:05.237 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61349 TO 10.10.6.34.13720
04:35:05.738 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61350 TO 10.10.6.34.13720
04:35:05.922 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61351 TO 10.10.6.34.13720
04:35:06.103 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61352 TO 10.10.6.34.13720
04:35:06.293 [8498] <2> logconnections: BPRD CONNECT FROM 10.10.6.254.61353 TO 10.10.6.34.13720
04:35:06.454 [8498] <4> VxBSAQueryObject: INF - No match was found for query
04:35:06.454 [8498] <2> int_FindBackupImage: INF - ctl_dbname _669011483_2220_1 not found
04:35:06.454 [8498] <4> int_RemoveImage: INF - Backup file, ctl_dbname_669011483_2220_1, not found in image catalog.
[Updated on: Sat, 25 October 2008 16:16] Report message to a moderator |
|
|
|
|
|
| Re: ORA-19513: failed to identify sequential file [message #355597 is a reply to message #355589] |
Sun, 26 October 2008 00:28  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
Michel,
Thanks for quick response. i did not understand below line
*Action: Retry the command with a different file.
which file i have to use. why i am getting this problem.
could you please provide me some more information on this.
i was also get same problem before. that time i did not understand what my seniors did.
[Updated on: Sun, 26 October 2008 00:33] Report message to a moderator |
|
|
|
| Re: ORA-19513: failed to identify sequential file [message #355599 is a reply to message #355589] |
Sun, 26 October 2008 01:58 |
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
|
Member |
|
|
Michel,
Thanks for reply. i have in a problem where i can't determine the problem.
actually rman backup is running fine from one node and from second node it is giving the problem.
one more thing i have noticed that on 24 th one backup is ran on the disk instead of tape. will it cause any problem.
so it is clearly understand the some thing is not sync with the catalog. please correct me if i am wrong. if you want i can post the details.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
