Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to copy Hana database". In daily operation, I believe many people have doubts about how to copy Hana database. Xiaobian consulted all kinds of materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to copy Hana database"! Next, please follow the small series to learn together!

1. Close the Hana database and fill in the IP address and relevant host name dedicated to System replication in the global.ini configuration file;

#su - s00adm

%HDB stop

vi /hana/shared/S00/global/hdb/custom/config/global.ini

[system_replication_communication]

listeninterface = .global

[system_replication_hostname_resolution]

10.5.2.11 = HW00002

2. In Hana database node 2, follow the above method '

#su - s00adm

%HDB stop

vi /hana/shared/S00/global/hdb/custom/config/global.ini

[system_replication_communication]

listeninterface = .global

[system_replication_hostname_resolution]

10.5.2.10 = HW00001

3. Log in to the master node and enable System Replication.

#su - s00adm

%HDB start

%hdbnsutil -sr_enable --name=HW00001

%hdbnsutil -sr_state

4. Log in to the backup node and register to the master node;(confirm that the network port is normal, close the HANA database, and restart the HANA database after configuration)

#su - s00adm

%HDB stop

%hdbnsutil -sr_register --remoteHost= HW00001 --remoteInstance=00 --mode=sync

--name= HW00002

%HDB

%hdbnsutil -sr_state

5. Log in to the Hana master node as root to view the replication status of the Hana database;

#cd /usr/sap/hdbclient

#./ hdbsql -U slehaloc 'select distinct REPLICATION_STATUS from

SYS.M_SERVICE_REPLICATION'

Or, check it out through Hana Studio.

Note: #prompt, indicating the root environment of the login operating system;

% prompt, indicating the login operating system s00adm environment;

At this point, the study of "how to copy Hana database" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.