Arkema - SAP Refresh System - Plan to refresh Q88 from O88

 Plan to refresh Q88 from O88

I. Preparations:

1- Logon message: Tcode SE61 > General Text, French, ZLOGIN_SCREEN_INFO

2- Client Overview: Tcode SCC4 > 000 & 060

3- SMTP for Business Communication: Tcode: SCOT > Setting > Default Domain

4- Transport Management System > 

- Overview > Transport Route

- Extras > System overview > Q88

- Environment > Import overview > Q88 > Goto > Import monitor

- Environment > Import overview > Q88 > Queue > Check > Transport Tool

5- Maintain Logon Group: Tcode SMLG

6- CCMS RFC Server Group Maintenance: Tcode RZ12

7- Spool Administration: Tcode SPAD > List of Spool Servers 

8- Administration of the secure storage: Tcode SECSTORE

9- Trust manager for single sign-on display: Tcode STRUSTSSO2 > Display <-> Change > PSE > Export

- System PSE

- System Server Standard

- SSL Client SSL client (Anonymous)

- SSL Client SSL Client (Standard)

10- RFC Connection Test with Logon Data: Tcode SE38 > RSRFCCHK > Execute connection test 

11- Table RSBASIDOC: Tcode SE16 > RSBASIDOC

12- Destination for Parallel Processing: Tcode OMIQ 

13- Service Data Control Center: Tcode SDCCN

14- BDLS conversion matrix: Tcode BDLSMATRIX

15- Partner Profiles: Tcode WE20 > 

- Q44CLNT100

- G1BCLNT100

- P62060

- G75CLNT210

- Q88060

16- Display Control Object: Tcode SM61

17- Export client: Tcode SCC8 > Client 000 & 060

- Profile: SAP_USER

- Schedule in background: Imediately & No Printer dialog

- Note the TR for client 000 (Q88KT00259) & Client 060 (Q88KT00258)

18- Check client export: Tcode SCC3 > Export Client 000 & 060

II. Refresh

1- Set downtime for Centreon: SAP_Q88 

2- Change the logon Group: Tcode SLMG > _Default  -> SAVE 

Note: C:\"Program Files (x86)"\SAP\FrontEnd\SAPgui\Sapgui.exe sl20a029.ic.corp.local 10

3- Suspend jobs: Tcode: SE38 > BTCTRNS1 

4- Put the Cluster in the maintainance mode

- SAP CS (sl20a027, sl20a028)

crm status

crm configure property maintenance-mode=true

crm status

- SAP HANA DB (sl20a025, sl20a026)

crm status

crm configure property maintenance-mode=true

crm status

5- Stop SAP ABAP (sl20a029, sl20a030)

- sl20a029

a6027387x@sl20a029

sudo su -

sudo - q88adm

stopsap r3

- sl20a030

a6027387x@sl20a030

sudo su -

sudo - q88adm

stopsap r3

6- Stop SAP ERS and ASCS (sl20a027, sl20a028)

- sl20a027

a6027387x@sl20a027

sudo su -

su - q88adm

stopsap 

- sl20a028

a6027387x@sl20a028

sudo su -

su - q88adm

stopsap 

7- Export scripts

a6027387x@sl20a029

sudo su -

su - q88adm

cd /usr/sap/trans/REFRESH/actions

./01_EXPORT_BEFORE_RESTORE.sh > Confirm: Yes > PKG export: STAR > Delete exist export: Yes 

cd /usr/sap/trans/REFRESH/clone/Q88/log

grep "End of Transport" EXP_*

8- Copy Backup (Perform on the HANA Prod (O88@OAH) -> Non Prod(Q88@QAH) )

a6027387x@sl20a031

sudo su -

su - oahadm

cd /site/procedures/HanaRefresh/

./CopyS3BackupForRefresh.sh

- Source DB: OAH

- Entry ID: 1706216411419

- Name: backup_full_OAH_O88_Thu_databackup_2_2

- Prefix:  backup_full_OAH_O88_Thu

- Transfer mode: CopyBackupAndStructure

- Target DB: QAH

- Check the backup (root): aws s3 ls s3://sap-backup-413702942639-eu-west-1/qah/OAH/usr/sap/OAH/SYS/global/hdb/backint/DB_O88

- Restore HANA DB (Non BackInt): Connect to the QAH SYSTEMDB on HANA Studio (SYSTEMDB@QAH) > Backup and Recovery > Recover Tenant DB >  Q88 > 

  BackInt system copy w/o backup catalog > source tenant@source instance: O88@OAH > Close & Log off HANA

- Test connectivity: R3trans -d 

9- Import scripts

a6027387x@sl20a029

sudo su -

su - q88adm

cd /usr/sap/trans/REFRESH/actions

./02_CLEANUP_SAP_INSTANCE_DIRECTORIES.sh > Yes

./04_CLEANUP_TABLES.sh > Yes

./05_IMPORT_AFTER_RESTORE.sh > Yes > STAR > ALL

cd /usr/sap/trans/REFRESH/clone/Q88/log 

grep "End of Transport" IMP_*

III. Start SAP

- sl20a027 (SAPCSQ)

a6027387x@sl20a027

sudo su -

su - q88adm

startsap 

- sl20a028 (SAPERSQ)

a6027387x@sl20a028

sudo su -

su - q88adm

startsap 

- sl20a029

a6027387x@sl20a029

sudo su -

sudo - q88adm

startsap r3

- sl20a030

a6027387x@sl20a030

sudo su -

sudo - q88adm

startsap r3

1- Switch the logon group (Client 000): 

Tcode: SMLG > BW->_BW; DEFAULT->_DEFAULT;PORTAL->_PORTAL;UNIVERSE->_UNIVERSE > Save

1- Consitency check: Tcode SICK

2- Transport STMS: 

- Adjust with controller: Tcode STMS > Route > Adjust with controller 

- Check for transport Tool: Tocde STMS > Environment > Import overview > Q88 > Queue > Check > Transport Tool

3- Import Users Client 000 & 060 

- Tcode SCC4 > Protect level 0: No restriction

- Client copy Tcode: SCC7 > Client 000 & Client 060 

- Tcode STMS > Import overview > Q88 > Q88KT00259 (Client 000) & Q88KT00258 (Client 060) > Import request > Import > Tcode SCC7 (run)> Tcode SCC3 (check) 

- Incase of having no authorized for the client 060: a6027387x@sl20a029 > sudo su -q88adm > tp import Q88KT00258 Q88 client=060 U128 pf=/usr/sap/trans/bin/TP_DOMAIN_T88.PFL

4- Reset Buffer User: Tcode: SU53 (SE38 > RSUSR405)

5- Check the license: Tcode SLICENSE

6- Check Spool consistency: Tcode SP12

7- FRC Verification: Tcode SE38 > RSRFCCHK  

8- Login message: Tcode SE61 > General text > edit ZLOGIN_SCREEN_INFO > Language: French

9- Clean-up updates: Tcode SE338 > RSTS0030 > Delete all

10- Cleanup Spool: Tcode SE38 > RSPO1041

11- Certificate check: Tcode STRUST 

12- BDLS Conversions (client 060)

- For STAR: Tcode SE11 > Activate the tables DFKKKO and DFKKMKO > Dictionary objects > Activate

- Tcode BDLS > Maintain Conversion Matrix :RFRFSH  Q88060 RF 20210730 > Program > Execute in Background

- Tcode SLG1 > Object -> CALE 

- Tcode SM37 to check the spool RBDLSMAP2

- a6027387x@sl20a029

sudo su -

su - q88adm

cd /CDSAP/REFRESH.NEW/actions/

./09_DROP_BDLS_INDEXES.sh

13- Activate the connection from the Partner in BDLS matrix (client 060)

Tcode: WE20 > Partner Type LS > Specify the Partner system > Classification > Partner Status -> Activate

11- Clean the statistics in ST03: Tcode SE37 > SWNC_COLLECTOR_CLEAN_SWNCMONI > Leave empty

12- SCOT Configuration: Tcode SCOT > Default Domain -> arkemagroup.com > SMTP setting -> Parameter 

13- BW Step: 

- Open SCC4 on Q88 and check the RFC from G88 to G1B and G1B to Q88 

- Check WE21 for the port configuration: Tocde WE21 > Port > Connection from B1G - Q88 

- Check the RFC destination Q88060 on the BW: Tcode SM59 > ABAP connection > Q88 060 > Restore > User -> RFC_G1B_100 

- Tcode RSA1 > Source system Q88 client 060 > Update the user/pwd FRC_G1B_100 > Only Activate > Restore source system > Yes 

- Analyse the logs: Tcode SLG1 > RSAR > All logs > Format complete the database 

- Check RFC to G1B from the Q88 - change to the load balancing from host to group > Tcode SM59 > ABAP connection > G1BCNT100 > 

Technical setting > Target G1B > Msg. Server: sapg1b.ic.corp.local

- Close client in SCC4

14- Remove the maintainence mode: 

- a6027387x@sl20a027

sudo su -

crm status

crm configure property maintenance-mode=true

crm status

- a6027387x@sl20a025

sudo su -

crm status

crm configure property maintenance-mode=true

crm status

15- Release the jobs: Tcode SE38 > BTCTRNS2

16- Reconfigure Early Watch Session: Tcode SDCCN > Delete all tasks > Utilities > Activate > Maintain Service Definition

Wait for the maintenance progress done then create the accordance services then reschedule:

- Maintenance package.

- Refresh session.

- Service preparation check.

- Refresh service definition.

- Delete old session.

17- Clock the client 000 and 060 in Q88: Tcode SCC4 > No change allowed > No change to respository > Protection level 1 

18- Logon group activation: Tcode SMLG > revert the name the same at the begginning

19- Check the RFC connection in SOLMAN > O2S > SOLMAN_SETUP > Configure System > Configure All Scenarios > Manage System > Check RFC