Home » RDBMS Server » Backup & Recovery » error ORA-19625: error identifying file while rman backup using sap brbackup tool (Sun 10)
error ORA-19625: error identifying file while rman backup using sap brbackup tool [message #572784] Mon, 17 December 2012 10:41 Go to next message
s5usyp123
Messages: 2
Registered: December 2012
Junior Member
Hi,
We are running BCV backup which runs in a backup server using brbackup with rman and while cataloging we are getting the below error

ORA-19625: error identifying file /oracle/BQ2/sapbackup/bekcgqin.spa/perfstat.data0
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory

the backup is sucessfull and there is no directory bekcgqin.spa under /oracle/BQ2/sapbackup as below

-bash-3.2$ ls /oracle/BQ2/sapbackup/bekcgqin.spa/perfstat.data0
/oracle/BQ2/sapbackup/bekcgqin.spa/perfstat.data0: No such file or directory

and the file is under below and that is correct location and same in primary db also

/oracle/BQ2/sapdata17/perfstat_0/perfstat.data0

and below is the log where is failed and does any one know while cataloging why rman is looking the file under /oracle/BQ2/sapbackup/bekcgqin.spa/ and not under /oracle/BQ2/sapdata17/perfstat_0/


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of catalog command on default channel at 12/14/2012 20:37:31
ORA-19625: error identifying file /oracle/BQ2/sapbackup/bekcgqin.spa/bp1zmm.data
2
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3


RMAN>


Recovery Manager complete.
BR0200I BR_TRACE: location BrRmanCall-44, commands for RMAN in: /oracle/BQ2/sapb
ackup/.bekcgqin.cmd
'@/oracle/BQ2/sapbackup/..bekcgqin..cmd^'
'host '/usr/sap/BQ2/SYS/exe/run/brtools -f delete /oracle/BQ2/sapbackup/..bekcgq
in..cmd';^'
'sql 'alter session set optimizer_mode=RULE';^'
'catalog datafilecopy^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/perfstat.data0',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data65',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data9',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data10',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data66',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data11',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data67',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data12',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data68',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data13',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data69',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data14',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data70',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data15',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data71',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data16',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data72',^'
''/oracle/BQ2/sapbackup/bekcgqin.spa/bp1.data17',^'

thanks
Re: error ORA-19625: error identifying file while rman backup using sap brbackup tool [message #572792 is a reply to message #572784] Mon, 17 December 2012 11:32 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is not clear in "No such file or directory".
It seems there is a bug in brbackup, please post your question in a SAP forum, RMAN is the victim not the culprit.

Regards
Michel
Previous Topic: Rman Full backup failign when backing up temp file
Next Topic: running RMAN commands in RUN file to duplicate a database
Goto Forum:
  


Current Time: Thu Mar 28 06:15:13 CDT 2024