./dmrman ctlstmt="recover database '/dm8/dmrw/dm.ini' from backupset '/dm8/bakfull/'" ./dmrman ctlstmt="recover database '/dm8/dmrw/dm.ini' update db_magic" 5、配置主库 1)修改实例的dm.ini文件参数 INSTANCE_NAME = dmrw1 MAL_INI = 1 ARCH_INI = 1 ALTER_MODE_STATUS = 0 ENABLE...
install_dir="/home/kingbase/cluster/R6HA/hac7"zip_package="/home/kingbase/r6_install/db.zip"license_file=(license.dat) db_user="system"# the user name of databasedb_port="54325"# the port of database, defaults is 54321db_mode="oracle"# database mode: pg, oracledb_auth="scram-sha...
zip_package="/home/kingbase/r6_install/db.zip" license_file=(license.dat) db_user="system" db_port="54321" db_mode="oracle" db_auth="scram-sha-256" db_case_sensitive="no" db_checksums="yes" archive_mode="always" db_encoding="UTF8" db_collate="" db_ctype="" other_db_init_opti...
install_dir="/home/kingbase/cluster/HA_R6/kha"zip_package="/home/kingbase/r6_install/db.zip"license_file=(license.dat) db_user="system"# the user name of databasedb_port="54321"# the port of database, defaults is 54321db_mode="oracle"# database mode: pg, oracledb_auth="scram-sha...
修改各DB节点的archive_command配置,reload数据库实例 创建备份stanza,执行第一次全量备份 如遇异常情况,请参考章节附录C:常见异常处理 4.2.1. 在单机+外部备份场景下¶ 确保kingbase.conf中以下两项配置: archive_mode=onarchive_command 没有被注释,内容将被脚本自动修改 ...
PLAN_CACHE_MODE:控制缓存模式。 2.1 PLAN_CACHE_LEVEL 缓存级别 PLAN_CACHE_LEVEL 属于 session 级的参数,顾名思义就是在缓存的深度上进行控制,取值及作用如下表所示: 取值 作用 备注 NO_CACHE 服务器不缓存执行计划 0 级,系统默认值 CACHE 缓存执行计划 1 级 STATE_CACHE 缓存执行状态相关数据 2 级(相当于...
{ Num int `db:num` Text string `db:text` Blob []byte `db:blob` Clob string `db:clob` } func main() { connInfo := fmt.Sprintf(host=%s port=%d user=%s + password=%s dbname=%s sslmode=disable, 10 第 5 章 程序示例 host, port, user, password, dbname) db, err = sql.Open(...
backup/rmanbackup# THE PATH OF DUMP BACKUP DIRECTORYDUMP_PATH=/home/kingbase/backup/dumpbackup#BACKUP DATABASE LISTDB_LIST=kingbase,bak01,db01KEEP_TIME=7[check]# CHECK_LEVEL(MONTH OR QUARTER)CHECK_LEVEL=QUARTER# DATABASE TYPE(CLUSTER OR SINGAL)MODE=SINGAL#重置统计信息STATRESET=off[diagtool]#...
如要开启服务器的执行计划缓存功能,有如下两种方法:1)在数据库配置文件kingbase.conf中加入:PLAN_CACHE_LEVEL=CACHE2)通过客户端手动设置,如在isql中设置:TESTDB#SETPLAN_CACHE_LEVEL=CACHE;2.2PLAN_CACHE_MODE缓存模式PLAN_CACHE_MODE属于session级别的参数,KingbaseES的缓存机制采用三种模式来匹配可以重用plan的SQL...
test=# CREATE DATABASE my_db_name; CREATE DATABASE test=# \l 数据库列表 名称| 拥有者 | 字元编码 | 校对规则 | Ctype | 存取权限 ---+---+---+---+---+--- my_db_name | system | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | security | system | UTF8 | zh_CN.UTF-8 | zh_...