ALL POSTS

RMAN Recipes: How to Switch Oracle Logs Automatically

So you have swallowed the standby bait. You have used RMAN duplicate to create a sparkling new standby and things are looking rosy. Then, when you check the lag between the primary and standby (in MAXIMUM PERFORMANCE mode), you discover the standby is miles behind. Oracle (at least from 9iG) rides to the rescue again. The parameter ARCHIVE_LAG_TARGET tells Oracle to make sure to switch a log every n seconds.

DBMS_SCHEDULER and Implicit Commits

As usual, Oracle introduces new features, and we read the documentation about how they work and we start using them… but what about what is not in the documentation? That we find out by practice, experience, or accident. And that is exactly what happened to me today.

Bug in Oracle DST Patch Rollback

Last week, we discovered a bug related to the rollback of the Java DST patch for 9206 on Linux x86. If you’re in the unfortunate position of needing to roll this patch back, you won’t be able to. When you rollback, you need to restore both of these files, and then do a create or replace java system. Otherwise you risk hitting a dreaded ORA-03114 End of file on communication channel. Those of you familiar with DST patching will have seen this, but for those who haven’t, here are the scripts you need to check for a successful Java implementation:

Oracle Enterprise Manager 10GR3 to be launched March 13

Sorry if everyone else already knows this, but I just got some Oracle spam inviting me to EM 10GR3 launch party, and it’s scheduled as a “live online launch” on March 13, at 9:30. So those of you who are waiting with bated breath for the DST projects to be over now have something else to look forward to a couple days later!

Miracle Scotland DBF 2007

Unfortunately, I’m too slow to blog about news and can never make it first. Today is no exception and Doug Burns has already posted about “one of the best Oracle Conferences of all times”: I can tell you – I’m so excited to see all those bright people presenting. It’s especially a pleasure to see that Doug (who recently joined my team here at Pythian) is presenting there.

Page 220 of 250« First...102030...218219220221222...230240250...Last »