cancel
Showing results for 
Search instead for 
Did you mean: 

Error While addding a new datafile

Former Member
0 Kudos

Dear All,

We have the tablespace PSAPUSER1D in one of our production systems,which is 100% full .I am trying to extend the tablespace using brtools,but i am unable to do it and it is giving the following error.

BR0280I BRSPACE time stamp: 2007-11-05 06.55.50

BR0657I Input menu 303 - please check/enter input values

-


Options for extension of tablespace PSAPUSER1D (1. file)

1 * Last added file name (lastfile) ....... [/oracle/P01/sapdata1/psapuser1d_1.dbf]

2 * Last added file size in MB (lastsize) . [273]

3 - New file to be added (file) ........... [/oracle/P01/sapdata2/psapuser1d_1.dbf]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [273]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [0]

8 - File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPUSER1D add datafile '/oracle/P01/sapdata2/psapuser1d_1.dbf' size 273M autoextend on next 20M maxsize unlimited]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2007-11-05 06.55.56

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1052W File psapuser1d_1.dbf is already used by the database

<u><b>BR1055E Database file /oracle/P01/sapdata2/psapuser1d_1.dbf must be located in a subdirectory of 'sapdata' directory</b>BR0669I Cannot continue due to</u> previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2007-11-05 06.55.56

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

so please kindly give any suggestions.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member185954
Active Contributor
0 Kudos

Hi Balaji,

there is no problem with adding datafiles with the same name, however some tools may object if there are any errors.

even if you have the same filename, in the dba_data_files dictionary table, each file has its own file id and oracle doesn't write files using filenames , but uses file descriptors.

Regards,

Siddhesh

Former Member
0 Kudos

and not multiple datafiles per directory.

that's how it is designed.

Peter

former_member193294
Active Participant
0 Kudos

I just had a similar issue this morning. Try to use sapdba tool by logging with ora<sid> of course.

It is much more flexible than BRTools and OEM and it will give you automatically the path for the next datafile.

Give it a try and tell us if that also has helped in your case.

Feel free to award points if useful.

Brgds,

Loukas

Former Member
0 Kudos

Hi Balaji,

You can add the datafile to the same "sapdata1" as long as you call the second datafile "psapuser1d_<b>2</b>.dbf" instead of the same name "psapuser1d_<b>1</b>.dbf" in a different "sapdata".

This should also be working using BRTools.

Succes,

Albert

Former Member
0 Kudos

Hi Balaji,

The path you're giving to BRSPACE isn't correct. SAP expects something like "/oracle/P01/sapdata1/<b>usr_1</b>/psapuser1d_<b>1</b>.dbf", "/oracle/P01/sapdataX/<b>usr_2</b>/psapuser1d_<b>2</b>.dbf", and so on.

and that's why is showing the error "(...)must be located in a subdirectory of 'sapdata' directory".

Best Regards,

JC Llanes.

Message was edited by:

Juan Carlos Llanes

Former Member
0 Kudos

Dear Llanes,

A strange thing that i notice in one of our systems is that we dont have the standard directory structure like this

"/oracle/P01/sapdata1/usr_1/psapuser1d_1.dbf",

but we have the following structure

$ ls -l /oracle/P01/sapdata1

total 168573168

drwxr-xr-x 2 orap01 dba 96 Apr 21 2006 cntrl

drwxr-xr-x 2 orap01 dba 96 Jul 7 21:52 erp_1

-rw-r----- 1 orap01 dba 286408704 Nov 5 08:43 psapuser1d_1.dbf

-rw-r----- 1 orap01 dba 268451840 Nov 5 08:43 psapuser1i_1.dbf

-rw-r----- 1 orap01 dba 838868992 Nov 5 08:55 system_1.dbf

Wherein the datafiles have been directly added to the sapdata1 directory,without the corresponding subdirectory.so how can we proceed in this scenario.

Regards

Balaji.P

Former Member
0 Kudos

To manage this, the better option is to use Oracle tools, not BR*s, p.e. Oracle Enterprise Manager (aka OEM). Sap's tools won't let you use these paths.

You also can make it directly with sqlplus, but it's a little bit dangerous (it depends of your DBA experience).

Best Regards,

JC Llanes.