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
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.