SAP HANA System Replication 설정
테스트 환경
- SAP HANA Version: 2.0 SP4
- Primary Host: hanadb01 (192.168.45.132)
- Secondary Host: hanadb02 (192.168.45.133)
- SID: THD
1. 사전 준비
1.1 파라미터 설정
Primary HANA DB의 global > [communication] > listenInterface 파라미터 .internal 로 설정
Secondary HANA DB의 global > [communication] > listenInterface 파라미터 .internal 로 설정
Primary HANA DB의 global > [internal_hostname_resolution] 파라미터에 Primary/Secondary IP주소와 Hostname 입력
Secondary HANA DB의 global > [internal_hostname_resolution] 파라미터에 Primary/Secondary IP주소와 Hostname 입력
Primary HANA DB의 global > [system_replication_hostname_resolution] 파라미터에 Primary/Secondary IP주소와 Hostname 입력
Secondary HANA DB의 global > [system_replication_hostname_resolution] 파라미터에 Primary/Secondary IP주소와 Hostname 입력
Primary HANA DB의 global.ini > [system_replication_communication] > allowed_sender 값을 Primary HANA DB와 Secondary HANA DB의 IP 대역으로 설정
Secondary HANA DB의 global.ini > [system_replication_communication] > allowed_sender 값을 Primary HANA DB와 Secondary HANA DB의 IP 대역으로 설정
1.2 Primary HANA DB의 PKI를 Secondary HANA DB로 복제
Secondary HANA DB의 PKI 백업
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs> ll
total 8
drwx------ 2 thdadm sapsys 4096 Jan 19 15:16 data
drwx------ 2 thdadm sapsys 4096 Jan 19 15:16 key
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs> cd data
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> ll
total 4
-rw-r--r-- 1 thdadm sapsys 2960 Jan 19 15:16 SSFS_THD.DAT
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> mv SSFS_THD.DAT SSFS_THD.DAT.BAK
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> ll
total 4
-rw-r--r-- 1 thdadm sapsys 2960 Jan 19 15:16 SSFS_THD.DAT.BAK
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> cd ..
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs> cd key/
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> ll
total 4
-rw-r----- 1 thdadm sapsys 187 Jan 19 15:16 SSFS_THD.KEY
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> mv SSFS_THD.KEY SSFS_THD.KEY.BAK
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> ll
total 4
-rw-r----- 1 thdadm sapsys 187 Jan 19 15:16 SSFS_THD.KEY.BAK
Primary HANA DB의 PKI를 Secondary HANA DB로 복제
thdadm@hanadb01:/usr/sap/THD/SYS/global/security/rsecssfs> ll
total 8
drwx------ 2 thdadm sapsys 4096 Jan 19 15:16 data
drwx------ 2 thdadm sapsys 4096 Jan 19 15:16 key
thdadm@hanadb01:/usr/sap/THD/SYS/global/security/rsecssfs> scp /usr/sap/THD/SYS/global/security/rsecssfs/data/SSFS_THD.DAT thdadm@192.168.45.133:/usr/sap/THD/SYS/global/security/rsecssfs/data/
The authenticity of host '192.168.45.133 (192.168.45.133)' can't be established.
ECDSA key fingerprint is SHA256:f7cmGNiFlLs8vYoVBxKkPvjPutEBbtriEpetsasS69o.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.45.133' (ECDSA) to the list of known hosts.
Password: <패스워드 입력>
SSFS_THD.DAT 100% 2960 3.0MB/s 00:00
thdadm@hanadb01:/usr/sap/THD/SYS/global/security/rsecssfs> scp /usr/sap/THD/SYS/global/security/rsecssfs/key/SSFS_THD.KEY thdadm@192.168.45.133:/usr/sap/THD/SYS/global/security/rsecssfs/key/
Password: <패스워드 입력>
SSFS_THD.KEY 100% 187 219.1KB/s 00:00
Secondary HANA DB에서 복제된 PKI 확인
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> ll
total 8
-rw-r--r-- 1 thdadm sapsys 2960 Feb 18 10:32 SSFS_THD.DAT
-rw-r--r-- 1 thdadm sapsys 2960 Jan 19 15:16 SSFS_THD.DAT.BAK
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/data> cd ../key/
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> ll
total 8
-rw-r----- 1 thdadm sapsys 187 Feb 18 10:35 SSFS_THD.KEY
-rw-r----- 1 thdadm sapsys 187 Jan 19 15:16 SSFS_THD.KEY.BAK
변경사항 적용을 위해 Secondary HANA DB 재시작
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> HDB stop
thdadm@hanadb02:/usr/sap/THD/SYS/global/security/rsecssfs/key> HDB start
1.3 Primary HANA DB 백업
1.3.1 SYSTEM DB 백업
SYSTEM DB 우클릭 > Backup and Recovery > Back Up System Database..
Complete Data Backup 선택 > Next
설정 확인 > Finish
백업 완료
1.3.2 Tenant DB 백업
SYSTEM DB 우클릭 > Backup and Recovery > Back Up Tenant Database..
SID 선택 > Next
Complete Data Backup 선택 > Next
설정 확인 > Finish
※ 이 외에 Administration Guide - General Prerequisites for Configuring SAP HANA System Replication에 나와 있는 것과 같이 사전 준비 필요
2. System Replication 설정
2.1 Primary HANA DB Replication 활성화
SYSTEM DB 우클릭 > Configuration and Monitoring > Configure System Replication..
<SID>adm 유저로 로그인
Enable system replication 선택 > Next
Primary System Logical Name 입력
※ Primary System Logical Name은 Primary DB를 지칭하는 논리적인 이름을 말하며, 추후 변경도 가능
설정 확인 > Finish
2.2 Secondary HANA DB System Replication 등록
등록을 위해 HANA DB 중지
즉시 중지
<SID>adm 계정으로 로그인
System Replication 등록을 위해 중지된 Secondary 시스템의 SYSTEM DB 우클릭 > Configuration and Monitoring > Configure System Replication..
Register secondary system > Next
Secondary System Logical Name에 사용할 논리적인 이름 입력
Replication Mode와 Operation Mode 선택
Source System Information에 Primary System의 정보 입력
설정 확인 및 완료
※ 만약 등록 이후 Status가 Unknown 상태이면 방화벽 포트 확인 필요
SAP Note 2176528 - Cannot start two HANA system on one host at the same time 에 따라 3<Instance Number + 1>01/03/07 에 대해서도 방화벽 열어줘야 함
※ 아래 오류가 발생할 경우, SAP HANA System Replication Registration 오류 포스팅 참고
참고자료: