An online redo log tracks all of your changes to your tables. In order to get started, you need a minimum of two to get started on your online database; this redo log group is like a recorder, that records changes going on in your oracle database. However, you will end up having more than one group. You could end up with three groups or more.
Oracle recommends that you multiplex your redo logs. When this redo log gets filled oracle does what is called a check point and then it writes to the next group.
This redo logs are used for database recovery. When the final group fills up it goes back to the first and writes to the first group (basically overwriting what was currently in the first group); but if you are in archive log mode, when the first group fills the information is copied onto Archived redo logs (the default is no archive log mode which overwrites the data).
If you have not archived the first log and your directory is full and you are running on archive log mode. Your database will hang.
Here is a basic definition of an oracle database
An oracle database is defined as three types of files, control files, data files and the redo logs! Any questions.
Oracle recommends that you multiplex your redo logs. When this redo log gets filled oracle does what is called a check point and then it writes to the next group.
This redo logs are used for database recovery. When the final group fills up it goes back to the first and writes to the first group (basically overwriting what was currently in the first group); but if you are in archive log mode, when the first group fills the information is copied onto Archived redo logs (the default is no archive log mode which overwrites the data).
If you have not archived the first log and your directory is full and you are running on archive log mode. Your database will hang.
Here is a basic definition of an oracle database
An oracle database is defined as three types of files, control files, data files and the redo logs! Any questions.
0 comments:
Post a Comment