Author: mac

Goldengate单向数据复制，为了图省事没有配pump，只配了source的extract和target的replicat；实际操作发现gg对大事务的支持还是比streams好一些，streams碰上大事务就只看到SPILL MESSAGES了: /*源端配置信息*/ GGSCI (rh2.oracle.com) 1> view params mgr PORT 7809 GGSCI (rh2.oracle.com) 2> view params load1 –extract group– extract load1 –connection to database– userid ggate, password ggate –hostname and port for trail– rmthost rh3.oracle.com, mgrport 7809 –path and name for trail– rmttrail /s01/gg ddl include mapped objname sender.* table sender.*; GGSCI (rh2.oracle.com) 4> stats…

Facebook engineers have a new post on note portal as below: We’re launching a new version of Messages today that combines chat, SMS, email, and Messages into a real-time conversation. The product team spent the last year building out a robust, scalable infrastructure. As we launch the product, we wanted to share some details about…

一套HP-UX上的11.1.0.7上的系统，在使用11g自带的新特性dictionary health check(数据字典健康检查)功能时发现FILE$基表存在讹误，并且告警日志中伴随出现ORA-00600：[qksrcBuildRwo]内部错误，具体错误信息如下: RMAN> list failure; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ———- ——– ——— ————- ——- 91337 CRITICAL OPEN 30-JUN-09 SQL dictionary health check: file$ pk 202 on object FILE$ failed 91334 CRITICAL OPEN 30-JUN-09 SQL dictionary health check: file$ pk 202 on object FILE$ failed 91331 CRITICAL…

APPLIES TO: Linux OS – Version Oracle Linux 5.6 and later Linux x86-64 Linux x86 GOAL This note provides step-by-step instruction on how to recover the corrupted root filesystem. SOLUTION Booting up Oracle Linux server fails with corrupted the root filesystem: Checking all file systems. [/sbin/fsck.ext3 (1) — /] fsck.ext3 -a /dev/VolGroup00/LogVol00 /dev/VolGroup00/LogVol00 contains a…

1.- Please provide the output of the following commands from each node: srvctl config nodeapps -n <nodename> -a -g -s -l ifconfig -a cat /etc/hosts 2.- Please set debug mode for VIP resources and reproduce the problem. Please take note of the time of the test: a.- As root user, issue the command : crsctl…

复制表数据是Oracle dba和应用开发人员的日常工作之一,常见的三种复制表数据的方式是: 以INSERT ..SELECT的方式将目标数据由源表插入到源表中,以此种方法复制表上的数据时可以灵活运行SELECT语句剔除那些无用的数据；同时也可以利用append nologging和并行parallel等特性加速数据复制速度.通过使用DBLINK数据库远程连接,INSERT…SELECT方式可以在数据库间复制表数据,当然要比在本库中复制表数据效率下降一些. 使用Oracle标准的导入导出工具exp/imp或者在10g以后使用DataPump数据泵技术,此种方法可以在数据库之间复制表数据,也可以用QUERY选项指定Where条件以筛选导出数据,10g中server端模式的数据泵极大地提高了导入导出的效率. 此外我们也可以使用SQLPLUS的copy命令在本库中或者在数据库间复制表上的数据. 使用copy命令复制表数据的这种方式用的较少,我们来着重介绍一下: SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 – Production NLSRTL Version 10.2.0.4.0 – Production SQL> conn maclean/maclean Connected. SQL> create table copy_sample as select *…

构建Oracle双向流复制是一个十分复杂的过程，我写这个文档的目的是尽量有条理地列出所需做的工作，帮助DBA更有效的建设流复制环境。 1.以scott模式为复制示例，一般只要在创建数据库时选择了安装sample schema，都会存在该scott模式；至少保证源库中存在该schema，以便可以初始化到目标库中。 2.在源和目标2个数据库中创建strmadmin流管理用户，当然你也可以选用其他名字。同时在2个库中都要创建streams使用的表空间，以便让logmnr使用它:

这是一个搜索结果预留页面, Page For Search Result

Patch Set Update PSU 10.2.0.4.5 is an overlay PSU whose base PSU is 10.2.0.4.4. This patch can only be applied in an Oracle home for which PSU 10.2.0.4.4 has already been installed.

My Oracle supports现在可以使用High Contrast高对比度界面设置功能了，目前提供2种选项:Black Text on White或者White Text on Black。个人比较喜欢黑底白字这类高对比度的界面，不过感觉现在这个White Text on Black还有待微调: 登录后的Dashboard: 这次的高亮界面因该是My Oracle Support Release 5.2 Upgrade升级中客户体验改善的一部分: Prepare for My Oracle Support Release 5.2 [ID 1245514.1] What is being announced? Oracle Global Customer Support is pleased to announce that on October 29, 2010, My Oracle Support was upgraded to Release 5.2. This…