Oracle data backup and recovery and log operations

Source: Internet
Author: User
Tags failover

At this time, I found a good document for recovery and backup. I only wanted to start Oracle database development. So I only studied logminer. Others for the moment, but only excerpted some of them.

Oracle availability plan:

• Computer faults: Quick Start of fault recovery, real Application Clusters (RAC), data guard, Oracle streams
• Storage faults: Automatic Storage Management (ASM), RMAN with fast recovery areas, data guard, and Oracle streams
• Human Error: Oracle Security Function, Oracle flash back technology, logminer
• Data corruption: hardware released ed resilient data (hard) solution, RMAN with fast recovery zone, data guard, Oracle streams
• Site faults: rman, data guard, and Oracle streams

 

Oracle provides high availability solutions for the following types of unexpected shutdown:
• Computer failure: the database running system is unavailable
• Storage failure: storage devices that contain some or all databases are unavailable
• Human Error: incorrect operations or malicious operations may cause damage or unavailability of the database's data Logic
• Data corruption: hardware or software components cause database read/write corruption
• Site failure: This event causes all or important parts of the application to stop processing or slow down to an unusable level.

 

Oracle high availability solution for unexpected Shutdown

Downtime type Oracle Solution Advantages Recovery Time
Computer Fault Quickly start fault recovery Adjustable and predictable cache recovery Minutes to hours
RAC

Automatic Recovery of failed nodes and instances, fast connection

Transfer and Failover and service failover

No downtime
Data guard Fast Start failover and fast connection failover Less than one minute
Oracle streams Connect to the replication Database No downtime
Storage fault ASM Images, automatic online rebalancing No downtime
RMAN with quick recovery zone Security management database recovery and disk-based backup Several minutes to several hours
Date gruard Fast Start failover and fast connection failover Less than 1 minute
Oracle streams Connect to the replication Database No downtime
Data corruption Hard Damage prevention measures in storage arrays No downtime
RMAN with quick recovery zone Online Block Media recovery and disk-based backup Management Several minutes to several hours
Date gruard Automatically verify the redo block and quickly fail over to the standby database. Less than 1 minute
Oracle streams Online Database Replication No downtime
Site fault RMAN Fully managed database recovery Hours to days
Date gruard Fast Start failover and fast connection failover Seconds to 5 minutes
Oracle streams Online Database Replication Seconds to 5 minutes
Incorrect Oracle flash back Technology Ripple for fine granularity and database range Less than 30 minutes
Logminer Log Analysis Minutes to hours
Oracle Security Features Restrict user access No downtime

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.