Datafile Addition PSAPSR3

[#1]

Dear Experts

When I tried to add new data file to the psapsr3 database to the New sap system which was make using a system copy by the production system.

generate an error while extending the table space though the brtools.

I select the option 7 and then provide the size 9216

Then I provide the above error msg and not added the datafile to the tablespace.

Please look at the issue and correct me.

reg

priyan

[Former Member · Accepted solution]

Dear All

Thank you very much giving important information to me.

I deleted the data files 19 and 20 which were created during system copy. Because they did not display though the DB02 or database.

Then tried to add the new data file was successful

reg

priyan

[hemanth2]

Dear priyan,

Hope you are doing good.

Could you please check if the below helps:

http://scn.sap.com/docs/DOC-10467

Thank you and have a nice day :).

_____________
Kind Regards,
Hemanth

How to Extend Database Tablespace and then Verify the Operation in the R/3 Server

[Former Member]

The below query would provide you the information on the datafiles used by the database  -:

SQL> select file_name from dba_data_files ;

If the files listed doen not include <absolute path / sr3.data19 > then it indicates that the file is not used by this database . In this case you can rename the datafile at the OS level using the mv command  and then again proceed with the addition of datafile using BR*Tools

If this file is existing in the database then < Absolute Path > then the same file cannot be added. If you wish to add the file with the same name and in the absolute path  then you would require to rename the existing one first and then try adding the datafile.

[former_member189725]

Does the sr3_19 directory already existing under /oracle/PI1/sapdata4 ?

Regards

Ratnajit

[Former Member]

Hi  Ratnajit.

yes having

But why it display me to add the 19th one it should be 20? isnt it ?

[former_member189725]

check the datafiles existing  under PSAPSR3 .

Remove the folders which are not used .i.e which does not have a datafile under it.

brspace would create the directories as required.

Regards

Ratnajit

[volker_borowski2]

I guess you did not delete the old files when overwriting with the systemcopy.

You have quite a couple of duplicate directories in the different sapdatas.

Like i.e. sr3_3 and sr3_4 in sapdata1 and sapdata2

ls -lt /oracle/PI1/*data*/*.*

should list you all files following sap convention and it will have oldest files last in the list,

so you can check if there are files left with very old timestamps.

Crosscheck v$datafile for the real datafiles the DB is using to get rid of the old ones.

Volker