ITPub博客

数据库配置文件已经安装到 D:appAdministrator,同时其他选定的安装组件也已经安装到 D:appAdministratorproduct11.2.0dbhome_1。 您需要在远程节点上执行 <Oracle Home>binselecthome.bat 以激活以下产品: Oracle Data Provider for .NET Oracle Provider for OLE DB Oracle Objects for OLE Oracle Counters for Windows Performance Monitor Oracle Administration Assistant Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:UsersAdministrator>sqlplus / as

http://technet.microsoft.com/zh-cn/library/ms189852%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms366349%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms190030%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms189977%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms189270%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms186348%28SQL.90%29.aspxhttp://technet.microsoft.com/zh-cn/library/ms179481%28SQL.90%29.aspxhttp://technet.microsoft

环境如下：主体数据库(ip: 192.168.0.11) winxp sp3 sqlserver2005 sp3 32bit , 数据库名字为cwbase2镜像数据库(ip: 192.168.0.12)win2003 sp2 sqlserver2005 sp3 32bit , 数据库名字为cwbase2不使用见证服务器，采用异步数据库镜像（高性能模式）准备工作：将主体数据库cwbase2 改为full恢复模式将镜像数据库cwbase2 改为full恢复模式将主体机器上的sqlserver 服务，sqlserver agent服务，sqlserver browser服务，改为由administrator启动，并设置为自动启动将镜像机器上的sqlserver 服务，sqlserver agent服务，sqlserver browser服务

goldengate 支持ddl的数据库类型：oracle 和teradata其他的数据库诸如sqlserver，sybase，db2，goldengate是不支持ddl复制的。metalink文章Does Oracle GoldenGate(OGG) support DDL Replication for DB2 [ID 1303729.1]说明了如下情况：OGG does not support DDL replication for DB2 database [@more@]

Is GoldenGate Compatible Between Different Releases? [ID 965423.1] 修改时间 19-MAY-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:Are my Oracle GoldenGate versions compatible?Solution Overview:Yes, Oracle GoldenGate has been designed to be bac

Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1] 修改时间 16-DEC-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle GoldenGate - Version: 10.4.0.19 and later [Release: 10.4.0 and later ]Information in this document applies to any platform. Symptoms Source: as user PRICERC1 - ALTER TABLE test RENAME TO bkup_test; Ta

V$RMAN_STATUS 视图 V$RMAN_STATUSdisplays the finished and on-going RMAN jobs. For on-going jobs, this view displays progress and status. The jobs which are in progress are stored only in memory while the finished jobs are stored in the controlfile.V$RMAN_STATUS显示已完成和正在进行的RMAN任务。对于正在进行的任务，显示 progress 和 status，这些信息仅存在于内存中。当任务结束后，信息将存在控制文件中。ColumnDatatypeDescriptionSIDNUMBERSession ID of the session which is running this RMAN operati

V$RMAN_OUTPUT 视图 V$RMAN_OUTPUTdisplays messages reported by RMAN. This is an in-memory view and is not recorded in the controlfile. The view can hold 32768 rows.V$RMAN_OUTPUT 视图记录了RMAN生成的信息，这是在内存中额视图，不会记录到控制文件上。最多有37278条记录。ColumnDatatypeDescriptionSIDNUMBERSession ID of the session which is running this RMAN operationRECIDNUMBERRecord ID of the correspondingV$RMAN_STATUSrowSTAMPNUMBERTimestamp of the correspondingV$RMAN_STATUSrowSESSION_RECIDNUMBERRe

RMAN Backup Error ORA-19588: Archived Log Recid Stamp Is No Longer Valid [ID 1189883.1] 修改时间 28-AUG-2010 类型 PROBLEM 状态 MODERATED In this Document Symptoms Changes Cause Solution References This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technic

原来的cdc版本：C:Program FilesDataMirrorTransformation Server for Microsoft SQL Server>C:WINDOWSsystem32cmd.exe /k "C:Program FilesDataMirrorTransformation Server forMicrosoft SQL Serverbindmshowversion.exe"CDC VERSION INFORMATIONProduct : IBM InfoSphere Change Data Capture for Microsoft SQL ServerVersion : 6.3.1 FP3Build : SJKRWLPY_2837FP3_14Date : 2009-9-30Time : 19:40:00SYSTEM INFORMATIONHost name : HP-201106291049Number of CPUs : 2Current date : 8月 05, 2011 (2011-08-05)然后，ib

# pwd /u01/app/oracle# du -sm *0.31 admin1.16 oraInventory1193.83 oradata3612.43 product[@more@]

OERR: ORA 1652 unable to extend temp segment by %s in tablespace %s [ID 19047.1] 修改时间 02-APR-2002 类型 REFERENCE 状态 PUBLISHED Error: ORA-1652Text: unable to extend temp segment by %s in tablespace %s------- -----------------------------------------------------------------------Cause: Failed to allocate an extent for temp segment in tablespace.Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more

ORA-1652 Error Troubleshooting [ID 793380.1] 修改时间 12-JUL-2010 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details References Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.2.0.1.0 - Release: 9.2 to 11.2Information in this document applies to any platform. Purpose This document can be used to

hpux oracle10.2.0.4 rac 下报ORA-1652 unable to extend temp segment by 128 in tablespace CARDTShpux 11.31 oracle10.2.0.4 rac ,2 nodes值得注意的是，报的是不能在CARDTS表空间中扩展temp段。。。后来查询metalink 文章， Troubleshooting ORA-1652 Errors in RAC [ID 280578.1]Troubleshooting ORA-1652 Errors in RAC [ID 280578.1] 修改时间 20-OCT-2010 类型 BULLETIN 状态 PUBLISHED PURPOSE-------To provide information on how t

ibm cdc 软件 与 oracle goldengate 是竞争对手，均为逻辑复制软件。ibm cdc软件 可以基于以下数据库：oracle/sqlserver/db2/datastage/ibm cdc软件的拓扑结构如下：在source 和target上安装 cdc软件，并建立instance（此时的cdc软件就相当于一个agent了）在第三台机器上安装access server（以下简称as） 和management console（以下简称mc），当然，as和mc 可以分别安装在各自的机器上。具体的同步配置：比如，源头是谁，目的端是谁，采用哪种同步方法等等，是在mc中配置的。 mc是图形化的界面，这一点比goldengate要好，goldengate配置时

select b.file_name "物理文件名", b.tablespace_name "表空间", b.bytes/1024/1024 "大小M", (b.bytes-sum(nvl(a.bytes,0)))/1024/1024 "已使用M", substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) "利用率" from dba_free_space a,dba_data_files b where a.file_id=b.file_id group by b.tablespace_name,b.file_name,b.bytes order by b.tablespace_name[@more@]

值得注意的是，从sqlplus中执行命令检查数据库的状态，数据库是open 的。如下：Microsoft Windows [版本 5.2.3790](C) 版权所有 1985-2003 Microsoft Corp.C:Documents and SettingsAdministrator>hostnamevm2003C:Documents and SettingsAdministrator>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 7月 31 17:57:17 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Minin

oracle 11.2.0.1 rac 修改asm磁盘组的冗余模式(redundancy mode)为normal 背景介绍： oracle 11.2.0.1 linux rac , ocr和vote file存放于名为CRS的asm磁盘组中，名为CRS的asm磁盘组是external冗余模式 现在的需求： 将ocr和vote file 存放于 normal 冗余模式的磁盘组。 进行的步骤： fdisk -l 可以看到新加的硬盘（新加的硬盘位于存储上） /dev/sddlmaa /dev/sddlmab /dev/sddlmad 这3块硬盘都是10.7g 使用 fdisk /dev/sddlmaa fdisk /dev/sddlmab fdisk /dev/sddlmad 对磁盘进行分区：第一个区5

以下转自http://msdn.microsoft.com/zh-cn/windows/hardware/gg463525.aspxWindows 和 GPT 常见问题解答更新日期：2011年4月11日本文提供 GUID 分区表 (GPT) 的常见问题解答。本文适用于以下操作系统：Windows 7Windows Server 2008Windows Server 2008 R2Windows VistaWindows Server 2003 SP1Windows Server 2003（64 位）Windows XP x64 版本页面包含以下内容： 关于 GPT Windows 磁盘支持 Windows GPT 需要的分区 Windows GPT ESP 实现 操作 GPT 磁盘及其内容关于 GPT问什么是 GPT 磁盘？ 答.GUID 分区表 (GPT) 是作为 Extensible Fi

显示procedures, packages, functions, package bodies, and triggers 和 基于非dblink的视图 的 依赖性。 DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in "ALL_DEPENDENCIES". 举例： create view GDBMZD as SELECT KCBMZD_BMBH AS GDBMZD_BMBH , KCBMZD_BMMC AS GDBMZD_BMMC, KCBMZD_JS AS GDBMZD_JS, KCB