VMCD.ORG

使用dbms_rowid恢复可用数据

October 22, 2011 maintain, oracle 5 comments 恢复

最近看到同事的一个案例，觉得很有趣现在测试下：
SQL> select * from v$version;

BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod
PL/SQL Release 10.2.0.4.0 – Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0[……]

SYSAUX 表空间问题解决

October 19, 2011 maintain, oracle No comments oracle数据管理

通过awrinfo.sql 以及 v$sysaux_occupants对SYSAUX空间分析，发现OPTSTAT（历史统计信息）相关的表占用近28G，AWR相关占用空间4G多，经分析OPTSTAT的历史
统计信息系统会自动清理失败有如下原因:因为历史统计信息较多，通过DBMS_STATS.PURGE_STATS清理比较困难，因此与客户沟通后对wri$_optstat_histhead_history
和wri$_optstat_histgrm_history进行TRUNCATE后再通过DBMS_STATS.PURGE_STATS清理其它表的数据，并清理一些无效的ASH数据

一.清理S[……]

Why ASMLIB and why not?

October 19, 2011 oracle, RAC 2 comments asm

ASMLIB是一种基于Linux module，专门为Oracle Automatic Storage Management特性设计的内核支持库
(kernel support library)。
长久以来我们对ASMLIB的认识并不全面，这里我们来具体了解一下使用ASMLIB的优缺点。

理论上我们可以从ASMLIB API中得到的以下益处:

总是使用direct,async IO
1.解决了永久性设备名的问题，即便在重启后设备名已经改变的情况下
2.解决了文件权限、拥有者的问题
3.减少了I/O期间从用户模式到内核模式的上下文切换，从而可能降低cpu使用率
4.减少了[……]

NBU 异机恢复测试

October 19, 2011 backup 8 comments NBU测试

一、搭建恢复测试环境

安装操作系统
操作系统安装，过程略

硬件配置：
# hostname
nbutest
#prtconf
System Model: IBM,7026-B80
Machine Serial Number: 10960AF
Processor Type: PowerPC_POWER3
Number Of Processors: 1
Processor Clock Speed: 375 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: -1 NULL
Memory Size: 4096[……]

sqlnet.ora 控制访问IP

October 19, 2011 network, oracle 3 comments oracle TNS

sqlnet.ora中进行下列参数的设置可以限制或允许用户从特定的客户机连接到数据库中

[root@Hong ~]# ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:0C:29:24:93:F5
inet addr:192.168.1.99 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe24:93f5/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX pa[……]

Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites

October 17, 2011 advanced tech, oracle 7 comments 物化视图

We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirection to a materialized view is not happening.
We can redirect the output to a table called REWRITE_TABLE which is created via the utlxrw.sql script loca[……]

Ovpass 创建步骤

October 17, 2011 backup No comments backup

ovpass创建步骤
1、找出对应的光纤卡（粗体字），此处为fscsi1：
[21:58:27 root@billdg /]# lsdev -C |grep I/O
fscsi0 Available 03-00-02 FC SCSI I/O Controller Protocol Device
fscsi1 Available 05-00-02 FC SCSI I/O Controller Protocol Device
vio0 Available Virtual I/O Bus
[22:00:10 root@billdg /]# l[……]

exchange 备份错误

October 17, 2011 backup 2 comments backup

错误状态：

之前备份都正常，日志正常清除，NBU配置都正常，找不出可更改选项。
备份时报如下错误，且日志不能清除，造成系统空间报警：
2010-9-3 18:32:41 – Error bpbrm(pid=876580) 从客户端 SHHQ-Mail13: 出错 – failure reading file:
Microsoft Information Store:\First Storage Group\Log files (BEDS 0xE000FE7C: )
2010-9-3 18:33:14 – Error bpbrm(pid=876580) 从客户端 SHHQ-Mai[……]

ORACLE – 9i to 10g database Upgrade using DBUA.

October 17, 2011 migration, oracle No comments oracle Install

Purpose of this document is to show a complete 9i to 10g upgrade of an Oracle database on

AIX 5L using DBUA ( Database Uprgrade Assistant)
3.2 TECHNICAL SOLUTION
10g upgrade from 9.2.06 to 10.2.0.3 for any database -:
Check the init.ora parameter file in the 9I ORACLE_HOME/dbs
Make sure the[……]