一、修改操作系统主机名我的电脑—属性—更改设置
二、登录SQLServer查看服务器名称
https://learn.microsoft.com/zh-cn/previous-versions/sql/sql-server-2005/ms174396(v=sql.90)https://learn.microsoft.com/zh-cn/sql/t-sql/functions/serverpr...
查看表空间爆长原因
一、查看表空间占用大小前10的数据库对象123456789101112131415161718192021222324252627282930313233---查看某个表空间占用情况:SET LINESIZE 720SET PAGESIZE 36COL OWNER FOR A16COL SEGMENT_TYPE FOR A20COL SEGMENT_NAME FOR ...
一、原始文本12345678910111213141516Table_Name----------------------F1_MDTRT_D F1_MDTRT_D F2_SETL_D F2_SETL_D F3_FEE_LIST_D F3_FEE_LIST_D E08_YKYPRK E09_YKYPCK E12_YFYPRK E13_YFYPCK E16_YP E17_WZ E18_WZ ...
一、故障描述一套Oracle11g 11.2.0.4 DG环境，主备不同步，日志无法传输到备库，主库提示错误: ORA-16191: Primary log shipping client not logged on standby
二、检查主库1.检查主库归档目录状态123456SQL> set linesize 500 pagesize 500SQL> select stat...
Oracle开启SSL安全连接
一、服务端配置证书1.创建一个自动登录的wallet12345678910111213su - oracle$ export WALLET=$ORACLE_BASE/admin/$ORACLE_SID/wallet$ mkdir $WALLET$ echo $WALLET/oracle/app/oracle/admin/dggdszyyj/wallet$ ...
Oracle rman时间点恢复脚本
1.restore database123456789101112131415161718192021222324252627282930313233343536RMAN> delete backup;RMAN> catalog start with '/oracle/rman';RMAN> run {...
目标服务器使用live cd iso加载启动并开启ssh登录: 如debian-live-8.11.0-amd64-gnome-desktop.iso
1234567891011121314151617181920cat /opt/soft/snapshot-1607336-1749019051-2025-06-03-7ee07cb130e32d1ba06dcfa79fe34a7748f...
一、确认对应实例的undo表空间1234567SQL> show parameter undoNAME TYPE VALUE------------------------------------ ----------- ------------------------------undo_management string AUTOundo_rete...
一、前期检查1.查看asmdisk12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061确认 FRA 磁盘组真实名称（避免 UI 显示的描述名混淆）SQL> select group_number, name, st...
一、RMAN备份故障
RMAN备份日志中报错：ORA-00230: operation disallowed: snapshot control file enqueue unavailable
12345RMAN-00571: ===========================================================RMAN-00569: ==========...
