Database Administration (MOSC)

MOSC Banner

Fraction Redolog

edited Sep 15, 2010 12:06AM in Database Administration (MOSC) 9 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center