| Neeraj |
Posted: Jul 02, 2008 06:47:11 AM |
Total Post: 254
Joined: Jan, 2007
|
hi,
i m little confused so plz tell me if i have 3 redo files w/ 3 member in each group .
so how lgwr wirte in redo file ?
a 1 2 3
b 4 5 6
c 7 8 9
so how lgwr write into redo files ?when a is current so it wud write into 1 & copy into 2 & 3 or if writes in 1 then copy into 4 & 7.
thxs |
|
|
amith |
| Posted: Jul 02, 2008 07:02:31 AM | |
|
Total Post: 3
Joined: Jul, 2008
|
Hi,
Think a, b and c are 3 log files.
1,2 and 3 are log members of log file 'a'.
4,5,6 are log members of log file 'b'.
7,8,9 are log members of log file 'c'.
when log writer writes to log file 'a' then data written on member 1 and copy the same to 2 and 3.
When log switch occur it starts writing to log file 'b' and data is written on memeber 4 and copied to 5 and 6.
|
|
|
|
|
Neeraj |
| Posted: Jul 02, 2008 08:09:07 AM | |
|
Total Post: 254
Joined: Jan, 2007
|
|
|
|
|
positive |
| Posted: Jul 04, 2008 12:59:16 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
Gitesh |
| Posted: Jul 04, 2008 02:59:42 AM | |
|
Total Post: 322
Joined: May, 2005
|
LGWR writes redolog file in round and robin type.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |