Wednesday, 20 November 2019

Sandbox system via Homogenous System Copy (SAP HANA-specific: Backup/Restore) step-by-step guide

About


SAP system landscape is defined as an layout of SAP servers. Basically SAP environment consist a three-system landscape paradigm. A system landscape consists of Development Server (DEV), Quality Assurance server (QAS) and Production Server (PROD) Over time, you begin to understand that for experiments you need another independenty system – Sandbox (SAND).

Sandbox system gives a lot of freedom to all SAP consultants. Let’s start create sandbox system via Homogenous System Copy (SAP HANA-specific: Backup/Restore)

Prerequisites


◉ At maintenance window stop all background jobs in your production system (ABAP report – BTCTRNS1)

◉ Backup of your production system

◉ Start all background jobs in your production system (ABAP report – BTCTRNS2)

◉ Install new, clear SAP S4/HANA on sandbox host (call this point as the STEP1)

◉ Installed S4/HANA must be in running state

Resolution


Start two SSH sessions to your sandbox system host. In  SSH Session #1 start SWPM from root user

N.B. For example  /distr/SWPM/sapinst

Open your browser and enter URL address to access the SAP Installation Web Interface
Path to “Refresh or Move Database Instance” menu item in SWPM here.

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Existing profile detected – its OK.

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Useful tip – at this point Master password of your SandBox = Master password of your Production System

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

sidadm user from the sandbox host from the STEP1

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Homogenous System Copy (SAP HANA-specific: Backup/Restore)

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Credentials for HANA DB tenant from  the STEP1

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Credentials for SystemDB and SYSYEM (HANA DB super user) from the STEP1

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Package Path

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Some warnings (can be skipped)

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Credentials for sidadm OS user for HANA DB from the STEP1

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Mount and specify path to backup of production system

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Specify DDIC user credentials from 000 client of your production system

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

In the SSH Session #2 stop sandbox application server (stopsap R3) from sidadm OS-user

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Overview

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Starting database revovery for tenant from the STEP1 

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

All Done!

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Post installation steps for sandbox system


0. Consistency check in SICK transaction

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

1. Change name and open the Sandbox system for changes in SCC4/SE03 transactions

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

2. Remove RFC connections in SM59 (Except OSS-connections: SDCC_OSS, SAPOSS and for example connection to ADS-server)

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

3. Post-Installation Actions for Transport Organizer in SE06 transaction

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

4. Setup TMS-system in STMS transaction

N.B. All action in this step must be completed in 000 client

Include System In Transport Domain

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Set Password for User TMSADM

At this point TMSADM user from your Transport Domain system (generally – Master Password)

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

For removing “The transport route configuration is inconsistent” warning made Adjust with Conntroller action from main menu

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

Approach where SandBox and QAS systems in one target group

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

5. Change image into main menu in SMW0/SM30 transactions

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

6. Change Login Screen Info in SE61 transaction

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

7. Maintain license in SLICENSE transaction

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

8. Maintain active profile and profile parameters in RZ10 transaction

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

9. All steps done. Its time to first Ad-Hoc backup

SAP HANA Study Materials, SAP HANA Learning, SAP HANA Tutorial and Materials, SAP HANA Certifications, SAP HANA Online Exam

1 comment: