Unable to take backup of BIW DEV system

[Former Member]

Hi Guys,

I am unable to take backup of our BIW DEV system through Brtools.

Error:

BR0051I BRBACKUP 7.00 (40)

BR0055I Start of database backup: belavkgc.dbv 2013-04-23 21.54.14

BR0484I BRBACKUP log file: /oracle/GBD/sapbackup/belavkgc.dbv

BR0477I Oracle pfile /oracle/GBD/112_64/dbs/initGBD.ora created from spfile /ora                                                                                                 cle/GBD/112_64/dbs/spfileGBD.ora

BR0280I BRBACKUP time stamp: 2013-04-23 21.54.15

BR0301E SQL error -1187 at location BrDbfInfoGet-1, SQL statement:

'OPEN curs_8 CURSOR FOR'

'SELECT TS.TABLESPACE_NAME, TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXTENT_MAN                                                                                                 AGEMENT, DF.FILE_NAME, DF.FILE_ID, NVL(DF.STATUS, ' '), NVL(DF.BYTES, 0), NVL(DF                                                                                                 .AUTOEXTENSIBLE, 'NO'), NVL(DF.MAXBYTES, 0), NVL(DF.INCREMENT_BY, 0) FROM DBA_TA                                                                                                 BLESPACES TS, DBA_DATA_FILES DF WHERE TS.TABLESPACE_NAME = DF.TABLESPACE_NAME UN                                                                                                 ION ALL SELECT TS.TABLESPACE_NAME, TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXT                                                                                                 ENT_MANAGEMENT, TF.FILE_NAME, TF.FILE_ID * -1, NVL(TF.STATUS, ' '), NVL(TF.BYTES                                                                                                 , 0), NVL(TF.AUTOEXTENSIBLE, 'NO'), NVL(TF.MAXBYTES, 0), NVL(TF.INCREMENT_BY, 0)                                                                                                  FROM DBA_TABLESPACES TS, DBA_TEMP_FILES TF WHERE TS.TABLESPACE_NAME = TF.TABLES                                                                                                 PACE_NAME ORDER BY 1, 6'

ORA-01187: cannot read from file  because it failed verification tests

ORA-01110: data file 201: '/oracle/GBD/sapdata1/temp_1/temp.data1'

BR0314E Collection of information on database files failed

BR0056I End of database backup: belavkgc.dbv 2013-04-23 21.54.15

BR0280I BRBACKUP time stamp: 2013-04-23 21.54.15

BR0054I BRBACKUP terminated with errors

Pls help.

Best Regards,

Madhura.

[Reagan]

Hello

http://scn.sap.com/thread/3348350

Cheers

RB

[former_member206552]

1.
create temporary tablespace temp2 tempfile '/rdbms/temp01/temp2.dbf' size 10M;
2.
alter database default temporary tablespace temp2;
3.
drop tablespace psaptemp including contents and datafiles;

now change back to psaptemp again with following step bellow:

1.
create temporary tablespace psaptemp tempfile '/rdbms/temp01/temp2_01.dbf' size 1024M;
2.
alter database default temporary tablespace psaptemp;
3.
drop tablespace temp2 including contents and datafiles;

[stefan_koehler]

Hi Madhura,

the issue is caused by a missing / invalid temp file. Just recreate or drop/add it and the issue should be resolved.

Regards

Stefan