New datafile to be added wrong value

[former_member206552]

Good Day,

What are the tables names used by BRTOOLS to calculate the next datafile name to be added as we have 1 system where the file numbering is out of sync.

[/oracle/SID/sapdata2/sr3ods_97/sr3ods_96.data]

I know you can just use option 3 in brtools to rectifiy this for future files but how can you rectify the current one without adding a new datafile.

Best Regards

Marius

[former_member773563]

I found the .tse file it is under $ORACLE_HOME/sapreorg location . However , even when added the first datafile after cloning the database we saw the issue .

[former_member773563]

I dont see any final solution for the problem raised . I am also seeing the same issue , there is no datafile manually added but still getting error . We cloned database using RMAN and then we are seeing this issue . I am unable to find the .tse files present at the /oracle/SID/sapreorg

[sunny_pahuja2]

Hi,

You can rename datafile using brtools.

http://help.sap.com/saphelp_nwpi71/helpdata/en/46/ab0aeeba0b62d6e10000000a1553f7/content.htm

Thanks

Sunny

[former_member206552]

Hi Sunny,

the previous file name is correct, problem seem to be one of the consultants added a datafile as database level and now brtools is not seeing that file

BR0280I BRSPACE time stamp: 2013-08-26 12.12.43
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata1/sr3ods_95/sr3ods_95.data]
2 * Last added file size in MB (lastsize) . [20480]
3 - New file to be added (file) ........... [/oracle/SID/sapdata1/sr3ods_97/sr3ods_96.data]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [20480]
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/sapdata2/sr3ods_97/sr3ods_96.data' size 20480M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

file 96 as been added manually

best regards

marius

[Reagan]

Good Day

problem seem to be one of the consultants added a datafile as database level and now brtools is not seeing that file

So my guess was right.

To the best of my knowledge BRTools read the .tse files present at the /oracle/SID/sapreorg location to populate the Last added file name.

Is there a directory called sr3ods_96 present at /oracle/SID/sapdata1 ? Maybe a reason why BRTools chose to create sr3ods_97 instead of 96.

If there is no sr3ods_96 then modify the string for the "New file to be added" with this directory name and see whether it helps.

Regards

RB

[sunny_pahuja2]

Hi,

I don't think this could be the problem. Could you please display all datafiles related to this tablespace from brtools and paste the result here?

Thanks

Sunny

[former_member206552]

Good Morning Reagan/Sunny

yes you can use option 3 to change it, which is not a problem, after we added this datafile and test again to see if the numbering is correct by running through the menu, we still have the same problem

List of datafiles

168 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata3/sr3ods_90/sr3ods_90.data
       202    31457280   101762984  NO     NO               0             0
169 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata4/sr3ods_91/sr3ods_91.data
       203    31457280   118540104  NO     NO               0             0
170 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata4/sr3ods_92/sr3ods_92.data
       204    31457280   118540104  NO     NO               0             0
171 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata4/sr3ods_93/sr3ods_93.data
       205    31457280   118540104  NO     NO               0             0
172 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata1/sr3ods_94/sr3ods_94.data
       206    31457280    73451344  NO     NO               0             0
173 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata2/sr3ods_95/sr3ods_95.data
       207    31457280    89180144  NO     NO               0             0
174 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata2/sr3ods_96/sr3ods_96.data
       208    31457280    89180144  NO     NO               0             0

as seen below if we use brtools to add another datafile it still shows incorrectly,

Options for extension of tablespace PSAPSR3ODS (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata1/sr3ods_96/sr3ods_96.data]
2 * Last added file size in MB (lastsize) . [30720]
3 - New file to be added (file) ........... [/oracle/SID/sapdata1/sr3ods_97/sr3ods_96.data]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [30720]
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 PSAPSR3ODS add datafile '/oracle/SID/sapdata1/sr3ods_97/sr3ods_96.data' size 30720M autoextend off]

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

Reagan, I have tried to make manuall changes to the strucSID.log and .tse to see if it will pick up the new values but this did not work

Best Regards

Marius

[sunny_pahuja2]

Hello,

As I can see datafiles related to this tablespace then Brtools is detecting that you have datafile 96 added for this tablespace. As far as options 3 is concerned while adding datafile then you can change option 3 and correct the path for new data file and there should not be any problem for that.

Thanks

Sunny

[former_member206552]

Hi Sunny,

Yes you are correct, we can just use option 3 and specify the correct name and number but I would like to find a way so that it picks up the correct number. I know there is a database table that it stores the information in just can't find it.....YET

Best Regards

Marius

[sunny_pahuja2]

I think it is not picking up correct information because you added datafile from database level earlier. If you will make correction in option 3 this time, then automatically it will pickup correct information next time.

Thanks

Sunny

[former_member206552]

This is exactly what we did we added but still not

172 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata1/sr3ods_94/sr3ods_94.data
       206    31457280    73451344  NO     NO               0             0
173 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata2/sr3ods_95/sr3ods_95.data
       207    31457280    89180144  NO     NO               0             0
174 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata2/sr3ods_96/sr3ods_96.data
       208    31457280    89180144  NO     NO               0             0
175 - PSAPSR3ODS     ONLINE  FILE  /oracle/SID/sapdata1/sr3ods_97/sr3ods_97.data
       209    31457280    73451344  NO     NO               0             0

Options for extension of tablespace PSAPSR3ODS (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata1/sr3ods_97/sr3ods_97.data]
2 * Last added file size in MB (lastsize) . [30720]
3 - New file to be added (file) ........... [/oracle/SID/sapdata1/sr3ods_98/sr3ods_97.data]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [30720]
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 PSAPSR3ODS add datafile '/oracle/SID/sapdata1/sr3ods_98/sr3ods_97.data' size 30720M autoextend off]

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

[former_member773563]

Did you get any solution for your problem? If so what was that .