检查Oracle索引是否有效
123456789col owner for a10col table_name for a30col index_name for a30col status for a15col tablespace_name for a15set linesize 300 pagesize 300select owner, table_name, tablespace...
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970[oracle@server01:/home/oracle]$crontab -lYou (oracle) are not allo...
Mysql8.0安装Xtrabackup
一、Xtrabackup简介 Innobackupex is the symlink for xtrabackup. innobackupex still supports all features and syntax as 2.2 version did, but is now deprecated and will be ...
在遇到 MySQL 8报错 “error while loading shared libraries: libcrypto.so.3” 时，通常是因为系统找不到所需的 libcrypto.so.3 库文件，libcrypto.so.3 是 OpenSSL 3.0 中的一个库文件，MySQL 8.x 版本和一些 MariaDB 版本可能依赖这个库。
一、错误提示12[root@serve...
查看Mysql数据库占用空间大小
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576---统计各个数据库数据总量SELECT table_sche...
查询Oracle在线会话
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061set linesize 500set pagesize 500col sid for 9999999col spid for a5col...
linux find命令
1.查找3天前的文件并删除12345find . -name "*.bak" -mtime +3 |xargs rm -rffind . -name "*.bak" -mtime +3 -exec rm -rf {} \;查找3天内的文件并删除:find . -name "*.bak"...
一、RMAN删除过期备份报错123456RMAN> delete noprompt obsoleteRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RM...
Centos7.9安装达梦数据库
一、关闭防火墙123systemctl stop firewalld systemctl disable firewalldsystemctl status firewalld
二、关闭selinux12sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/s...
Tidb快照备份和Tidb日志备份脚本
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748#!/bin/bash#set envPATH=/home/tidb/.tiup/bin:$PATHDATE=`date +%Y%m%d`keep_days=7keep_bac...
