{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["各网元负责人联系表","每日检查模板","每周检查内容","月末检查模板"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"各网元负责人联系表","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["网元","第一责任制","电话","第二责任人","电话"]
["01UMS","涂珉",18153798380,"邹炜琪",18075677001]
["02EMS","涂珉",18153798380,"邹炜琪",18075677001]
["04AAA","吴杰法",13677381530,"邹炜琪",18075677001]
["05SMS","朱文",17607310211,"周理鹏",18153798380]
["06CAS","陈楠",18218172024,"周丽娟",15207499747]
["07DCS","周理鹏",18153798380,"朱文",17607310211]
["08OMS","涂珉",18874225312,"邹炜琪",18075677001]
["09GWS","周理鹏",18153798380,"朱文",17607310211]
["10APP","龚紧军",13357219776,"周丹",18676652846]
["11ELK","朱文",17607310211,"周理鹏",18153798380]
["13PayMS","邹炜琪",18075677001,"吴杰法",13677381530]
["Barley","姜希",18682305250,"陈普",13786180937]
["野草","周丹",18676652846,"陈普",13786180937]

{"sheet":"每日检查模板","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,5,1],[6,1,10,1],[11,1,18,1],[2,2,4,2]]}
[null,"每日巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"巡检聚能云平台","云平台是否正常","1、登录云平台","未检查"]
[null,null,null,"2、查看基础架构里主机栏目下挂载的主机状态是否正常","未检查"]
[null,null,null,"3、查看基础架构里证书栏目下证书是否有过期的","未检查"]
[null,null,"服务是否正常","检查应用栏目下的已经实例化的服务是否都是正常状态（绿色）","未检查"]
[null,"巡检物理主机","网络丢包及延迟情况检查","ping -t ip  检查丢包率和网络延迟情况，ping的次数必须大于10次，取平均值","未检查","网络情况："]
[null,null,"cpu及内存占用情况检查","top查看cpu及内存占用情况","未检查","CPU使用均值："]
[null,null,"物理磁盘剩余情况检查","df -m查看磁盘使用情况，使用率大于85%需要考虑扩容或者内容迁移","未检查","物理磁盘使用比例："]
[null,null,"共享磁盘挂载情况检查","往共享磁盘中写入一个文件，再重新读取出来，确认共享磁盘可用","未检查"]
[null,null,"对外端口是否正常","1、netstat -anlp | grep 端口 查看端口是否监听状态","未检查"]
[null,"业务检查","app上订单内容检查",null,"未检查"]
[null,null,"UES页面数据查询检查",null,"未检查"]
[null,null,"业务网元日志检查",null,"未检查"]
[null,null,"业务服务检查",null,"未检查"]
[null,null,"数据库状态检查","数据库连接数","未检查"]
[null,null,"mysql数据库连接数检查","数据库命令行中执行show status like 'Threads%';查看mysql连接数","未检查"]
[null,null,"mysql数据库死锁检查","数据库命令行中执行show OPEN TABLES where In_use > 0;","未检查"]
[null,null,"短信卡余额检查",null,"未检查"]

{"sheet":"每周检查内容","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,4,1],[5,1,7,1],[8,1,15,1]]}
[null,"每周巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"巡检聚能云平台","镜像仓库内容是否更新且可用","1、检查应用商店是否可用\n2、最新build的版本是否有镜像\n3、镜像是否能正常拉取并启动\n4、检查镜像仓库空间大小，定期清除废弃镜像及过期镜像","未检查"]
[null,null,"git同步检查","检查代码是否是否有同步上git","未检查"]
[null,null,"查看系统日志，检查是否有异常","cat /var/log/messages及cat /var/log/secure查看系统是否有异常报错","未检查"]
[null,"基础服务巡检","DNS解析服务是否正常","1、外部ping对外域名，是否能正常解析并跳转\n2、系统内部ping其他内部域名，是否能正常访问并跳转","未检查"]
[null,null,"redis服务是否正常","1、进入redis命令行\n2、用info命令查看redis状态信息","未检查"]
[null,null,"内容备份检查及灾难演练","1、检查每天是否有正常备份\n2、备份的文件是否能够作为依据恢复数据内容","未检查"]
[null,"数据库巡检","mysql数据库连接数检查","数据库命令行中执行show status like 'Threads%';查看mysql连接数","未检查"]
[null,null,"mysql数据库死锁检查","数据库命令行中执行show OPEN TABLES where In_use > 0;","未检查"]
[null,null,"检查定时备份的数据库备份是否成功","查看定时备份的数据库文件是否存在，且大小正常","未检查"]
[null,null,"mysql进程及对应日志检查","ps -ef|grep mysql查看mysql进程是否正常\nvi /var/log/mariadb/mariadb.log查看日志中是否有异常告警","未检查"]
[null,null,"pg数据库连接数检查","数据库命令行中执行select count(*) from pg_stat_activity;","未检查"]
[null,null,"pg数据库死锁检查","数据库命令行中执行select * from pg_stat_activity where dataname='数据库名' and waiting=true;","未检查"]
[null,null,"pg数据库备份检查","查看定时备份的数据库文件是否存在，且大小正常","未检查"]
[null,null,"pg数据库进程及对应日志检查","vi /var/log/postgres/pg_log.log","未检查"]
[null,"业务巡检","app上各页面检查",null,"未检查"]

{"sheet":"月末检查模板","index":3,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,4,1]]}
[null,"每周巡检检查模板"]
[null,"巡检范围","检查内容","检查方法","检查结果","备注"]
[null,"灾难恢复演练","mysql数据库备份恢复演练","用备份文件在测试环境中进行恢复，观察是否能够正常恢复数据","未检查"]
[null,null,"pg数据库备份恢复演练","用备份文件在测试环境中进行恢复，观察是否能够正常恢复数据","未检查"]
[null,null,"备份文件恢复演练","用备份的文件在测试环境中进行恢复，观察是否能正常运行","未检查"]