TL;DR: The archive_lag_target parameter will force log archiving in Standard Edition. Just a quick note here that I wanted to share since I didn't see anything directly confirming this when I was searching around. I have an Oracle 11gR2 Standard Edition (SE) database that I'm also maintaining a manual standby...
[Read More]
Don't Fear the EM12c Metric Extensions
A few weeks ago, our customer support team asked us to automate part of their checklist that looks at the number of active sessions in our production database. In EM12c, this seemed like a no-brainer with the Average Active Sessions metric. So I added this to my production incident ruleset...
[Read More]
Supplemental Logging and Securefiles Causing DBWn to Block
A few weeks back, we began making changes to prepare for using Oracle Golden Gate. One of the first steps required is to enable "minimal supplemental logging" at the database level. We did this during an evening maintenance window. However by the time the morning workload picked up, we started...
[Read More]
RMAN Redundancy is not a Viable Retention Policy
Originally posted by me on the Pythian blog. This is an older post that I somehow forgot to post on my own blog, but another recent redundancy foul-up reminded me of it.The story you are about to read is based on actual events. Names and paths have been changed to...
[Read More]
Migrating (and Upgrading!) Your EM12c Repository Database
This week I migrated our EM12c repository database to a new server as part of its promotion to production status. Just to make it a little more exciting, the migration also involved an in-flight upgrade from 11.2.0.3 to 11.2.0.4. Much of this post is directly inspired by Martin Bach's post...
[Read More]