ITPub博客

浙江移动升级（7套RAC升级，目前全国最大的升级案例）http://www.itpub.net/thread-1809842-1-1.html 谈论话题:        1、用什么技术完成的这次7套RAC同时案例升级的...

Oracle 回收站清理前几天，看到落落调优了一条由于回收站过大引起的SQL问题，作为一个DBA提供一些清理回收站的SQL --回收站大小select sum(mb) from (select * from ( selecta.owner,a.OBJECT_NAM...

11Gr2RAC udev ASM openfiler（安装文档） 一、11Gr2 RAC安装前准备ASM diskfindiscsi target;iscsiadm -m discovery -t st -p 192.168.1.218autoiscsi target;iscsiadm -m node -T iqn.2006-01.com.ope...

Asm disk status is member andcan't create asm disk group 环境Oracle:11.2.0.1Redhat 5.8Openfiler模拟存储  问题如下：这个是安装GI时发现的错误：可以发现ASM DISK，但是不能...

TABLE size （including table,index,lob,lobindex)COLUMN TABLE_NAME FORMAT A32COLUMN OBJECT_NAME FORMAT A32COLUMN OWNER FORMAT A10SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) MegFROM(S...

applying patch 9413827 before upgradingcrs to 11.2.0.3.0 环境：oracle 11.2.0.1 rac on redhat 5.811.2.0.1 RAC升级GI可以不停DB，直接升级GI；一个实例一个实例升级GI，使用保持有一个实...

Oracle 11g Data Guard Enabling Active Data Guard 开启ADG需要standby database instance redo-only mode and starting redo logfiles  The general process of enabling Active Data Guard is as s...

Oracle 11g dataguard check real time apply （on standby）环境：oracle 11.2.0.1 rac on redhat 5.8总结方法：1、select open_mode from v$database;READ ONLY WITH APPLY   --证明开启 RTA...

????Oracle dataguard enabling real time apply  总结：    物理DG：alter database recover managed standby database using current logfile disconnect;&n...

OPatch failed with error code 73（OracleHomeInventory gets null oracleHomeInfo） 1、问题描述[oracle@dou_rac2oraInventory]$/u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /u01/...

OPatch failed with error code 73 （These not-installedcomponents are oracle.crs:11.2.0.1.0） 1、问题缘由applying patch 9413827 before upgrading crs to 11.2.0.3.0学习中参考文献http:...

升级失败后，数据库降级方案（flashback database） 环境：Oracle 11.2.0.1 rac on redhat 5.8 Flashback database准备工作查看是否flashback database功能sys@RACDB> select log_mode,open_mode,fla...

郭老师的帖子，咱也凑凑热闹总结一下自己！以下均物理data guard1、Data Guard的核心操作是什么？redo send、redo receive、redo applyredo send==>log_archive_dest_2;log_archive_dest_state_2=enable;LNSn(lg...

DG 用 rman  duplicate 恢复standby 的问题及解决。SQL> startup nomount pfile=/opt/oracle/product/10g/dbs/initorcl.oraLRM-00123: invalid character 148 found in the input fileORA-01078: failure in pr...

实施DG利用RMAN恢复STANDBY数据库RMAN> duplicate target database for standby nofilenamecheck dorecover;Starting Duplicate Db at 28-MAR-12using target database control file instead of recovery catalogall...

awr之性能优化(二)【log file sync 优化】 AWR分析过程如下：Top 5 中表明log file 可能存在问题；log file sync 、log file parallel write的Avg Wait(ms)都偏高；Top 5提供优化基本方向可能是log...

快速定位抓取系统繁忙的AWR本文属于读《循序渐进ORACLE》后有感，记录eygle大师的脚本。以备以后使用！快速定位抓取系统繁忙的AWR本文属于读《循序渐进ORACLE》后有感，记录eygle大师的脚本。以备以后使用！select i...

官档《集结号》 收录以备用1、MAA官档集锦文档http://www.oracle.com/technetwork/database/features/availability/oracle-database-maa-best-practices-155386.html 2、oracld dataguard 高级应用?...

RAC基本备份恢复（二）一、RAC中RMAN备份脚本 1、  归档日志在本地的scriptsrun{ALLOCATE CHANNEL d1 TYPE disk connect 'sys/oracle@racdb1'; ALLOCATE CHANNEL d2 TYPE disk connect 'sys/oracle@...

RMAN-20208: UNTIL CHANGE is before RESETLOGS change 问题小计RMAN> restore database until scn 1045382;Starting restore at 2013-07-27 04:15:37using channel ORA_DISK_1RMAN-00571: ======================...