#!/bin/bash
# daily_backup.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

DATE=$(date +%Y%m%d)
BACKUP_DIR=/ob/backup

# 创建备份目录
mkdir -p $BACKUP_DIR/$DATE

# 执行增量备份
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "ALTER SYSTEM BACKUP DATABASE fgedudb INCREMENTAL TO '$BACKUP_DIR/$DATE';"

# 检查备份是否成功
if [ $? -eq 0 ]; then
    echo "每日备份成功：$DATE"
else
    echo "每日备份失败：$DATE"
    # 发送告警
fi

#!/bin/bash
# weekly_stats.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

# 收集统计信息
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('FGEDU', ESTIMATE_PERCENT => 100, METHOD_OPT => 'FOR ALL COLUMNS SIZE AUTO');"

# 检查执行结果
if [ $? -eq 0 ]; then
    echo "统计信息收集成功"
else
    echo "统计信息收集失败"
    # 发送告警
fi

#!/bin/bash
# monthly_tablespace.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

# 检查表空间使用情况
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "SELECT tablespace_name, sum(bytes)/1024/1024/1024 as size_gb, sum(maxbytes)/1024/1024/1024 as max_size_gb FROM dba_data_files GROUP BY tablespace_name;"，更多学习教程公众号风哥教程itpux_com。

# 检查执行结果
if [ $? -eq 0 ]; then
    echo "表空间检查成功"
else
    echo "表空间检查失败"
    # 发送告警
fi

#!/bin/bash
# quarterly_check.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

echo "OceanBase系统全面检查报告"，from DB视频:www.itpux.com。
echo "检查时间：$(date)"
echo "----------------------------------------"

# 检查集群状态
echo "1. 集群状态："
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "SHOW CLUSTER STATUS;"
echo "----------------------------------------"

# 检查节点状态
echo "2. 节点状态："
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "SHOW SERVER STATUS;"
echo "----------------------------------------"

# 检查系统资源使用情况
echo "3. 系统资源使用情况："
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "SELECT stat_name, value FROM V$OB_SYSSTAT WHERE stat_name LIKE '%cpu%' OR stat_name LIKE '%memory%' ORDER BY stat_name;"
echo "----------------------------------------"

# 检查表空间使用情况
echo "4. 表空间使用情况："
obclient -h192.168.1.1 -P2881 -ufgedu -pfgedu123 -Dfgedudb -e "SELECT tablespace_name, sum(bytes)/1024/1024/1024 as size_gb, sum(maxbytes)/1024/1024/1024 as max_size_gb FROM dba_data_files GROUP BY tablespace_name;"
echo "----------------------------------------"

echo "系统全面检查完成！"