[SAP] S/4HANA SYSTEMDB FULL SOLUTION

SYSTEMDB 가 FULL 차서 서비스가 정상적으로 올라오지 못해 이슈가 발생하였습니다. 

(/hana/shared 경로가 100%까지 full참)

아래와같이 로그의 경로를 심볼릭으로 지정하여 임시조치 후, configuration변경하여 log_mode 를 수정하였습니다. 

테스트 시스템이긴하지만 hostname 및 SID는 모자이크 처리하겠습니다.

S/4HANA SYSTEMDB FULL SOLUTION

 

 

Solution

 

1. Make sure that you are logged in as <SID>adm user on the host on

    which you experience the log volume full situation.

  -> sidamd계정으로 진행 후 작업해야 합니다. 

 

2. Stop the database:

 

    //usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function

    StopSystem HDB

StopSystem HDB

 

    

3. Wait that the database on all hosts is stopped completely.

 

4. Change directory into folder mnt00001 of the log volume (Default:

    /hana/log/<SID>/), e.g.:

 

    /cd /hana/log/<SID>/mnt00001

S/4HANA SYSTEMDB FULL SOLUTION

    

5. You have to move one of the log volumes temporarily to another

    volume where enough space is available.

    You should free at least 2 GB of space to ensure that the database

    has enough space to start. To find out the space consumption of each

    volume execute:

 

    /du -sh *

 

   

S/4HANA SYSTEMDB FULL SOLUTION

6. Move a volume which consumes at least 2 GB of space (e.g. hdb00003)

    to a volume with sufficient free space, e.g. to the data volume

    (Default: /hana/data/<SID>), e.g.:

 

    /mkdir /hana/data/<SID>/logs_temporary

 

    mv hdb00003 /hana/data/<SID>/logs_temporary

 

    /

7. Create a symbolic link to the new folder in the old location:

 

    /ln -s /hana/data/<SID>/logs_temporary/hdb00003

    /hana/log/<SID>/mnt00001/hdb00003

 

    /

8. Start the database:

 

    //usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function

    StartSystem HDB

 

    /

9. Wait until log backups are performed.

 

10. Use the following SQL-Statement to clean up the logvolume:

 

    /ALTER SYSTEM RECLAIM LOG;

 

    /

11. Stop the database again:

 

    /usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function

    StopSystem HDB/

 

    

 

그 이후에는 걸어두었던 LINK를 삭제하고, 원래의 위치에 복원합니다.

 

12. Wait that the database on all hosts is stopped completely./

 

    /

13. Remove the symbolic link:/

 

    /rm -f /hana/log/<SID>/mnt00001/hdb00003

 

    //

14. Move the log volume back to its original location:

 

    /mv /hana/data/<SID>/logs_temporary/hdb00003 /hana/log/<SID>/mnt00001

 

    /

15. Remove the temporary log folder:

    /

    rmdir /hana/data/<SID>/logs_temporary

 

    /

16. Start the database

 

    //usr/sap/hostctrl/exe/sapcontrol -nr <instance_number> -function

    StartSystem HDB/