In an Oracle 11g RAC environment, you might get this error when trying to start the database. This may happen for any one of the instances. When everything else is ONLINE and STABLE in your $GRID_HOME
在删除有父子表关系的表的数据时,我们都知道要先删除子表 再删除父表数据。昨天采用先删子表 ,再删父表,删除时使用truncate,结果在删除父表的时候,给出了这个提示:ORA-02266这个错误提示。当采用delete 语句删除父表的数据时候,则成功。根本问题是 :ddl与dml 的区别(because truncate isn't going to verif
之前用RMAN做过一个数据库的全备,后来发现数据库mess up了,想要恢复到之前做备份的那个状态,这个用RMAN很好办, RMAN> run{ 2> set until scn 44712912; 3> restore database; 4> recover database; 5> alter database open resetlogs; 6&g
1.问题现象 数据库日常巡检过程中,在alert日志中发现如下警告信息 ……省略…… Thu Apr 15 22:06:31 2010 Memory Notification: Library Cache Object loaded into SGA Heap size 3215K exceeds notification thre
今天在部署一套10g Oracle(10.2.0.1版本)的过程中,遭遇了ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []错误。通过网络搜索得到了解决方法,修改了/etc/hosts文件内容问题得到解决。以下为转载的网络内容,感觉比较全面,所以进行转载(原址为:ht
源地址:http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:275215756923 You Asked Tom, Would you tell me what snapshot too old error. When does it happen? What's the possible causes?
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号