Limitations of DRIVING_SITE Hint
Applies to:
Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.2.0.2
This problem can occur on a[……]
Author: Louis Liu
快速升级Oracle 11.2.0.2 RAC到11.2.0.3 on Windows 2008
基于windows 2008平台升级rac 11.2.0.2.0->11.2.0.3.0
OS环境windows 2008 x64 数据库环境oracle 11g rac ,version 11.2.0.2.0 64bit
SQL> conn / as sysdba
已连接。
S[……]
Scripts:curheaps.sql
[转] 11g Release 2 RMAN Backup Compression
11g Release 2 RMAN Backup Compression
Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data[……]
Physical standby ORA-01274
今天新上线的系统物理备库出现以下错误：
[oracle@db-15 ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 10.2.0.5.0 – Production on Fri Dec 16 20:37:38 2011
Copyright[……]
11G新特性 IO Calibration 评测
11G新特性 IO Calibration可以帮我们估算出存储的读写性能，在使用这个特性之前 我们需要满足一些条件：
.在linux系统中默认是不开启异步IO的
SQL> show parameter filesystemio_options
NAME TYPE V[……]
关于redhat 5.5安装10g Rac的问题总结
环境：redhat 5.5+oracle 10g rac+netapp
首先碰到DMM问题，netapp存储通过DMM软件mapping过来的设备 oracle无法识别 报如下错误：
the location /dev/mapper/ocr1 ,entered for the oracl[……]
[转] cluvfy使用说明
在安装rac之前，可以通过Oracle提供的一个工具进行cluster环境验证，这个工具叫做cluvfy（Cluster Verification Utility)。
一、CVU程序的位置
OTN下载: http://otn.oracle.com/RAC
Oracle DVD[……]
ORA-01555 on Active Physical standby and patchset issue without Central Inventory
今天在生产库解决一个ORA-01555 on Active Physical standby问题：
Applies to:
Oracle Server – Enterprise Edition – Version: 11.2.0.2.0 and later [Release: 11.2[……]
模拟一次online redo crash 的恢复
[oracle@liu dbs]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 10.2.0.1.0 – Production on Wed Dec 7 00:06:50 2011
Copyright (c) 1982, 2005, Oracle. Al[……]