Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.
Okay, so MooseX::Role::BuildInstanceOf is not one of my modules. And while I submited the patch, the feature itself was born out of fREW’s DBIx::Class::DeploymentHandler. So, in all this, my role was at best to be the pollinator agent between two beautiful flowers. But, hey, it’s not like a little bit of noise is going to hurt any of the involved parties, sooo… let’s see what the buzz’s about.
I took debug of duplication and figured out that RMAN internally executes procedure dbms_tts.transport_set_check preventing any further copy operations if tablespaces do not satisfy TTS requirements. Now the plot thickens and considering RMAN shows everything that it does in log file I decided to repeat the same steps but one by one and manually. Let’s get into it.
The 60s are NOT back but during the month of November , some gents , including myself, will grow a stache to raise the awareness of prostate cancer, an insidious disease that afflicts one in seven males.
Managing the databases of any kind of any size in the production environment requires the administrators to remain up to date and on the toes every time. They need to learn fast and apply their knowledge fast. Keeping abreast of the newer features and the troubleshooting techniques is must for them and this Log Buffer Edition helps easing that task. Enjoy the Log Buffer #244.
One of the most nice thing about the newer versions of Oracle is the advent of ASH and AWR as they provide awesome diagnostic information. Many customers at the Pythian use Real Application Cluster and having a cluster wide AWR report by using awrgrpt.sql script is very handy.
If you haven’t considered attending the AUSOUG conference in Perth yet, you definitely should! Out of 50 sessions I counted 21 to be presented by Oracle ACEs and Oracle ACE Directors; 8 by Oracle employees and at least 2 by Oracle Certified Masters! Briefly looking though the conference program I would like to suggest that you consider sessions from the following speakers.
From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.
Practice, Innovation, Learning, Positive Paranoia are few of the key factors which make a DBA rockstar. Paul Vallee, who is employing hundreds of top-notch DBAs from across the planet to service world’s busiest and critical databases nailed the concept down with a thud.
After an in place upgrade of SQL server 2005 to SQL server 2008 R2 , I tried to open SQL errorlog from Management> SQL server logs but I got the following error. Here’s how I fixed it.