ITPub博客

votedisk一共3份:/dev/raw/raw2/dev/raw/raw5/dev/raw/raw6清空一份（dd if=/dev/zero of=/dev/raw/raw2)之后2个node同时重启了，之后重新手动启动crs顺利起来了，之后再清空一份，2个节点又同时重启了，之后手动启动crs无法启动了，因为完好的votedisk不够一半以上。[@more@]原本以为3个votedisk损坏一个之后rac可以正常使用，没想到node都重启了，之前记得在metalink上看到一些内容说rac在正常使用时根本不管votedisk的好坏，只是在private network出现问题时才使用votedisk看来是错误的。

通过alert仔细观查，发现实例恢复的顺序是：1、前滚2、open db3、rollback（注意：SMON: Parallel transaction recovery tried在Completed: ALTER DATABASE OPEN）之后SMON: enabling cache recoveryMon Jun 13 16:50:50 2011Successfully onlined Undo Tablespace 1.Mon Jun 13 16:50:50 2011SMON: enabling tx recoveryMon Jun 13 16:50:50 2011Database Characterset is ZHS16GBKreplication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=30, OS i

os内核的某个deamon process宕了，os是重启还是关机？讲课的时候忽然觉得oracle里的几个重要的后台进程其实就是oracle 实例的deamon process[@more@]rt

其实rac已经安装好了，我使用cluvfy命令时发现一个有意思的问题(安装前需要使用runcluvfy来验证，因为cluvfy命令还没有被安装进来），安装crs之后cluvfy就可以正常使用了。[@more@]通过root验证失败，错误提示主要是：Result: Membership check for user "root" in group "oinstall" [as Primary] failed.原因就是说oinstall组不是root用户的主组，执行下面命令把root加到oinstall和dba组里：# usermod -G root,oinstall,dba -U root并且root用户注销之后：[root@node1 ~]# groupsroot oinstall dba[root@node1 ~]# 很

我认为我替大家弄ocp证书的优势在于我很专业，价格也比较低，而且你们也比较省心，同时考试也比较灵活吧。不像其他一些机构忽悠的成份大一些，毕竟我自己也做技术、也是dba。从我这儿报名考ocp、ocm的免费永久享受我给企业做培训时录制的所有视频。[@more@]1、我是搞oracle的、是做技术的，我对oracle不论是技术上还是商务上都非常了解。我的blog：http://warehouse.itpub.net2、我公司拿过wdp授权业务，我对通过wdp途径考证流程非常清楚；3、我对通过原厂培训之后获得ocp证书的流程非常清楚；4、vue注册的流程我很清楚；5、vue预约的流程

To grant a system privilege, you must either have been granted the system privilege with the ADMIN OPTION or have been granted the GRANT ANY PRIVILEGE system privilege.To grant a role, you must either have been granted the role with the ADMIN OPTION or have been granted the GRANT ANY ROLE system privilege, or you must have created the role.To grant an object privilege, you must own the object, or the owner of the object must have granted you the object privileges with the GRANT OPTION, or you mu

好多人说韩系和日系车如何如何，我觉得没开过的话就不要说三道四；喜欢这款车好久了，大约从它出来就喜欢上了，喜欢它的外形，大气，厚实；花轿车的价格买了SUV我觉得性价比不错，在不降价之前我觉得不太划算，现在还好，尽管出差依然不少，但是不出差的时候也经常跑客户那儿，公司的一些杂七杂八的事情也需要处理，总之没有个代步的工具总觉得不是很方便，尽管停车比较困难...留个纪念，2011年5月28日（星期六）...新起点、新征程！[@more@]接下来的工作就是练了...

原文连接：http://www.oracledba.org/11g/rac/11g_RAC_Admin_Utilities.html#Various_Timeout_Settings_in_Cluster:[@more@]11g RAC Administration and Maintenance Tasks and Utilities:Task List:Checking CRS StatusViewing Name Of the ClusterViewing Nodes ConfigurationChecking Votedisk InformationChecking OCR Disk informationTimeout Settings in ClusterADD/Remove OCR filesADD/Remove VotediskBacking Up OCRBacking Up VotediskRestoring OCR DevicesRestoring Voting Disk DevicesChanging Public IPs as well as Virt

网上看的一篇不错的文章，记录一下[@more@]The voting disk is a shared raw disk partition or file on a clustered file system that is accessible to all nodes in the cluster. Its primary purpose is to help in situations where the private network communication fails. When that happens, the cluster is unable to have all nodes remain available because they are no longer able to synchronize I/O to the shared disks. Therefore, some of the nodes must go offline. The voting disk is then used to communicate

锁的一点分析、总结和理解。[@more@]session 1:SQL> select * from tt; ID NAME AGE---------- ---------- ---------- 1 c 30 2 bSQL> select distinct sid from v$mystat; SID---------- 159SQL> update tt set name='a' where id=1;已更新 1 行。SQL>--============================session 2:SQL> select distinct sid from v$mystat; SID---------- 142SQL> update tt set age=30 where id=1;等待--===============================

随手记录。。。[@more@]21:29:17 SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。21:29:47 SQL> startup mountORACLE 例程已经启动。Total System Global Area 314572800 bytesFixed Size 1248768 bytesVariable Size 109052416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7139328 bytes数据库装载完毕。21:29:53 SQL> alter database noarchivelog ;alter database noarchivelog*第 1 行出现错误:ORA-38774: 无法禁用介质恢复

segment size<=1m extent 按照64k分配；segment size<=64m extent 按照1m分配；segment size<=1g extent 按照8m分配；segment size>1g extent 按照64m分配；以前看doc这么介绍的，今天正好创建一了一个14g的大表，顺道观查了一下，做个记录[@more@]16:54:38 SQL> select bytes/1024/1024/1024 from dba_segments where segment_name='T' and owner='SYS';BYTES/1024/1024/1024-------------------- 14.25已用时间: 00: 00: 00.1816:54:48 SQL> select distinct bytes/1024/1024 extent_size from dba_

版本11gR1,在客户的db alert日志中看到了这一现象，记录一下。[@more@]Expanded controlfile section 19 from 818 to 8180 recordsRequested to grow by 7362 records; added 10 blocks of recordsTue Apr 19 14:48:49 2011

以前是发mail，从2011年5月23日开始mail将被废弃，下面是oracle说mail废弃的说明--===============================Note: The ocp-fulfillment_ww@oracle.com mail box will be decommissioned on 23-May-2011, you will not receive any reply from this mail box. For all your Certification questions or issues, please submit a Service Request - http://education.oracle.com/pls/eval-eddap-dcd/OU_SUPPORT_OCP.home?p_source=OCP and an OCP customer service representative will contact you.--=============================

原文连接：http://blog.csdn.net/tianlesoftware/archive/2009/10/16/4674224.aspx[@more@]防止网页失效，拷贝过来保留一份：一. 官网说明1. Oracle 10g文档如下：http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#i1010293 Data Pump ComponentsOracle Data Pump is made up of three distinct parts:（1）The command-line clients, expdp and impdp（2）The DBMS_DATAPUMP PL/SQL package (also known as the Data Pump API)（3）The DBMS_METADATA PL/SQL package (also known as the Metadata API)

以前对临时段的认识到底是出现了错误还是oracle 10g有变化，发现临时段在sort之后查询结束释放了。[@more@]下面这些doc都是来着oracle官方文档，都是介绍临时段的，可以参考。Introduction to Temporary SegmentsWhen processing queries, Oracle often requires temporary workspace for intermediate stages of SQL statement parsing and execution. Oracle automatically allocates this disk space called a temporary segment. Typically, Oracle requires a temporary segment as a database area for sorting. Oracle does not cr

不论是sga自动管理还是手动管理，共享池都是由2部分内存组成的，一部分是供我们用户使用，这部分就是我们熟悉的library cache和dictionary cache，另一部分就是oracle内部使用的，比如参数process的大小直接决定了使用这部分内部使用的内存大小。[@more@]Specifying the Shared Pool SizeThe SHARED_POOL_SIZE initialization parameter is a dynamic parameter that lets you specify or adjust the size of the shared pool component of the SGA. Oracle Database selects an appropriate default value.In releases before Oracle Dat

更详细的内容可以参考doc：http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1.htm#sthref247本文只针对RETENTION POLICY和BACKUP OPTIMIZATION以及结合043中的一道题做一个简单的说明，这道题在群内问起的人很多，确实不是很好理解。[@more@]先看一下doc吧：If backup optimization is enabled, and if a recovery window retention policy is ineffect, then when performing SBT backups RMAN always backs up datafiles whosemost recent backup is older than the recovery window. For example, assume that

实例恢复的过程中事务恢复（也就是rollback掉那些没有提交的事务）到底是在open之前还是open之后做呢貌似oracle没有给出一个明确的说法，我以前一直认为是首先前滚然后open db之后再做rollback（事务恢复），但是通过alert里面实例恢复的过程来观查发现应该是在open之前就做了rollback（SMON: enabling tx recovery）。 从alert中记录的日志来看open的过程中先后做了前滚和回滚之后才能open db。[@more@]Shutting down instance (abort)License high water mark = 12Instance terminated by USER, pid = 5688Sun Mar 27 11:24:26 2011Adju

doc的原话，记录一下[@more@]Overview of Instance and Crash RecoveryCrash recovery is used to recover from a failure either when a single-instance database fails or all instances of an Oracle Real Application Clusters database fail. Instance recovery refers to the case where a surviving instance recovers a failed instance in an Oracle Real Application Clusters database.The goal of crash and instance recovery is to restore the data block changes located in the cache of the terminated instance and t