Oracle Tablespace details. Pre and Post upgrade.

[abhijeet_singh2]

Dear Experts,

For SAP NW 730 upgrade to NW 731, I am working in planning phase.

Here I need to gather the requirement from Oracle DB perspective which is running on 11.2. SBP version too will be provided if required.

I have already gone through the upgrade Master guide and Stack specific SUM tool guide.

Also i have covered the note 1805195 - Handling and troubleshooting of tablespaces during Upgrades, EhPs and SPs updates, which SAP says is release independent.

I am highly doubtful with the TS name changes after upgrade, as per the note mentioned above. As, i have never seen any TS  with name PSAP<SID>X. Also it speaks in length about the issues encountered during that stage due to inconsistencies with TBTCO tables.

Since as per the upgrade guide, these issues will be encountered at DB cloning stage only, I would request have the right information handy with me to avoid any delay at the time of upgrade.

Please provide your understanding on how DB cloning can be optimized and how to avoid known issues with TS modification in downtime.

Thanks

Abhijeet

[ASSUMED ANSWERED AND LOCKED - MODERATOR - 09-Sep-2015]

[JamesZ · Accepted solution]

Hi Abhijeet,

As long as there is no inconsistency in TAORA, IAORA and TSORA, then you should not encounter the issue mentioned in the note. I would say I do not see the real relationship of PSAP<SID>X and the problem mentioned in the note. it is a little misleading.

Best regards,
James

[abhijeet_singh2 · Accepted solution]

Thanks for sharing your input.

Indeed the note and tablespace naming conventions are little misleading.

At the DB cloning (preprocessing step of copying into shadow TS), which all TS are cloned ?

Are all the TS cloned or only PSAP<SID><Release> is cloned ?

To my understanding, Shadow instance only consist of Basis tables. (ref : Upgrade  guide).

Please correct me if i am wrong.

Thanks

Abhijeet

[JamesZ · Accepted solution]

Hi Abhijeet,

I talked with my upgrade colleagues. Not all tables are cloned, only some exchange tables are cloned. So not all the tablesapces are cloned.

Which tablespaces are cloned on earth, it may depend.

Best regards,
James

[abhijeet_singh2 · Accepted solution]

Please explain what is this "exchange tables"

Thanks

Abhijeet

[JamesZ · Accepted solution]

Hi Abhijeet,

Sorry, I cannot explain what is "exchange table".... You may need to reach SAP upgrade team to get the exact answer.

Best regards,
James