Oracle Database Architecture and Recovery Mechanism

This RAID level refers striped set with dual parity.

This memory component of the SGA contains parsed SQL and execution plans for statements already run against the database.

This component of the RMAN environment containing the control files, data files and optional archived redo logs that RMAN backups.

These logical structures can be created to increase the performance of data retrieval.

You can create this component of the RMAN environment that contains the RMAN metadata for multiple target database.

This RAID level refers striped set with dedicated parity and bit interleaved parity.

This memory component of the SGA is an optional area that provides large memory allocations for backup and restore operations.

With real application clusters, SMON process of one instance can perform instance recovery for instances that have failed.

In clusters, related rows are physically stored together.

In this RAID level, the error detection is done by block level parity and is stored in separate single disk unit.

This component of the RMAN environment has the same DBID and DB_Name values as the primary database but a different DB UNIQUE NAME.

This background process is responsible for signaling database writer at the check points.

In this RAID level, drive failure requires replacement but the array is not destroyed by a single drive failure.

Here, the DBID is different from the database from which it was created.

Because oracle uses write-ahead logging, this background process does not need to write blocks when a transaction commits.