Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
maxlogfile 1
- Thread starter liliya13
- Start date
-
1
- #2
SantaMufasa
Technical User
Liliya,
MAXLOGFILES if the upper limit of how many groups of on-line redo logfiles your database may have. You can specify this number only when you "CREATE DATABASE..." (or you can re-create the control file, which has its own set of problems).
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 20:55 (18Nov04) UTC (aka "GMT" and "Zulu"),
@ 13:55 (18Nov04) Mountain Time
MAXLOGFILES if the upper limit of how many groups of on-line redo logfiles your database may have. You can specify this number only when you "CREATE DATABASE..." (or you can re-create the control file, which has its own set of problems).
Mufasa(aka Dave of Sandy, Utah, USA)
@ 20:55 (18Nov04) UTC (aka "GMT" and "Zulu"),
@ 13:55 (18Nov04) Mountain Time
- Thread starter
- #3
SantaMufasa
Technical User
Liliya,
MAXLOGMEMBERS places an upper limit upon how much "duplexing" you can do within an on-line redo log group. For example if your values are these:
MAXLOGFILES: 3
MAXLOGMEMBER: 5
...and if you have gone to the maximums on your database, then this means Oracle will fill up Group 1, then switch to Group 2, then switch to Group 3, then back again to Group 1. Additionally, within each log group, each group will have 5 identical copies of the same information. Why have so many copies? Just in case there are media problems. It's for people who wear both belts and braces (suspenders in the U.S).![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
Did this answer your question, Liliya?
Mufasa
(aka Dave of Sandy, Utah, USA)
@ 22:15 (18Nov04) UTC (aka "GMT" and "Zulu"),
@ 15:15 (18Nov04) Mountain Time
MAXLOGMEMBERS places an upper limit upon how much "duplexing" you can do within an on-line redo log group. For example if your values are these:
MAXLOGFILES: 3
MAXLOGMEMBER: 5
...and if you have gone to the maximums on your database, then this means Oracle will fill up Group 1, then switch to Group 2, then switch to Group 3, then back again to Group 1. Additionally, within each log group, each group will have 5 identical copies of the same information. Why have so many copies? Just in case there are media problems. It's for people who wear both belts and braces (suspenders in the U.S).
Did this answer your question, Liliya?
Mufasa(aka Dave of Sandy, Utah, USA)
@ 22:15 (18Nov04) UTC (aka "GMT" and "Zulu"),
@ 15:15 (18Nov04) Mountain Time
- Status