sundb数据库（sundb数据库怎么用）

科技前沿 • 2025-04-18 11:31 • 阅读 43

大家好，我是讯享网，很高兴认识大家。

单机部署

服务器信息及软件版本：

讯享网

（以下均为使用默认参数新建的实例操作）

#对比1.2.1.2参数情况
select archivelog_mode from v$archivelog;<br>select property_name ,property_value from v$property where property_name in (‘SUPPLEMENTAL_LOG_DATA_PRIMARY_KEY’,‘CLUSTER_ASYNC_COMMIT’,‘ARCHIVELOG_MODE’,‘DATA_STORE_MODE’);

如修改则增加或修改以下属性，修改后需重启sundb（重启时注意是否开启归档，参考1.2.1.3）：
SUPPLEMENTAL_LOG_DATA_PRIMARY_KEY = YES
CLUSTER_ASYNC_COMMIT = NO
ARCHIVELOG_MODE = 1
DATA_STORE_MODE = 2

（需重启sundb，集群需mount后open { local | global } database）
shutdown abort
startup mount
alter database archivelog;
alter system open database;

create user cdc identified by cdc;
grant create session on database to cdc;
grant create object on tablespace mem_data_tbs to cdc;
grant create object on tablespace mem_temp_tbs to cdc;
grant create object on tablespace mem_undo_tbs to cdc;
grant control schema on schema cdc to cdc;
commit;

create user cdc01 identified by cdc01 without schema;
grant create session on database to cdc01;
grant select table on schema cdc to cdc01;
commit;
select username,user_id,account_status,default_tablespace,temporary_tablespace,index_tablespace,created from dba_users;

create table cdc.t1(col1 native_bigint primary key,col2 varchar(20));
create table cdc.t2(col1 native_bigint primary key,col2 varchar(20));
commit;

(开启附加日志配置后建的表，可忽略此操作)
ALTER TABLE cdc.t1 ADD SUPPLEMENTAL LOG DATA ( PRIMARY KEY ) COLUMNS;
ALTER TABLE cdc.t2 ADD SUPPLEMENTAL LOG DATA ( PRIMARY KEY ) COLUMNS;

select tablespace_name,table_schema||’.’||table_name as table_name,ceil(blocks*⁸¹⁹²⁄) || ’ MB’ as table_size from all_all_tables where table_schema not in (‘DEFINITION_SCHEMA’,‘DICTIONARY_SCHEMA’) order by table_name;

cat ${SUNDB_DATA}/conf/cyfile.conf

讯享网

cyfile –start #开启所有cyfile
cyfile –start –group g1 #开启g1的cyfile
cyfile –start –reset { all | table1,table2 } #开启并重置cyfile

connect cdc cdc
insert into cdc.t1(col1,col2) values (11,‘test1’),(12,‘test2’),(13,‘test3’);
insert into cdc.t2(col1,col2) values (21,‘test1’),(22,‘test2’),(23,‘test3’);

tail -200f /home/sundb01/dat/cyfile.G1_1.dat

insert into cdc.t1(col1,col2) values (14,‘test4’),(15,‘test5’),(16,‘test6’);

tail -200f /home/sundb01/dat/cyfile.G1_1.dat

sundb数据库（sundb数据库怎么用）

相关推荐