Redo Log Groups

From DBArtisan
Jump to: navigation, search

Go Up to Supported Objects

Redo Logs save information on the state of the database after an update. If the database fails before the update is written to the datafiles, the update can be re-done, bringing the changes back after a crash, so it appears the update did happen.

Tip: Have sufficient redo logs available so that other Oracle threads do not have to wait until one is free before performing an update.

Redo logs are arranged in groups, and when a particular group is being written to, each member receives the same data.

Tip: To avoid crashes, have two logfiles in a group, each one being on a different (physical) disk.

Creating and editing

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

ORCL

Drop

Extract

Migrate

Report

Switch Logfile

Take Checkpoint