Maclean’s Oracle Database Tech Blog Archives

大致看了下mysql 的double write buffer概念 ： So why doublewrite is needed ? It is needed to archive data safety in case of partial page writes. Innodb does not log full pages to the log files, but uses what is called “physiological” logging which means log records contain page number for the operation as well as operation data…

目前 （2019年5月21日)似乎MOS上找不到 控制19c Automatic Indexing 自动建索引特性的Notes，大致可以通过 _optimizer_auto_index_allow 和 _optimizer_use_auto_indexes 2个参数关闭该新特性。 col name format a40 SELECT x.ksppinm NAME, y.ksppstvl VALUE FROM SYS.x$ksppi x, SYS.x$ksppcv y WHERE x.inst_id = USERENV (‘Instance’) AND y.inst_id = USERENV (‘Instance’) AND x.indx = y.indx AND x.ksppinm LIKE ‘%index%’; NAME VALUE ————————————————– ———————————————————— _optimizer_auto_index_allow AUTO _gc_defer_ping_index_only TRUE _kcl_index_split TRUE _gc_fast_index_split_wait 0 _index_partition_large_extents…

https://github.com/macleanliu/ora-easy-deploy     ora-easy-deploy WORKS ON (CENTOS REDHAT ORACLE) LINUX 7 国外主机 su – root yum -y install git git clone https://github.com/macleanliu/ora-easy-deploy wget https://www.dropbox.com/s/8097ds292gabpk9/oracle-database-ee-19c-1.0-1.x86_64.rpm wget https://www.dropbox.com/s/x14jlgnj062nef2/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm bash ora-easy-deploy/create_db.sh 国内主机 wget –no-check-certificate https://zcdn.askmac.cn/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm wget –no-check-certificate https://zcdn.askmac.cn/oracle-database-ee-19c-1.0-1.x86_64.rpm su – root yum -y install git git clone https://github.com/macleanliu/ora-easy-deploy yum -y localinstall…

  11g ocm 相关博文：   数据库恢复的配置 https://www.askmac.cn/archives/11g-ocm-student-guide-backup-restore.html 配置备份的规范 https://www.askmac.cn/archives/dbdao-11g-oracle-ocm-2.html 使用RMAN创建备份 https://www.askmac.cn/archives/oracle-11g-ocm-rman.html 使用RMAN执行恢复 https://www.askmac.cn/archives/oracle-11g-ocm-master-rman-restore.html SPA https://www.askmac.cn/archives/oracle-11g-ocm-spa.html SQL执行计划管理 https://www.askmac.cn/archives/oracle-11g-ocm-spm.html grid control 架构 https://www.askmac.cn/archives/oracle-11g-ocm-grid-control-architecture.html grid control 安装 https://www.askmac.cn/archives/oracle-11g-ocm-grid-control-install.html 配置EMGC https://www.askmac.cn/archives/oracle-11g-ocm-setemgc.html Oracle Data Guard 介绍 https://www.askmac.cn/archives/oracle-11g-ocm-dg.html 使用SQL和RMAN命令来创建一个物理备库 https://www.askmac.cn/archives/oracle-11g-ocm-create-dg.html oracle Data Guard Broker：概述 https://www.askmac.cn/archives/oracle-data-guard-broker.html 配置 DataGuard 保护模式 https://www.askmac.cn/archives/oracle-11g-ocm-data-mode.html grid 安装 https://www.askmac.cn/archives/oracle-11g-install-grid.html 管理Oracle 集群 https://www.askmac.cn/archives/oracle-11g-ocm-manage-clusterware.html RAC数据库安装 https://www.askmac.cn/archives/oracle-11g-ocm-rac-install.html 数据库安全与审计 https://www.askmac.cn/archives/oracle-11g-ocm-audit.html 物化视图和分区表 https://www.askmac.cn/archives/oracle-11g-ocm-materializedview.html…

11g ocm 系列视频课程 ocm考试介绍1   https://zcdn.askmac.cn/ocm_2.mp4   第二讲：sql性能相关考点脚本   https://zcdn.askmac.cn/zhaowei-ocm-2.mp4     DG考点介绍   https://zcdn.askmac.cn/dbdao.com%2011g%20ocm_l4_DataGuard.mp4     DataGuard_理论部分   https://zcdn.askmac.cn/dbdao_11gocm_DataGuard_%E7%90%86%E8%AE%BA%E9%83%A8%E5%88%86.mp4     11g ocm rac   https://zcdn.askmac.cn/dbdao.com-11g-ocm-rac1.mp4   https://zcdn.askmac.cn/dbdao.com-11g-ocm-rac2.mp4   https://zcdn.askmac.cn/dbdao.com-11g-ocm-rac3.mp4   Data Warehouse数据仓库部分   https://zcdn.askmac.cn/dbdao.com_oracle_11g_ocm_%E8%80%83%E8%AF%95%E8%80%83%E7%82%B9%E4%BB%8B%E7%BB%8D%20Data%20Warehouse%E6%95%B0%E6%8D%AE%E4%BB%93%E5%BA%93%E9%83%A8%E5%88%86.mp4   数据库审计与安全部分   https://zcdn.askmac.cn/audit.mp4   SPA SQL Performance Analyzer   https://zcdn.askmac.cn/dbdao.com%20oracle%2011g%20ocm%E8%80%83%E8%AF%95%E6%8C%87%E5%8D%97%E7%AC%AC%E5%8D%81%E8%AE%B2%20SPA%20SQL%20Performance%20Analyzer.mp4   11gocm_理论_2（备份恢复）   https://zcdn.askmac.cn/dbdao_11gocm_%E7%90%86%E8%AE%BA_2%EF%BC%88%E5%A4%87%E4%BB%BD%E6%81%A2%E5%A4%8D%EF%BC%89.mp4     oracle 11g…

APPLIES TO: Oracle Database – Enterprise Edition – Version 18.0.0.0 [Release 18.0] Information in this document applies to any platform. Bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision This document lists the non-security bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision(RU/RUR). The information is specific to Oracle Cloud and…

APPLIES TO: Oracle Database – Enterprise Edition – Version 18.0.0.0 to 18.0.0.0[Release 18.0] Information in this document applies to any platform. Bugs fixed in each 18.0.0.0.0 Grid Infrastructure Release Update See Note:854428.1 for information about Patch Set Updates See Note:1683799.1 for Support Status and Alerts affecting 12.2.0.1 releases. All GI RU are packaged with the Database RU. The GI…

prm dul恢复oracle数据库最简模式 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20database%20easiest%20way.mp4 prm dul使用数据搭桥传输Oracle表数据 http://zcdn.parnassusdata.com/prm%20dul%20databridge%20transfer%20oracle%20table.mp4 prm dul在损坏数据库使用exportddl导出建表语句、索引、存储过程、函数等代码 http://zcdn.parnassusdata.com/prm%20dul%20export%20ddl%20from%20corrupted%20oracle%20database.mp4 prm dul恢复oracle中被delete的数据 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20deleted%20rows.mp4 prm dul恢复oracle中被truncate的数据 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20truncated%20table.mp4 prm dul用户级别的数据搭桥 http://zcdn.parnassusdata.com/prm%20dul%20schema%20level%20databridge.mp4 prm dul在ASM存储情况下的最简模式 http://zcdn.parnassusdata.com/prm%20dul%20easiest%20way%20with%20ASM%20storage.mp4 prm dul恢复oracle中被drop掉的表 http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20dropped%20table.mp4 prm dul恢复oracle 12c以后可拔插数据库PDB/CDB中的数据 http://zcdn.parnassusdata.com/prm%20dul%20work%20with%20oracle%2012c%20pdb%20pluggable%20database%20container%20database.mp4 prm dul恢复被恶意加密的Oracle数据文件 http://zcdn.parnassusdata.com/prm%20dul%20recover%20malware%20ransomware%20corrupted%20oracle%20datafile.mp4 prm dul recover oracle database easiest way https://youtu.be/mU3uip66DmY prm dul databridge transfer oracle table https://youtu.be/yzvVSBnQ23g prm dul export ddl from corrupted oracle database https://youtu.be/5l2hO5k5-PQ…

oracle 19c X$MESSAGE     SQL> select description , dest from x$messages order by dest; DESCRIPTION DEST ——————————————————————————————————————– run all timeout and interrupt actions for this background KSB action for X-instance calls * KSB action for bast checking * generic shutdown background * ksim instance group membership notifier * KSB action for ksbxic() calls *…