ITPub博客

导言：如果你的数据库昨天下午5点做全了备份，昨天晚上7点为表空间增加了文件。今天早上数据库磁盘坏了。 请问：1，数据库能够完全恢复吗？2，如何恢复？ 我回答：应该可以，但是具体步骤吗。。。。这个当...

事因：由于修改了CONTROL_FILES 参数,导至ORACLE 重启后无法启动,连实例也起不了.如果INSTANCE能够START, 那么解决起来就很容易了,可是现在INSTANCE都启不了.可是我又不甘心用PFILE 起动,因此花费了半天时间研究琢磨,有点小收获,在此分享.[@more@]1, SET CONTROL_FILES PARAMETER.SQL> alter system set control_files='+NORM_DG1/ggctl01.ora, +NORM_DG1/ggctl02.ora, d:hqgg.ora' scope=spfile;2, START INSTANCE.SQL> startupORA-15124: ASM file name '+NORM_DG1/ggctl01.ora, +NORM_DG1/ggctl02.ora, d:hqgg.ora' contains an

Flashback table with foreign key constraint.ALTER TABLE EMP DROP CONSTRAINT FK_DEPTNO ;ALTER TABLE EMP ADD ( CONSTRAINT FK_DEPTNO FOREIGN KEY ("DEPTNO") REFERENCES "SCOTT"."DEPT" ("DEPTNO") ON DELETE SET NULL ENABLE); 09:44:40 SQL> set linesize 100009:44:44 SQL> select * from emp;[@more@]Flashback table with foreign key constraint.ALTER TABLE EMP DROP CONSTRAINT FK_DEPTNO ;ALTER TABLE EMP ADD ( CONSTRAINT FK_DEPTNO FOREIGN KEY ("DEPTNO"

现在社会的好男人越来越少了，与其抱怨，不如从自己做起。下面给出我的一个女同事对我提出的建议，愿有跟我类同的朋友们一起学习改正。1, 两天换一次衣服。（女孩子不喜欢男人脏兮兮的）2，端正对女人的态度。3， 走路直起背来，要有精神，有气质。4，谈论问题时观点不要太偏激，因为这是一种不成熟的表现。[@more@]

Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles and logfiles.* Overview of Automatic Storage Management (ASM)* Initialization Parameters and ASM Instance Creation* Startup and Shutdown of ASM Instances* Administering ASM Disk Groupso Diskso Templateso Directorieso Aliaseso Fileso Checking Metadata* ASM Filenames* ASM Views* SQL and ASM* Migrating to ASM Using RMAN[@more@]Automatic Storage Managemen

应用系统中，由于业务需要，修改了原来的表TABWARE，并改名为TABWARE2，同时建立一个视图TABWARE，所以应用程序没有改。用了一天以后，ORACLE 内核报错：--- pieces excerpt from alert_SID.LOG .Mon Aug 13 14:04:18 2007Errors in file d:oracleadminhqerpudumphqerp_ora_3620.trc:ORA-00600: 内部错误代码, 参数: [kksfbc-reparse-infinite-loop], [0x38AEC0E0], [], [], [], [], [], [][@more@]反思一个问题（在应用系统上修改表）应用系统中，由于业务需要，修改了原来的表TABWARE，并改名为TABWARE2，同时建立一个视图TABWARE，所以

A scenario :windows xp 32bit, oracle 10.2.0.1 -32bit.1, alter system set processes=15 scope=spfile ;2 restart oracle ,Can only mounted, but not be able to open.3, alter system set processes=20 scope=spfile ;4, open database successfully.[@more@]A scenario :windows xp 32bit, oracle 10.2.0.1 -32bit.1, alter system set processes=15 scope=spfile ;2 restart oracle ,Can only mounted, but not be able to open.3, alter system set processes=20 scope=spfile ;4, open database successfully.5,SQL> select c

http://xsb.itpub.net/post/419/70362 [@more@]

http://ditu.google.cn/maps?hl=zh-CN&q=%E7%9B%91%E6%8E%A7&near=%E6%B2%B3%E5%8D%97%E7%9C%81%E9%83%91%E5%B7%9E%E5%B8%82&ie=UTF8&ei=-oiyRp_eIpzIjAO48KXICQ&cd=2&cid=0,0,2915025023365896478&li=lmd&ll=34.771794,113.680322&spn=0.004741,0.009656&z=16&om=0[@more@]

http://www.gplivna.eu/papers/v$session_longops.htm#_Toc155540263[@more@]

国内ERP的技术局限性--kexin=http://ebusiness.eguo.com/user1/kexin/archives/2006/785.html http://www.erpxp.com/Erpjs/MPS/200701/6551.htmlhttp://www.erpxp.com/Erpjs/empolder/200704/6954.htmlhttp://www.erpxp.com/Erpjs/coding/200701/6601.html[@more@]