SAP Knowledge Base Article - Preview

2433293 - BR1052E File is already used by the database

Symptom

  • You tried to extend a tablespace using BR*Tools, but there was an error:

BR1052E File <datafile> is already used by the database - this can cause problems in backups

  • "Last added file name" and "New file to be added" fields have the same datafile name.

 

For example:

---------------------------------------------------------------------------

Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/<sid>/sapdata1/sr3_1/sr3.data1]
 2 * Last added file size in MB (lastsize) . [14300]
 3 - New file to be added (file) ........... [/oracle/<sid>/sapdata1/sr3_2/sr3.data1]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [2000]
 6 - File autoextend mode (autoextend) ..... [no]
 7 # Maximum file size in MB (maxsize) ..... []
 8 # File increment size in MB (incrsize) .. []
 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/<sid>/sapdata1/sr3_2/sr3.data1' size 2000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2016-09-29 14:08:07
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1052E File sr3.data1 is already used by the database - this can cause problems in backups

BR0280I BRSPACE time stamp: 2016-09-29 14:08:07
BR0669I Cannot continue due to previous warnings or errors - you can go back and repeat the last action
BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

---------------------------------------------------------------------------


Read more...

Environment

SAP systems with Oracle database

Product

SAP NetWeaver all versions

Keywords

Brtools, BRSPACE, BR1052E, tablespace, extend, datafile, BR0669I, oracle , KBA , BC-DB-ORA-DBA , Database Administration , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.