Archive

Archive for the ‘oracle streams’ Category

Oracle High Availability Solutions for Unplanned Downtime

June 26, 2011 Leave a comment

Oracle High Availability Solutions for Unplanned Downtime

Outage Type Oracle Solution Benefits Recovery Time
Computer failures Fast-Start Fault Recovery Tunable and predictable cache recovery Minutes to hoursFoot 1 
RAC Automatic recovery of failed nodes and instances, fast connection failover, and service failover No downtimeFoot 2 
Data Guard Fast Start Failover and fast connection failover Seconds to 5 minutes
Oracle Streams Online replica database No downtime2
Storage failures ASM Mirroring and online automatic rebalance No downtime
RMAN with flash recovery area Fully managed database recovery and managed disk-based backups Minutes to hours
Data Guard Fast Start Failover and fast connection failover Seconds to 5 minutes
Oracle Streams Online replica database No downtime2
Human errors Oracle security features Restrict user access as prevention No downtime
Oracle Flashback technology Fine-grained and database-wide rewind capability < 30 minutesFoot 3 
LogMiner Log analysis Minutes to hours
Data corruption HARD Corruption prevention within a storage array No downtime
RMAN with flash recovery area Online block media recovery and managed disk-based backups Minutes to hours
Data Guard Automatic validation of redo blocks before they are applied, execute fast failover to an uncorrupted standby database Seconds to 5 minutes
Oracle Streams Online replica database No downtime2
Site failures RMAN Fully managed database recovery and integration with tape management vendors Hours to days
Data Guard Fast Start Failover and fast connection failover Seconds to 5 minutesFoot 4 
Oracle Streams Online replica database Seconds to 5 minutes4
Advertisements
Categories: oracle streams
%d bloggers like this: