随笔分类 - 达梦
摘要:环境:OS:Centos 7DM:DMV8 达梦分布计算集群英文全称 DM Distributed Processing Cluster,简称 DMDPC.计划生成节点,英文全称为 SQL Processor,简称为SP;数据存储节点,英文全称为 Backend Processor,简称为BP;元数
阅读全文
摘要:环境:OS:Centos 7DB:DMV8单机实例名:HXLDSC实例名:SLNNGK 1.单机备份 disql SYSDBA/SYSDBA SQL>backup database full backupset '/dmdbms/backup/single_fullbak_20240411'; SQ
阅读全文
摘要:环境:OS:Centos 7DB:DMV8 1.dsc备份在其中一个节点上备份数据和归档日志disql SYSDBA/SYSDBAbackup database full backupset '/dmdbms/backup/fullbak_20240411';backup archivelog al
阅读全文
摘要:1.修改参数文件 [dmdba@localhost gproj]$ more sqllog.ini BUF_TOTAL_SIZE = 10240 #SQLs Log Buffer Total Size(K)(1024~1024000) BUF_SIZE = 1024 #SQLs Log Buffer
阅读全文
摘要:环境:OS:Centos 7DB:DMV8 在需要解除主从关系的数据库服务器上操作 1.停掉dmwatcher并删除服务[root@host02 root]# systemctl stop DmWatcherServiceGRP1[root@host02 root]# cd /dmdbms/prod
阅读全文
摘要:环境:OS:Centos 7DB:V8 1.手工执行监控器 [dmdba@host02 DAMENG]$ dmmonitor /dmdbms/data/DAMENG/dmmonitor.ini login username:sysdba password: [monitor] 2024-03-25
阅读全文
摘要:环境:OS:Centos 7DB:DM8 1.模拟数据写入 [dmdba@host01 ~]$ disql hxl/dameng123 Server[LOCALHOST:5236]:mode is normal, state is open login used time : 3.718(ms) d
阅读全文
摘要:环境:OS:Centos 7DB:DM8 1.归档目录看不出连续性 [dmdba@host01 arch]$ ls -al total 148 drwxr-xr-x 2 dmdba dinstall 250 Mar 20 14:09 . drwxr-xr-x 7 dmdba dinstall 67
阅读全文
摘要:OS:Centos 7DB:DM8 1.全备数据库和归档日志disql sysdba/dameng123SQL>backup database full backupset '/dmdbms/bak/fullbak_20240319';SQL>backup archivelog all delete
阅读全文
摘要:环境: Os:Centos 7 DB:V8 1.准备控制文件 OPTIONS ( ROWS=100000 INDEX_OPTION=2 ) load infile '/tmp/tb_test.txt' str X '0A' REPLACE into table "hxl"."tb_test" fie
阅读全文
摘要:环境:OS:Windows 10python:3.6.5DM:DM8 1.windows下安装达梦客户端 2.安装dmPython C:\dmdbms\drivers\python\dmPython>python setup.py install running install running bd
阅读全文
摘要:CREATE OR REPLACE PROCEDURE "HNJKUSR"."SP_INSERT_DATA"AS /*变量说明部分*/ i INT; runsql varchar2(32); l_cnt number;BEGIN /*执行体*/ i:=1; runsql='select count(
阅读全文
摘要:环境: OS:Centos 7 DB:DM8 主库: 192.168.1.136恢复库:192.168.1.134 1.在主库上进行备份(全备份+归档日志备份) [dmdba@localhost script]$ more full_backckup.sh #! /bin/bash . /etc/p
阅读全文
摘要:例子1; set echo off; set feed off; SET FEEDBACK OFF; SET HEADING off; set pages 5000; SET TIMING OFF; SET NEWPAGE NONE; SET LINESHOW OFF; SET TIME OFF;
阅读全文
摘要:方法1:使用\转义反引号`[dmdba@localhost arch]$ disql hnjkusr/dameng123 \`/tmp/1.sql 方法2:反引号SQL> `/tmp/1.sql 方法3:SQL> start /tmp/1.sql #!/bin/bash disql SYSDBA/S
阅读全文
摘要:环境: OS:Centos 7 DB:DM8 说明: SQL模式的备份可以联机 dmrman模式的备份必须是脱机 1.备份归档日志并删除 SQL> backup archivelog all delete input to "archbak_20220811" backupset '/dmdbms/
阅读全文
摘要:1.修改配置参数dmarch.iniARCH_SPACE_LIMITARCH_SPACE_LIMIT:Redo日志归档空间限制,当同一节点的本地归档文件或远程归档文件达到限制值时,系统自动删除最早生成的归档日志文件.0表示无空间限制,取值范围(1024M~2147483647M),对本地归档和远程归
阅读全文
摘要:环境:OS:Centos 7DB:DM8主库:192.168.1.134 dbname:slnngk instance_name:slnngk01备库1:192.168.1.135 dbname:slnngk instance_name:slnngk02备库2:192.168.1.85 dbname
阅读全文
摘要:dm.ini中设置参数alter_table_opt各值的测试情况 执行的语句 alter table HXL.TB_OBJECTS add column(NAME varchar(30) default 'AA' not null); ALTER_TABLE_OPT=1 [执行语句1]: alte
阅读全文
摘要:1.创建存储过程 create table tb_objects as select * from dba_objects; CREATE OR REPLACE PROCEDURE "HXL"."sp_insert_data" AUTHID DEFINER AS /*变量说明部分*/ VARNAME
阅读全文