ITPub博客

(Doc ID 471280.1)APPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.3 and laterInformation in this document applies to any platform.***Checked for relevance on 23-Jul-2012***SYMPTOMSYou en...

Buffer Cache概述Buffer Cache是SGA的一部分，Oracle利用Buffer Cache来管理data block，Buffer Cache的最终目的就是尽可能的减少磁盘I/O。buffer cache所能提供的功能主要包括： 通过缓存数据块，从...

latch: cache buffers chainslatch: redo writinglatch: redo copylatch: Undo Hint Latchlatch: In memory undo latchlatch: MQL Tracking Latchlatch: row cache objectslatch: shared poollatch: library cachela...

set linesize 132column name format a30column value format a25select x.ksppinm name, y.ksppstvl value, y.ksppstdf isdefault, decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE...

APPLIES TO:Oracle Server - Personal Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Server - Standard Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Server - E...

介绍Oracle数据库11g第2版引入了一个新的数据库功能：Database SmartFlash Cache。此功能可在Solaris和Oracle企业级Linux和允许客户，以增加有效的Oracle数据库缓冲区高速缓存的大小，而不到系统中添加...

The information in this article applies to: - Redhat Advanced Server 3.0- Oracle 10G CRS installationSymptoms~~~~~~~~When trying to setup ssh as specified in the 10g CRS installation guide, yo...

Oracle补丁术语介绍By JaneZhang(张建英) on 三月 13, 2013在使用Oracle的技术支持服务的时候，经常会遇到补丁相关的术语。现在对这些术语做些解释说明：Interim patch/One-off patch：是我们常说的小补丁，为...

1,ps -ef|grep crs;ps -ef|grep crs;ps -ef|grep evm2,kill -9 以上的pid3,rm相当的init进程(crs,evm,css)-Sun:rm /etc/init.d/init.cssdrm /etc/init.d/init.crsrm /etc/init.d/init.crsdrm /etc/init.d/init.evmdr...

在安装clusterware时如果出现报错现象，需要重新安装时，必须先清除已经安装的cluserware，否则可能会影响到下次安装。一般情况下，只需要在各节点上依次运行目录$ORA_CRS_HOME/install/下的脚本rootdelete.sh和root...

Linux/Uninx下Oracle的oerr工具的使用Linux/Uninx下Oracle的oerr工具的使用oerr是oracle在unix上的查找ora错误的小工具，极其方便。命令格式为：oerr ora 错误编号例如要查看ora-01632的描述：[oracle@shtdtest orac...

Introduction to VPDVirtual private database (VPD) enables you to enforce security, to a fine level of granularity, directly on tables, views, or synonyms. Because security policies are attached direct...

1  闪回区有足够空间,并且在 flashback retention target要求范围内,flashback log 将要被创建2  一旦超过flashback retention target时间要求，flashback log将要被覆盖3  闪回区已满或者磁盘...

今天有客户的数据库意外被删除了整个目录中的数据文件，操作系统级别的删除，然而幸运的是这个数据库没有崩溃，仍然处于open状态的时候，客户就发现了问题，求助到我们，最终完整地恢复了所有数据文件。在Linux下大...

Oracle-suggested backup strategy使用的就是这种方式　　增量追加备份工作原理：首先创建一个文件镜像拷贝，然后定期把从上次镜像拷贝最大SCN以来变化的数据块追加到镜像拷贝文件中。增量追加备份可以达到快速...

How to Recover From Enterprise Manager Grid Control 10g Base Releases (10.2.0.x.0) Installation Errors after 31-Dec-2010 [ID 1228103.1]To BottomModified:30-May-2013Type:BULLETINStatus:PUBLISHEDPriorit...

Issue 1:When i start installing the oem grid control after completing all the pre requesites, we got the following error. The cursor hangs there instead of populating OUI window.[oracle@dhcppc30 ~]$ c...

【转载地址】http://yangtingkun.itpub.net/post/468/279105Oracle的GLOBAL_NAME由两个部分组成：DB_NAME和DB_DOMAIN。如果在建立数据库的时候不指定DB_DOMAIN的值，则GLOBAL_NAME和DB_NAME的值一样。Oracle有一个从...

Backing Up Oracle Cluster RegistryThis section describes how to back up OCR content and use it for recovery. The first method uses automatically generated OCR copies and the second method enables...

Backing Up Voting DisksIn Oracle Clusterware 11g release 2 (11.2), you no longer have to back up the voting disk. The voting disk data is automatically backed up in OCR as part of any config...