Lightweight Oracle DBA Tools
raccheck 2.2 beta released v. 2.2.0 Beta Support for Single Instance Configurations (i.e., no longer limited to RAC configurations) High Availability (HA) Best Practices New checks and bug fixes This new version was prodiced with collaboration with ORACLE HA team in Support to add their Top 20 checks for common problems related to backup and [...]
MAA recommends to enable Flashback Database on the primary prior to FailOver: Enable Flashback Database to reinstate failed production databases after a failover operation has completed. Flashback Database provides a second very significant function, enabling fast point in time recovery if needed. See: MAA_WP_10gR2_SwitchoverFailoverBestPractices.pdf Enabling Flashback Database involves setting up flash recovery area and setting [...]
“Data Guard — it’s real it’s Oracle, you know what you’ve got!” said Joe Meeks (Director of High Availability Product Management at Oracle) in his closing statement during the Live Webcast presentation titled “Maximize Availability with Oracle Database 11g” held today. The focus of this presentation was on “Active Data Guard Option” of Oracle 11g. [...]
I was just reviewing Note:565535.1 Flashback Database Best Practices & Performance and came across the following paragraph under the title of “Measuring Impact of turning Flashback Database ON / Analyzing the Performance Impact“: If you’re on RDBMS release 11g and have a physical standby, then you can enable flashback database on your physical standby and [...]
Vitaliy Mogilevskiy - Solving ORACLE problems since 1996.
What you will find here is what works for me day in day out - 24x7x365 - simple ORACLE DBA Tools written using components that are available on every Unix platform with an ORACLE database -- sqlplus and KSH.
Do you have DBA questions? Head over to Ask DBA.
DBA Forums