ITPub博客

HP-UX系统日志文件 2008/11/28 19:38 文件名－－－－－－－－－文件内容－－－－－－－－－－－－－－监测方法 /etc/rc.log －－－－－－启动日志－－－－－－－－－－－－－－用读取文本文件的方法， /var/adm/syslog/syslog.log 一般系统日志（包括客户端的访问记录）－－－－－－ /var/adm/sw/*.log －－－－软件安装日志－－－－－－－－－－分析发生的相关问题。 /var/adm/wtmp（wtmps）－用户登录信息－－－－－－－－－－用last 命令查看（清空：>wtmp） /var/adm/btmp（btmps）－－用户登录失败信息－－

you are trying to manipulate a job in the job queue (DBA_JOBS/USER_JOBS) and you receive: ORA-08102: index key not found, object... Cause: Internal error: possible inconsistency in index Action: Send trace file to your customer support representative, along with information on reproducing the error Example: SQL> execute dbms_job.remove(1); ORA-08102: index key not found, object #124 ->>> SYS.I_JOB_NEXT where object #124 is the object# in DBA_OB

replicat screpsetenv ( NLS_LANG = " SIMPLIFIED CHINESE_CHINA.ZHS16GBK " )assumetargetdefsDBOPTIONS DEFERREFCONSTgettruncatesapplynoopupdatesuserid goldengate, password oracleddl include objname "scott.*" &INCLUDE OBJTYPE 'USER'ddlerror 600, ignorediscardfile ./dirrpt/scrini.dsc, append, megabytes 500map scott.*, target scott2.*;[@more@]

Checked for relevance on 14-May-2009" PURPOSE ------- To further document a known DataPump restriction. SCOPE & APPLICATION ------------------- This applies to Database Administrators who have traditionally used UNIX named pipes with the original Export and Import to 'compress', 'gzip' or 'split' Export dump files. DATAPUMP EXPORT/IMPORT DOES NOT WORK WITH UNIX NAMED PIPES ---------------------------------------------------------- EXPLANATION -----------

修改时间 20-JUL-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2Information in this document applies to any platform. Goal With the old EXPORT utility you can execute the export using exp command with gzip program as below: mknod /u01/backup/exp/export_pipe p nohup /usr/bin/gzip < /u01/backup/exp/export_pipe

修改时间 17-APR-2009 类型 BULLETIN 状态 PUBLISHED PURPOSE The basic function of the export utility is to extract the objects of a database and locate them in a flat file that is usually on tape or on disk. The process for exporting to tape is explained in this bulletin. SCOPE & APPLICATION Informative SEARCH WORDS 2 gig limit This bulletin examines several considerations and steps for exporting data to tape on unix platforms eith

2011-09-14 09:25:06 WARNING OGG-00869 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.Using following columns in default map by name: ENAME, JOB, SAL, COMMUsing the following key columns for target table SCOTT2.BONUS: ENAME, JOB, SAL, COMM.[@more@]

以下语句（scott.bonus表无主键无唯一索引）若是在gg源端发出，会导致gg目的端abend(除非目的端复制进程参数文件有APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES 参数) update scott.bonus set ename='lei2' where ename='lei2'; gg目的端abend时，dirrpt下的rpt文件报错如下：2011-09-14 09:35:23 ERROR OGG-01168 Encountered an update for target table SCOTT2.BONUS, which has no unique key defined. KEYCOLS can be used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target data

C:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on 星期二 9月 13 22:55:50 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select supplemental_log_data_min from v$database;SUPPLEME--------NO注意：是no的话，会导致logminer工具无法捕捉dml操作。。。[@more@]

/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-the

What Are The Considerations In Using "Batchsql"? [ID 1060546.1] 修改时间 04-APR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue: BatchSQL Implemantation and Limitations: Solution Overview: BATCHSQL is a Replicat parameter implementi

Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Oracle 10g introduced new flashback ability at several levels: database, dropped table, and committed transaction.Goldengate supports the flashback of committed transactions, but does not support flashback at the database or dropped table levels.Supportedflashback table ... to SCN ... flashback table ... to TIMESTAMP ...flashback tabl

Excessive REPLICAT LAG Times [ID 962592.1] 修改时间 01-MAR-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution Applies to: Oracle GoldenGate - Version: 10.4.0.20 and later [Release: 10.4.0 and later ]Information in this document applies to any platform. Symptoms REPLICAT lag times often exceed 30 minutes; is there a way to improve REPLICAT performance/throughput? Cause CauseIn

In 11.2,不允许建立超过2tb的asm磁盘组，exadata在打相关补丁的情况下，可以建立超过2tb的磁盘组in this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.0. to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform. ASM instance Goal Trying to add a 2 TB disk to an ASM diskgroup Solution In 11.2 a check was made to disallow creation of diskgroups with disks of size > 2tb. This should not apply to EXADATA mach

backport　　Backport是将一个软件的补丁应用到比此补丁所对应的版本更老的版本的行为。这是软件开发过程中维护步骤的一部分。最简单也可能是最常见的例子，就是针对某个软件的某个漏洞的补丁。某个软件的新版本发现了漏洞，通过修补源代码后可以修复；但此软件的旧版本因为源代码不同，而不能通过同样的修补来修复，这时就需要针对旧版本的软件来进行源代码修补了。　　针对软件的某个方面所做的改动，可能简单到修改几行代码，也可能复杂到需要修改大量的源代码文件。如果改动很复杂，那么backport行为就会很不值得，除非旧版本的软件比

How to find RAC certifications in MOS Certification Tab [ID 1053954.1][@more@]

Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 and later [Release: 9.2 and later ]IBM AIX on POWER Systems (64-bit) Goal How does OUI check if the HACMP software is installed? Solution In 9i, when installing base release, e.g. 9.2.0.1, the OUI checks if cluster HACMP is available by looking at /etc/objrepos/HACMPnode. statx("/etc/objrepos/HACMPnode", 0x2FF212B8, 76, 0) = 0 If this file is present then it will look at the cluster by running

Only certain versions of HACMP are certified with any given Oracle RDBMS, and you want to determine the version of HACMP installed for certification purposes.Solution Description: ===================== You need to use the AIX command: lslpp -h "cluster*" This will display the HACMP installation and update information, along with the version number. Solution Explanation: ===================== The lslpp command lists installed filesets (packages), and

goldengate rep进程abend 遇到 discard file (./dirrpt/rini.dsc) exceeded max bytes (705032704)rep进程的参数文件是这样写的：discardfile ./dirrpt/rini.dsc, append, megabytes 5000解决方法：在dirrpt目录下执行：mv rini.dsc rini.dscbak问题分析：discard file是辅助你定位问题的文件，说白了，作用类似于oracle数据库的alert日志文件。可以重命名。[@more@]

1.一定要从metalink上开个sr，索要相应操作系统下的相应数据库的最新的goldengate软件。别用老的goldengate软件。老的goldengate软件存在很多bug（比如，goldengate v11.1.1.0.1软件对oracle进行ddl复制时，对 oracle 的rename这个ddl操作，会忽略掉，这是个很严重的bug，此bug有metalink文章Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1]）2.goldengate v11.1.1.0.29 for hpux 11.31 oracle 10.2.0.4 rac 的目的端（只有1个replicat进程） 应用速度记录：1分钟大概会应用43M的trail文件（每个trail文件