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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|