• 博客访问: 142517
  • 博文数量: 68
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-04 11:19
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2010-02-24 15:39:18

一:安装编译#cd $ORACLE_HOME/rdbms/lib#make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed#./bbed parfile=par.bbd建立2个参数文件 a.txt par.bbdoracle@vm1 oracle]$ more a.txt6 /u01/oracle/oradata/test/users01.dbf 262225922 /u01/oracle/oradata/test/users01.dbf.bak 26222592查询数据文件的file_id,file_name ,bytes[oracle@vm1 oracle]$ more par.bbdblocksize=8192listfile=a.txtmode=edit二:常见数据块操作1:根据ROWID查询某行所在的文件号,数据块, 列内容的OFFSET具体位置 数据文件号:SQL> select DBMS_ROWID.RO......【阅读全文】

阅读(840) | 评论(0) | 转发(0)

发布时间:2010-02-23 10:10:44

In this Document Purpose Overview Scope and Application 10gR2 Streams Recommended Configuration Configuration 1.0 Software Version 2.0 Database Parameters 3.0 Database Storage 3.1. Tablespace for Streams Administrator queues 3. 2. Separate queues for capture and apply 4.0 Privileges 5.0 Source Site Configuration 5.1. Streams and Flash Recovery Area (FRA) 5.2. Archive Logging must be enabled 5.3. Supplemental logging 5.4. Implement a Heartbea......【阅读全文】

阅读(2578) | 评论(0) | 转发(0)

发布时间:2010-02-08 10:19:31

查看AWR各详细使用空间描述SQL> connect / as sysdbaSQL> @?/rdbms/admin/awrinfo.sqlIn this DocumentPurposeScope and ApplicationGeneral guidelines for SYSAUX space issuesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 11.1.0.6Information in this document applies to any platform.PurposeThe purpose of this document is to give general guidelines for SYSAUX tablespace space issues to control and decrease the space usage. It refers to several metalink notes for details when ne......【阅读全文】

阅读(3839) | 评论(0) | 转发(0)

发布时间:2010-02-03 14:45:58

In this Document Goal Solution 1. Stop all CRS managed resources 2. Stop all CRS services 3. Reformat ALL partitions for OCR and voting disk files 4. Set TEMP and TMP variables 5. Locate the crssetup.config.bat script 6. Execute racgons from $CRS_HOMEbin 7. Run oifcfg to configure public and cluster_interconnect 8. Run Virtual IP Configuration Assistant (VIPCA) 9. Run Cluster Verification Uitility (cluvfy) 10. Create an export copy of the......【阅读全文】

阅读(4101) | 评论(0) | 转发(0)

发布时间:2010-02-03 14:44:42

In this Document Goal SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3Oracle Server - Standard Edition - Version: 10.2.0.1 to 10.2.0.3Sun Solaris x86 (32-bit)HP-UX ItaniumIBM AIX Based Systems (64-bit)Linux ItaniumLinux x86-64Sun Solaris SPARC (64-bit)HP-UX PA-RISC (64-bit)HP Tru64 UNIXOracle Clusterware GoalThe goal of this document is to help customers who have accidentally deleted the OCR, voting disk or the files that are required for the operation of ......【阅读全文】

阅读(1471) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册