ITPub博客

一个RAC恢复案例并思路--12008-07-11 16:05环境：AIX 5.3Oracle 10.2.0.2 RAC2 instance错误：看alert把Thu Jul 10 15:37:47 2008Errors in file /oracle/app/oracle/admin/qasmdm/bdump/qasmdm1_lgwr_446692.trc:OR...

从rac上生成pfile文件并移除cluster_database_instances，cluster_database的等与RAC相关的参数,移除多余的undo_tablespace,只保留一个undo_tablespace启动到nomount状态用rman还原出controfile要点:查看日志文...

juliandyke and his website:http://www.juliandyke.com/Presentations/Presentations.html

From:http://www.oracle.com/technology/pub/articles/wartak-rac-vm.htmlhttp://www.oracle.com/technology/products/database/clusterware/pdf/oracle_rac_in_oracle_vm_environments.pdf...

From:http://wiki.oracle.com/page/vmware?t=anon

From:http://wiki.oracle.com/page/Installing+Oracle+on+VMware?t=anon

From:http://www.orafaq.com/node/66

Fromhttp://vongates.itpub.net/post/2553/462828Oerr--ORA-02174: Missing required thread number上周一同事到客户处为现有的RAC环境新增一节点,前面工作都很顺利,但最后用DBCA增加Instance是遇到 ORA-02174: Miss...

From:http://www.orafaq.com/node/758

From:http://www.oracle.com/technology/pub/articles/vasiliev-oracle-jdbc.html

清内存对象及转储命令(zt)清buffer cache清shared pool转储sga转储library cache转储控制文件、日志文件、数据文件Ref: http://haochunpeng.itpub.net/post/385/786309i清buffer cachealter session set events...

alter session set timed_statistics=true;alter session set sql_trace=true;alter session set  events '10046 trace name context  forever,level 12';alter session set tracefile...

download site:http://www.oracle.com/technology/tech/oci/instantclient/index.htmlphp+instant clienthttp://www.oracle.com/technology/global/cn/pub/notes/technote_php_instant.htmlhttp://www.oracle.c...

From:metalink note 60545.1How to extract controlfiles, datafiles, and archived logs from SMR backupsets without using RMAN Introduction: When using RMAN to restore objects (d...

From:http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ#Can_one_restore_RMAN_backups_without_a_CONTROLFILE_and_RECOVERY_CATALOG.3F另见如何使用DBMS_BACKUP_RESTORE包http://www.dbanot...

From:http://www.orafaq.com/node/50Sometimes it is a rouge query, sometimes a simple data clean up effort by the users, whatever may the cause be, inadvertent data-loss is a very common phen...

From:http://www.orafaq.com/node/57http://www.orafaq.com/node/59http://yangtingkun.itpub.net/post/468/262772http://www.eygle.com/archives/2004/12/oracle9iaioeoeo.html

From:http://www.orafaq.com/node/74On our quest to learn about Oracle's Data Pump utility it has often been compared to the old export and import (exp & imp) utilities that we have all grown...

From:http://**/viewthread.php?tid=64887=============================================MOVE在线处理move table  和 rebuild index的方法=============================================In Orac...

From:http://www.orafaq.com/node/31