<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[initialize1306的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/initialize1306</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; initialize1306]]></copyright><item><title><![CDATA[Oracle数据库 binary XML data类型同步]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/163444365</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/163444365</guid><author>initialize1306</author><pubDate>Mon, 03 Aug 2026 15:45:39 +0800</pubDate><description><![CDATA[源端：Oracle19.22目标端：postgresql14（Oracle兼容）]]></description><category></category></item><item><title><![CDATA[Postgresql（Oracle兼容） 到Oracle19.9字符语义]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/161799306</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/161799306</guid><author>initialize1306</author><pubDate>Mon, 08 Jun 2026 14:15:02 +0800</pubDate><description><![CDATA[Postgresql（Oracle兼容）与 Oracle 数据库在处理字符类型字段（ / ）时，长度语义（字符 vs 字节） 的差异，以及客户端字符集环境（）对 Oracle 插入操作的影响。项目源端（postgresql）目标端（Oracle）数据库版本Oracle 19c Standard Edition 2 (19.9.0.0.0)字符集UTF-8AL32UTF8默认长度语义nls_length_semantics = char（按字符）nls_length_semantics = byte（按字节，]]></description><category></category></item><item><title><![CDATA[Oracle12c CDB数据库管理表空间]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/158419790</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/158419790</guid><author>initialize1306</author><pubDate>Thu, 26 Feb 2026 10:44:01 +0800</pubDate><description><![CDATA[- 切入到PDB 数据库。6、连接数据库、创建表。]]></description><category></category></item><item><title><![CDATA[Oracle 12c测试环境快速搭建docker]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/158386703</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/158386703</guid><author>initialize1306</author><pubDate>Wed, 25 Feb 2026 16:47:01 +0800</pubDate><description><![CDATA[可能是该镜像自定义的环境变量，用于允许远程连接 Oracle 数据库。# （标识符的长度支持 30 以上了，且最大为 128 个字符）#（坑：表、字段、索引名、视图名命名长度不能超过 30 ）宿主机上的目录路径（需要提前创建）：容器内的目录路径。：挂载一个宿主机目录到容器内部，用于数据持久化。后，容器会调整监听配置，允许非本地主机连接。：指定要使用的 Docker 镜像。：将容器的端口映射到宿主机的端口。：为容器指定一个名称（此处为。宿主机端口：容器内端口。：设置容器内的环境变量。：定义容器的重启策略。]]></description><category></category></item><item><title><![CDATA[Oracle19C-java.sql.SQLException: ORA-28001: the password has expired ]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157973869</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157973869</guid><author>initialize1306</author><pubDate>Wed, 11 Feb 2026 14:17:42 +0800</pubDate><description><![CDATA[连接数据库提示 ORA-28001: the password has expired。]]></description><category></category></item><item><title><![CDATA[postgresql12.7-执行快速比较采样SQL时，出现了“tablesample method BERNOULLI does not exist”]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157901909</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157901909</guid><author>initialize1306</author><pubDate>Mon, 09 Feb 2026 13:06:13 +0800</pubDate><description><![CDATA[瀚高安全版数据库系统V4.5.7, aarch64平台, 创建日期:20250918。]]></description><category></category></item><item><title><![CDATA[达梦V8日志管理、分析]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157799861</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157799861</guid><author>initialize1306</author><pubDate>Fri, 06 Feb 2026 09:32:50 +0800</pubDate><description><![CDATA[ARCH_TYPE = LOCAL         #归档类型ARCH_DEST = /opt/dmdbms/arch    #归档路径ARCH_FILE_SIZE = 1024       #单个归档文件大小，单位MB，取值范围（64~2048），默认为1024MB，即1GARCH_SPACE_LIMIT = 4096        #归档文件空间限制,#单位M,0 :无限制,范围 1024~4294967294M---记录注意---3)开启归档模式。在服务器打开状态下，可以添加新的重做日志文件。]]></description><category></category></item><item><title><![CDATA[RocketMQ命令使用]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157542948</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157542948</guid><author>initialize1306</author><pubDate>Fri, 30 Jan 2026 10:11:08 +0800</pubDate><description><![CDATA[-打印消息./bin/mqadmin printMsg -t rocketmq_tab_1 -n 192.168.0.160:9876。--代理启动nohup sh bin/mqbroker -n localhost:9876 --enable-proxy &--停止sh ./bin/mqshutdown brokersh ./bin/mqshutdown namesrv。--启动nohup ./bin/mqnamesrv &nohup ./bin/mqbroker &获取topic的cluster。]]></description><category></category></item><item><title><![CDATA[编译安装postgresql]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157504439</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157504439</guid><author>initialize1306</author><pubDate>Thu, 29 Jan 2026 10:20:09 +0800</pubDate><description><![CDATA[修改参数 vi  /postgresql/pgdata/postgresql.conf 在文件最后加入就行。修改参数 vi /postgresql/pgdata/pg_hba.conf。生效source  ~/.bash_profile。vi /etc/rc.local最后添加如下代码。生效 sysctl -p。登录pg设置登录账号。]]></description><category></category></item><item><title><![CDATA[oracle11g dataguard部署]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157426761</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157426761</guid><author>initialize1306</author><pubDate>Tue, 27 Jan 2026 09:54:42 +0800</pubDate><description><![CDATA[alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(【主库实例名】,【备库实例名】)';scp ORACLE_HOME/dbs/orapworcl 备库ip:$ORACLE_HOME/dbs/orapworcldg。(ADDRESS = (PROTOCOL = TCP)(HOST = 【备库ip】 )(PORT = 1521))scp /home/oracle/pfile.ora 备库ip:/home/oracle/(SID_NAME = 【备端实例名】)]]></description><category></category></item><item><title><![CDATA[MySQL日志管理]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157387076</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157387076</guid><author>initialize1306</author><pubDate>Mon, 26 Jan 2026 09:59:55 +0800</pubDate><description><![CDATA[server-id         = 223344log_bin           = mysql-binbinlog_format     = ROWbinlog_row_image  = FULLexpire_logs_days  = 10##希望删除这个参数，如果有实施人员在客户主库配置日志过期时间是10天，造成二进制日志丢失。此阶段InnoDB会写事务的redo log，但要注意的是，此时redo log只是记录了事务的所有操作日志，并没有记录提交（commit）日志。]]></description><category></category></item><item><title><![CDATA[MySQL半同步复制配置]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157292401</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157292401</guid><author>initialize1306</author><pubDate>Fri, 23 Jan 2026 14:32:27 +0800</pubDate><description><![CDATA[1、IO线程，获取到主库binlog日志转存到备库realylog日志2、SQL线程读取relay-log.info文件，获取到上次执行到的relay-log的位置，作为起点，回放relay-log然后写到从数据库。1、数据库系统在写完一个事务的binlog时发生宕机，而此时这个事务的redo log还没有持久化，或者说此事务的redo log还没记录完（至少没有记录commit log）。2、在数据库恢复后，主库会根据redo log中去完成此事务的重做，主库中就有这个事务的数据。3.4.1、主库执行。]]></description><category></category></item><item><title><![CDATA[mysql双主+keepalived做虚拟ip]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157255035</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157255035</guid><author>initialize1306</author><pubDate>Thu, 22 Jan 2026 15:27:53 +0800</pubDate><description><![CDATA[创建复制账号grant replication slave,replication client on *.* to repl@'192.168.0.%' identified by '123456';]]></description><category></category></item><item><title><![CDATA[Windows环境-定时计划任务-清理Oracle归档]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157176183</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157176183</guid><author>initialize1306</author><pubDate>Tue, 20 Jan 2026 14:13:44 +0800</pubDate><description><![CDATA[功能: 删除过期的归档日志记录    只删除RMAN资料库中标记为"EXPIRED"的记录    不会删除物理文件（因为文件已经不存在了）    清理RMAN资料库，保持其与实际文件状态一致操作对象: RMAN资料库中的元数据记录5天前的归档日志（文件存在）3天前的归档日志（文件已被手动删除）    删除RMAN中3天前的EXPIRED记录    不删除任何物理文件。del_archivelog.txt文件，SYSDATE-7表示删除七天前归档日志。del_archivelog.bat脚本。]]></description><category></category></item><item><title><![CDATA[Oracle11G-impdp+dblink]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/102512144</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/102512144</guid><author>initialize1306</author><pubDate>Tue, 20 Jan 2026 13:26:48 +0800</pubDate><description><![CDATA[切换到ORACDC用户create public database link BDCDJ_DBLINK connect to 【被链接库的用户名】 identified by 【被链接库的密码】 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 源库ip)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';目标库：192.168.0.108 SID=orcl。]]></description><category></category></item><item><title><![CDATA[Oracle11g-awr报告导出]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/137016736</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/137016736</guid><author>initialize1306</author><pubDate>Mon, 19 Jan 2026 15:19:19 +0800</pubDate><description><![CDATA[Oracle awr报告]]></description><category></category></item><item><title><![CDATA[Oracle11g表结构覆盖+python压测脚本]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/144702714</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/144702714</guid><author>initialize1306</author><pubDate>Mon, 19 Jan 2026 09:35:12 +0800</pubDate><description><![CDATA[【代码】Oracle11g表结构覆盖+python压测脚本。]]></description><category></category></item><item><title><![CDATA[Oracle11G-dumpfile REDO RECORD]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/157020720</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/157020720</guid><author>initialize1306</author><pubDate>Fri, 16 Jan 2026 10:12:23 +0800</pubDate><description><![CDATA[dumpfile REDO RECORD]]></description><category></category></item><item><title><![CDATA[Oracle11g logminer日志挖掘步骤]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/156980703</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/156980703</guid><author>initialize1306</author><pubDate>Thu, 15 Jan 2026 10:39:13 +0800</pubDate><description><![CDATA[oracle 数据库增补：SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;列增补：SQL> alter database add supplemental log data (ALL) columns;通过scn找到要分析的归档select sequence#,name,first_change#,next_change#,blocks,block_size from v$archived_log where first_change#<=4718501 and ]]></description><category></category></item><item><title><![CDATA[mysql5.7二进制安装]]></title><link>https://blog.youkuaiyun.com/initialize1306/article/details/122662376</link><guid>https://blog.youkuaiyun.com/initialize1306/article/details/122662376</guid><author>initialize1306</author><pubDate>Mon, 24 Jan 2022 11:17:20 +0800</pubDate><description><![CDATA[skip-character-set-client-handshake                                     #忽略应用程序想要设置的其他字符集。replicate-ignore-db = mysql                                             #忽略不同步主从的数据库。sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES                     #sql模式。]]></description><category></category></item></channel></rss>