Eddie Awad, Oracle blogger extraordinaire, has published the 73rd edition of Log Buffer, the weekly review of database blogs. Daniel Crook is on-deck, but won’t bat until January. That leaves plenty of room for others, so I invite you to get involved. Send an email to the Log Buffer coordinator (that would be me). Here’s Eddie [...]

The 72nd edition of Log Buffer, the weekly review of database blogs, making its second appearance on Sheeri Kritzer Cabral’s blog, The MySQL She-BA. Eddie Awad is on-deck for LB#73. After him, there’s lots of room, so please send an email to the Log Buffer coordinator (me) if you’d like to edit and publish an [...]

Just a short blog entry about a funny error message I’ve got while trying to activate a physical standby database: SQL> alter database recover managed standby database finish skip standby logfile; alter database recover managed standby database finish skip standby logfile * ERROR at line 1: ORA-00283: recovery session canceled due to errors ORA-01110: data file 1: '/oradata/stage/datafile/system_01.dbf' ORA-01122: database file 1 [...]

Welcome to the 71st edition of Log Buffer, the weekly review of database blogs. There were so many blogs covering this week’s Oracle Open World that I could have devoted this entire edition only to that. But that would not be fair to those other DBMSs, all of which are fine DBMSs in their own [...]

Just a quick note to say I’m leaving today for San Francisco to attend Oracle OpenWorld. I’ll be making my presentation on Thursday at 14:30, in Room 304. Look for IOUG: Oracle Database 11g –The Perfection of a Masterpiece (Session ID: S291070). I’ll be posting more about my OOW adventures here, so please stay tuned. I hope [...]

Welcome to the 70th edition of Log Buffer, the weekly review of database blogs. In honour of the start of cold-and-flu season, we start with an item on blob streaming. Paul McCullagh, the developer of the PBXT storage engine for MySQL, has made available his presentation on the BLOB streaming project, on his PrimeBase XT blog. [...]

Thinking I had something new, I wrote this article about recovering deleted files. However, it turns out Frits Hoogland had already blogged about recovery of deleted files on linux, as Frits pointed out in a comment on my blog, where he also mentioned a metalink note on this matter. The note ID is: 444749.1 “Retrieve deleted [...]

So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy way to recover deleted datafiles, for as long as your database remains up. The procedure below works on linux, however this method conceivably can work for other platforms. This procedure will even work if your database is [...]

I do realize that for most of you, there may be nothing new about the dbms_sys_sql package ? knowledge of it has been floating around for quite a while. I myself discovered this package a couple of years ago while playing around with HTMLDB’s (now APEX’s) internals. I’m posting this as a response to a [...]

Welcome to the 69th edition of Log Buffer, the weekly review of database blogs. We start this edition with an item about getting started: K. Brian Kelley’s first installment of Becoming a DBA on Databases, Infrastructure, and Security. It purposes to answer the question, what does it take to become a DBA? “(The) definition of [...]