79672

About Online Redo Log Files

Every Oracle database has a set of two or morę online redo log files. The set of online redo log files is collectively known as the redo log for the database. A redo log is madę

up of redo entries, which are also called redo reeords.

The online redo log Stores a copy of the changcs madę to data. If a failurc requires a data file to be restored from backup, then the reccnt data changcs that are missing from the restored data file can be obtained from the online redo log files, so work is never lost. The online redo log files are used to recover a database after hardware, software, or media failurc. To protect against a failurc involving the online redo log file itself, Oracle Database can multiplex the online redo log file so that two or morę identical copies of the online redo log file can be maintained on different disks.

The online redo log for a database consists of groups of online redo log files. A group consists of an online redo log filc and its multiplexed copies. Each identical copy is considered to be a member of that group. Each group is defined by a number, such as Group 1.

Figurę 6-2 on page 6-4 shows the configuration of a database that has three online redo log groups and two members in each group. For each group, the members are stored on separate disks for maximum availability. For example, the members of Group 1 are the redo log files A_LOGl and B_LOGl.

Wyszukiwarka

Podobne podstrony:
Overview of the Oracle Instance and Instance Management An Oracle database system consisLs of an Ora
Enabling Archiving of Redo Log Files To back up thc databasc whilc it is open, or to be ablc to perf
About Database Storage Structures An Oracle database is madę up of physical and logical structures.
About Oracle Database Oracle Database is a rclational database with objcct and Extcnsiblc Markup Lan
About Program Codę Stored in the Database Oracle Database offers the ability to storę program codę i
About Server and Client Processes In addition to background processes, Oracle Database crcates serve
About Software Management and Patch Releases Software management involves kccping your Oracle Databa
About Table Types The most common typc of table in an Oracle databasc is a relational table. which i
About Tables The table is the basie unit of data storage in an Oracle database. It holds all user-ac
About the Fast Recovery Area Size Oracle Database Backup and Recovery User s Guide explains ho w to
About This Guide Oracle Database 2 Day DBA is a databasc administration quick start guide that tcach
About Undo Data Whcn a transaction modifies data, Oracle Database copies the original data before mo
5) Oracle Database for the alignment monitoring tables, optical sensors data and conditions data, ma
About Advisors Advisors arc powcrful tools for database managcment. Thcy providc spccific advicc on
About User Privileges and Roles User privileges provide a basie level of database security. Thcy arc
Creating and Managing a Databasewith DBCA Unlcss you spccified that only thc Oracle Databasc softwar
Installing Oracle Database Software This section briefly dcscribcs thc stcps for a dcsktop-class ins
Overview of Database Backup and Recovery The focus in Oracle Database backup and recovcry is on the

więcej podobnych podstron