Fraction Redolog
Hi Guys,
I have some question. Now in my database i have twelve groups of redo files:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 194216 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
2 1 194217 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
3 1 194218 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
4 1 194219 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
5 1 194220 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
6 1 194221 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
7 1 194222 104857600 2 NO CURRENT 8.2726E+12 08-SEP-10
8 1 194211 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
9 1 194212 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
10 1 194213 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
11 1 194214 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
12 1 194215 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
12 rows selected.
Now i want change my redolog to two group where one group have two member/Redo. One Group have size 1G, but it's produce ten archive with each archive's size is 100M.
I have some question. Now in my database i have twelve groups of redo files:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 194216 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
2 1 194217 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
3 1 194218 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
4 1 194219 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
5 1 194220 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
6 1 194221 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
7 1 194222 104857600 2 NO CURRENT 8.2726E+12 08-SEP-10
8 1 194211 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
9 1 194212 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
10 1 194213 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
11 1 194214 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
12 1 194215 104857600 2 YES ACTIVE 8.2726E+12 08-SEP-10
12 rows selected.
Now i want change my redolog to two group where one group have two member/Redo. One Group have size 1G, but it's produce ten archive with each archive's size is 100M.
0