Software Update Manager: Clean up tasks, Shadow Instance & Temp. Tablespace X

[#1]

Hi Experts,

I wanted to know that after an upgrade activity using SUM (Software Update Manager) how should I proceed with the cleanup tasks.

As SUM uses a shadow instance for the upgrade and for which a temporary table space is required, we can release some space once the upgrade has completed, right?

In my case (SPS08 upgrade in Solution Manager 7.1), a temporary tablespace PSAPSR3702X of 32GB was required before execution.

So I created that in order to upgrade my system.

My upgrade went successful, and now I would like to cleanup the space that was occupied during the upgrade.

I believe that scope here for cleanup is:

1) The temporary SAP Tablespace PSAPSR3720X (32 GB), data file is under /oracle/<SID>/sapdata4

2) SUM Directory (Upgrade directory /usr/sap/<SID>/SUM, which is 21G and contains the logs,files, shadow instance)

What should be the approach to process the clean-up post upgrade?

A) Is this approach feasible?

1. Stop SAP & DB
2. Drop SAP Temporary Tablespace
3. Drop SUM Directory
4. Start SAP & DB and validate

I also looked up SAP note 1732061, which is central note for SUM, it talks about, Do not select "Cleanup and start afresh" before finalization.

So in the postprocessing phase after the upgrade completes and just before Finalization phase, I have selected "Continue" as per the above mentioned note during the upgrade.

B) Or is it that, if I start SUM again and I get an option in the beginning "Cleanup & Start Afresh" which shall do the necessary cleanup, though I am not really sure, if this the possible feature of SUM!

Which is the correct approach? Could you please suggest, as I have worked with SUM for the first time.

Regards,

Akshay.

[Former Member]

Hi Experts,

I hope i am not much late in this topic i facing similar problem after i upgrade my ECC6.0 system to ECC6.0 EHP6.I need all of your suggestion on this.I a Newbie in Upgrades and organizing table spaces you help will be appreciated. 

What are the steps i should perform as you can see OLD Tablespace PSAPPRD700 not free.

Regards.

Gohar Mustafa

[Reagan]

926 Segments in the PSAPPRD700 tablespace compared to 891 segments in the PSAPPRD731 tablespace.

Did you really perform the EHP upgrade as advised ?

First make sure that everything is OK with the upgraded system.

Use BRTools tbreorg function to move the contents of the PSAPPRD700 tablespace to PSAPPRD731 tablespace.

Regards

RB

[Former Member]

Hi RB,

Thank for you valuable comment.

926 Segments what does it means it should be equal while comparing both releases tablespaces?

Yes,I have perform EHP6 upgrade and have full summary report with status components EHP6.

i have received few errors in ST22 for PXA NO FREE SPACE.

What are those other steps to see upgrade system is OK?

Ok BRtools i will use to move the contents i guess from space management option.

Thanks and regards,

Gohar Mustafa

[Reagan]

su - orasid

brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPPRD700 -t "*" -parallel 3 -degree 3 -newts PSAPSR3731

Good Luck

RB