ITPub博客

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

此视图存储的应该是Type of object: FUNCTION, JAVA SOURCE, PACKAGE, PACKAGE BODY, PROCEDURE, TRIGGER, TYPE, TYPE BODY 的定义，值得注意的是，以FUNCTION为例子，SQL> create or replace function substring 2 (vsS IN char , viS IN integer , viL IN integer ) 3 RETURN char 4 IS 5 BEGIN 6 RETURN(substr(vsS,viS,viL)) ; 7 END; 8 /这是一个有8行的FUNCTION，执行此FUNCTION后，在DBA_SOURCE中去查询此FUNCTION，结果有9行。呵呵。不知道为啥会多一行。[@more@]

GPT (GUID Partition Table) 大 | 中 | 小 [ 2009/03/29 13:26 | by askwan ] Linux早可以支持大于2T的块设备（Large Block Device），但是分区的时候却不能用常见的fdisk工具了，一定要用的话，会有下面的警告信息： 引用 [root@host2001 data]# fdisk -lDisk /dev/sda: 500.1 GB, 500107862016 bytes255 heads, 63 sectors/track, 60801 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sda1 * 1 33 265041

http://blogold.chinaunix.net/u/31219/showart_1895925.html我们来看一下两种分区表MBR分区表：（MBR含义：主引导记录）所支持的最大卷：2T （T; terabytes,1TB=1024GB）对分区的设限：最多4个主分区或3个主分区加一个扩展分区（扩展分区中支持无限制的逻辑驱动器）GPT分区表：（GPT含义：GUID分区表）支持最大卷：18EB，（E：exabytes,1EB=1024TB）每个磁盘最多支持128个分区假设要用parted对/dev/sdb（大小为6000G）进行分区操作：1、进入系统执行：#parted /dev/sdb2、建立磁盘label：mklabel GPT3、按p键，查看磁盘可用空间，显示单位

How to configure USE_SHARED_SOCKET on Windows NT/2000 [ID 124140.1] 修改时间 13-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Net Services - Version: 8.0.6.3.0 to 11.2.0.2 - Release: 8.0.6 to 11.2Generic Windows Purpose The Oracle Net or Net8 connection to an Oracle Database running on Windows NT, Windows 2000, or later operating system may redirect the Client to connect to a port number selected fro

Port 1521 Open on Firewall But Unable to Connect Due to Errors: ORA-12535,TNS-12203 [ID 361284.1] 修改时间 08-OCT-2008 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Oracle dedicated databases on Windows platforms Oracle shared-mode databases Oracle 10g direct handoff feature on Windows platforms Oracle RAC clusters Solution References Applies to:

Solving Firewall Problems on Windows [ID 68652.1] 修改时间 13-APR-2011 类型 BULLETIN 状态 PUBLISHED Applies to: Oracle Net Services - Version: 2.3.4.0.0 to 11.2.0.2 - Release: to 11.2Generic Windows ORA-12535 TNS-12535 USE_SHARED_SOCKET Purpose This article describes how to get around firewall problems with SQL*Net or Net*8 on Windows servers. Scope and Application SCOPE & APPLICATIONA firewall is a s