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