error ORA-19625: error identifying file while rman backup using sap brbackup tool [message #572784] |
Mon, 17 December 2012 10:41 |
|
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
|
|
|
|