Home » RDBMS Server » Backup & Recovery » ORA-19513: failed to identify sequential file (oracle 10.2.0.3 solaris 10)
ORA-19513: failed to identify sequential file [message #355589] Sat, 25 October 2008 16:15 Go to next message
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 #355595 is a reply to message #355589] Sun, 26 October 2008 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27206: requested file not found in media management catalog
 *Cause:  A backup file used in a recovery manager catalog maintenance
          command was not found in the media management catalog.
 *Action: Retry the command with a different file.

Regards
Michel
Re: ORA-19513: failed to identify sequential file [message #355597 is a reply to message #355589] Sun, 26 October 2008 00:28 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: list the backup information on rman
Next Topic: Change path of backup archivelogs
Goto Forum:
  


Current Time: Sat Dec 03 03:43:26 CST 2016

Total time taken to generate the page: 0.07696 seconds