Knowledge increases exponentially. Today, you probably own more books than great universities of times past—Cambridge University owned less than two hundred books in the fifteenth century. First came the invention of writing, then alphabets, then paper, then the printing press, then mechanization. Each step caused an exponential increase in the collective human knowledge. In our generation, Al Gore invented the internet and the last barriers to the spread of knowledge have been broken. Today, everybody has the ability to contribute, communicate, and collaborate. We are all caught up in a tsunami, an avalanche, a conflagration, a veritable explosion of knowledge for the betterment of humankind. This is the blog of the good folks at Database Specialists, a brave band of Oracle database administrators from the great state of California. We bid you greeting, traveler. We hope you find something of value on these pages and we wish you good fortune in your journey.

A Sanity Check for External Redundancy

As with any DBA my days are filled with what seem to be unrelated tasks to the profession - writing reports, attending meetings, installing releases, planning capacity, answering alerts, patching binaries and  running upgrades.  It is easy to forget three things I should be focusing on as a remote DBA:

Security
Availability
Performance

Some aspects of these core [...]

Standby database creation of VLDBs

Introduction

I have mentioned before that the best way to insure Oracle RDBMS uptime, is to create and maintain a physical standby database. There simply is no more reliable way to insure uptime for the Oracle RDBMS.
Creating a standby database involves these steps:

Creating a standby controlfile from the primary database & transferring it to [...]

Understanding Oracle Redo

In the Oracle RDBMS, one of the most frequently misunderstood concepts I see in doing remote database administration, is the role and importance of redo.

Need uptime? Use an Oracle Physical Standby database

Over the years of experience with Oracle databases, there is one feature, far more than any others, that has proved itself again and again in the real world; I speak of course, of the Oracle Physical Standby feature.

The importance of testing recovery

As a database administer, it’s very important not to forget one of our main responsibilities; that being insuring that the database(s) we’re responsible for, can be recovered in the case of an emergency.  Read my short presentation here, for thoughts on this important topic.
The Importance of Testing Database Recovery, by Jay Stanley