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 with Oracle , 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 ONE Support launchpad (Login required).

Search for additional results

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