Oracle data backup and recovery and log operations

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