ITPub博客

RMAN> duplicate target database for standby nofilenamecheck ......Errors in file /u01/app/oracle/admin/stdby/udump/stdby_ora_794674.trc:ORA-00600: internal error code, arguments: [krbvalunused_badfno], [64], [85], [], [], [], [], [][@more@]RMAN> duplicate target database for standby nofilenamecheck ......Errors in file /u01/app/oracle/admin/stdby/udump/stdby_ora_794674.trc:ORA-00600: internal error code, arguments: [krbvalunused_badfno], [64], [85], [], [], [], [], []到主库validate backups

Are they the same? Based on documents, the second one will call "checkpoint" so does this mean alter system switch logfile contains alter system checkpoint?The answer is NO.Try to test on a busy system, alter system switch logfile several times until it rounds to the logfile that is still active, and you will hung at switch logfile. Check the v$Logfile you will see that your next logfile is active.Solution is to alter system checkpoint and all uncurrent logfile will be inactive.This de

报错："Central Inventory /etc/oracle/oraInventory is on a shared drive, each node among rac1,rac2 should have its own Central Inventory. Central Inventory cannot be shared, this is not supported"根据604513.1， 尝试修改地址没有效果。oraInventory的目录是在本地磁盘，按道理不应该出现这样的问题。最终解决方法：/u01/crs/oracle/product/10/app/oui/bin/attachHome.sh -silent -local -cfs CRS=true -invPtrLoc /u01/crs/oracle/product/10/app/oraInst.loc 检查版本：crsctl query crs softwareversion[@more

alter session set sort_area_size没用，session的pga只能用到系统级别的设置。这个bug是10203引进的，下面是相关链接：https://metalink2.oracle.com/metalink/plsql/f?p=130:14:6981579750773090559::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,452466.1,1,1,1,helveticahttp://oracle-randolf.blogspot.com/2008/02/nasty-bug-introduced-with-patch-set.htmlhttp://jonathanlewis.wordpress.com/2008/11/25/sas-bug/[@more@]1. 从JL的blog可以看到我们可以临时这样解决，就是设置两次。

2 cases to recover standby after primary open resetlogs:It's supported by oracle:http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1026480If the standby database. . .Then. . .Perform these steps. . .Has not applied redo data past the new resetlogs SCN (past the start of the new branch of redo data)Redo Apply automatically takes the new branch of redo.No manual intervention is necessary. The MRP automatically resynchronizes the standby database with the new branch of r

We've got a interesting problem today, a simple explain plan will take more than 1mins.[@more@]From oracle Document:========================================================================================================================================================== * Level 0: Do not use dynamic sampling. * Level 1: Sample all tables that have not been analyzed if the following criteria are met: (1) there is at least 1 unanalyzed table in the query; (2) this unanalyzed table is joined

1. ORA-01009: missing mandatory parameter2. ORA-16055: FAL request rejected3. ORA-01034: ORACLE not available[@more@]1. ORA-01009: missing mandatory parameterIn metalink, we have this url may related:https://metalink2.oracle.com/metalink/plsql/f?p=130:15:9790252599340919149::::p15_database_id,p15_docid,p15_show_header,p15_show_help,p15_black_frame,p15_font:BUG,5929647,1,1,1,helveticaActually this was cause by missing parameter fal_server or fal_client. We need to set both FAL_CLIENT and FAL_SERV