after system copy u0131 see PSAPTEMP size is 0 from db02

[Former Member]

hi

our system is sap ecc6 on oracle 10g (aix 5.3)

after system copy ı see psaptemp table size is 0.original size is 2gb from prod system

using brtools ı added a new file for psaptemp then ı did a stop/start and ı saw 2gb for psaptemp

ı checked file location for psaptemp in file system that it is ok.

after every system copy should I did this action ?

have you got any ideas?

[Former Member · Accepted solution]

Hi,

Sounds like you did a tape restore from prod to QA

Did you use alter database backup controlfile to trace from your prod system for the rebuild ?

At the base of the trace file there would be the syntax to create the PSAPTEMP file.

Looks like you have deleted that bit....

No big worries if it's missing as long as you put it in before using the system in anger....

Put in your notes to add the PSAPTEMP file in after you opened the database sucessfully.

Mark

[Former Member · Accepted solution]

hi

you are right ..

really there is a line for creating psaptemp and ı havent seen that line

thanks

[Former Member]

Depending on the release, TEMPFILES are not saved by BRBACKUP as part of the backup (see Notes 416782 and 635552).

More info in following SAP Note :

Note 659946 - FAQ: Temporary tablespaces

After restore you can always create PSAPTEMP again.

Success.

Wim

[Former Member]

thank you your answer