cancel
Showing results for 
Search instead for 
Did you mean: 

getting ORA-19625: error identifying file while running brbackup with rman

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

volker_borowski2
Active Contributor
0 Kudos

Hi,

when runnning RMAN backups, brbackups copies all datafiles to the corresponding *.spa directory under sapbackup. For sure there is not enough space to store the entire DB there, this is why the files get stored there as sparse-files. Theses are just copies to let brbackup do the catalog in the end and they are erased as soon as the backup ends.

So you need to track this directory while your backup still runs to crosscheck if there is something wrong with the permissions of the sparse files.

Watch out: If your backup aborts, the sparse directory might not get cleared, which will be a nightmare for a simple filesystem backup of the .../sapbackup tree.

Hope this helps

Volker

Former Member
0 Kudos

Hi,

Thanks very much for the reply and during backup we saw the directory bekcgqin.spa created and permission looks correct same like other files in sapbackup and so my question is looks like brbackup removes the directory before it does the catalog and so how can we avoid that.There are no other errors in the backup other then this one.

thanks

volker_borowski2
Active Contributor
0 Kudos

Hi,

can you confirm "correct" as a "orasid:dba" ownership?

If the backup is run through DB13, it might be possible, that the SUID bit of brbackup

will not work in cascade when RMAN is called.

You should try to run as DB owner first to avoid possible SUID side effects.

Another thing might be OS or DB release related.

There was some stuff with filesystem mount options on several systems, esp. for async IO.

So whats the software versions you are on for OS, DB and brtools ?

The rman script seems to have strange chars near EOL. "^"

Is that original or comming from pasting to SCN ?

Volker

Former Member
0 Kudos

Hi,

Thanks and "^" is the log file also and have uploaded the whole log also and we are in 11.2.0.2 on Sun Solarin 10 and the directory was owned by orabq2:dba and backup is run using orabq2.

Also not related to this issue do you know how to run the rman backup using recovery catalog using brbackup as we only use nocatalog and want to test using recovery catalog.

thanks again for the help.

volker_borowski2
Active Contributor
0 Kudos

Hui,

never saw an online_split working with rman_util together ... very interesting.

Well brbackup 7.20 is a bit low (patchlevel 8), 29 is current and the patchtext for patch 22 suggest that something was done to split_mirror stuff. I'd give that a try for starters.

This here looks pretty frightening to me 🙂

BR0202I Copying /oracle/BQ2/sapbackup/cntrlBQ2.dbf
BR0203I to /oracle/BQ2/origlogA/cntrl/cntrlBQ2.dbf ...

BR0202I Copying /oracle/BQ2/sapbackup/cntrlBQ2.dbf
BR0203I to /oracle/BQ2/sapdata1/cntrl/cntrlBQ2.dbf ...

BR0202I Copying /oracle/BQ2/sapbackup/cntrlBQ2.dbf
BR0203I to /oracle/BQ2/saparch/cntrl/cntrlBQ2.dbf ...

... seems to be the wrong direction to me for a backup...

Anyway, could it be, that the sapbackup tree needs to be splitmounted as well to make the split backup work? I mean, for brbackup, the backup is technically ended, when the split is complete, the rman transfer is laterafter, so may be the backup itself cleans the .spa directory because it thinks it is ready?

As far as the catalog stuff is concerned, I think it is not fully integrated yet. Note 1113677 has just some type of workaround.

Volker

volker_borowski2
Active Contributor
0 Kudos

Hm,

ja, something different with the SAPBACKUP path/environment needs to be done I think,

because this:

BR0351I Restoring /oracle/BQ2/112_64/dbs/sapBQ2.ora
BR0355I from /oracle/BQ2/112_64/dbs/sapBQ2.ora ...
BR0477I Oracle pfile /oracle/BQ2/112_64/dbs/initBQ2.ora created from spfile /oracle/BQ2/112_64/dbs/spfileBQ2.ora

BR0351I Restoring /oracle/BQ2/sapbackup/cntrlBQ2.dbf
BR0355I from /oracle/BQ2/sapbackup/cntrlBQ2.dbf ...

right at the start does not really make any sense...

What about the environment settings as requesred by note 170607 ?

Volker