reset hana topology data

resettopology.sh

abcadm@node1:/usr/sap/ABC/HDB01> cdpy
abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> python landscapeHostConfiguration.py
nameserver node1:30101 not responding.
nameserver node1:30101,node3:30101,node2:30101 not responding.
| Host  | Host   | Host   | Failover | Remove | Storage   | Storage   | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host    | Host   | Worker  | Worker |
|       | Active | Status | Status   | Status | Config    | Actual    | Config   | Actual   | Config     | Actual     | Config      | Actual      | Config  | Actual | Config  | Actual |
|       |        |        |          |        | Partition | Partition | Group    | Group    | Role       | Role       | Role        | Role        | Roles   | Roles  | Groups  | Groups |
| ------| ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------- | ------ | ------- | ------ |
| node1 | no     | error  | ?        | ?      | ?         | ?         | ?        | ?        | master 1   | ?          | worker      | ?           | worker  | ?      | default | ?      |
| node2 | no     | error  | ?        | ?      | ?         | ?         | ?        | ?        | master 3   | ?          | worker      | ?           | worker  | ?      | default | ?      |
| node3 | no     | error  | ?        | ?      | ?         | ?         | ?        | ?        | master 2   | ?          | standby     | ?           | standby | ?      | default | ?      |

overall host status: error
abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> hdbnsutil -initTopology
nameserver node1:30101 not responding.
checking 2 master lock file(s) ........................................ ok
creating persistence ...
abcadm: no process found
hdbrsutil: no process found
run as transaction master

writing initial topology...
writing initial license: status check = 1
done.

abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> sapcontrol -nr 1 -function StartSystem HDB

23.02.2021 12:54:58
StartSystem
OK

abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> python landscapeHostConfiguration.py
| Host         | Host   | Host   | Failover | Remove | Storage   | Storage   | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host    | Host    | Worker  | Worker  |
|              | Active | Status | Status   | Status | Config    | Actual    | Config   | Actual   | Config     | Actual     | Config      | Actual      | Config  | Actual  | Config  | Actual  |
|              |        |        |          |        | Partition | Partition | Group    | Group    | Role       | Role       | Role        | Role        | Roles   | Roles   | Groups  | Groups  |
| ------------ | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------- | ------- | ------- | ------- |
| node1 | yes    | ok     |          |        |         1 |         1 | default  | default  | master 1   | master     | worker      | master      | worker  | worker  | default | default |
| node2 | yes    | ok     |          |        |         2 |         2 | default  | default  | master 3   | slave      | worker      | slave       | worker  | worker  | default | default |
| node3 | yes    | ignore |          |        |         0 |         0 | default  | default  | master 2   | slave      | standby     | standby     | standby | standby | default | -       |

overall host status: ok

abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> hdbsql -i1 -u system -p master 
Password:

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql ABC=> 

abcadm@node1:/usr/sap/ABC/HDB01/exe/python_support> hdbsql -i1 -u system -d systemdb -p master 
Password:

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql SYSTEMDB=> select * from m_databases;
| DATABASE | DESCRIPTION     | ACT | ACTIVE_S | OS_USER  | OS_GROUP | RESTART | F |
| -------- | --------------- | --- | -------- | -------- | -------- | ------- | - |
| SYSTEMDB | SystemDB-ABC-01 | YES |          |          |          | DEFAULT | ? |
| ABC      | ABC-01          | YES |          |          |          | DEFAULT | ? |
2 rows selected (overall time 21.178 msec; server time 639 usec)

hdbsql SYSTEMDB=> select database_name,
>   round(sum((estimated_size / 1024 / 1024 / 1024)), 2) estimated_size_gb
> from SYS_DATABASES.M_BACKUP_SIZE_ESTIMATIONS
> group by database_name
> order by database_name;
| DATABASE | ESTIMATED_SIZE_GB                          |
| -------- | ------------------------------------------ |
| ABC      |                         0.3400000000000000 |
| SYSTEMDB |                         0.1900000000000000 |
2 rows selected (overall time 34.128 msec; server time 14.115 msec)