Home > Administration with ASM > Add Redo Logs in ASM

Add Redo Logs in ASM

December 21, 2009 Leave a comment Go to comments

1. Show existing Redo Log Groups

SQL> select inst_id,group#,status,type,member from gv$logfile;

   INST_ID     GROUP# STATUS  TYPE    MEMBER

———- ———- ——- ——- ————————————————–

         1          2         ONLINE  +DAT1/sgcsprod/onlinelog/group_2.286.700253009

         1          2         ONLINE  +REC1/sgcsprod/onlinelog/group_2.278.700253011

         1          1         ONLINE  +DAT1/sgcsprod/onlinelog/group_1.285.700253007

         1          1         ONLINE  +REC1/sgcsprod/onlinelog/group_1.277.700253009

         1          3         ONLINE  +DAT1/sgcsprod/onlinelog/group_3.289.700253235

         1          3         ONLINE  +REC1/sgcsprod/onlinelog/group_3.279.700253235

         1          4         ONLINE  +DAT1/sgcsprod/onlinelog/group_4.290.700253237

         1          4         ONLINE  +REC1/sgcsprod/onlinelog/group_4.280.700253239

         2          2         ONLINE  +DAT1/sgcsprod/onlinelog/group_2.286.700253009

         2          2         ONLINE  +REC1/sgcsprod/onlinelog/group_2.278.700253011

         2          1         ONLINE  +DAT1/sgcsprod/onlinelog/group_1.285.700253007

         2          1         ONLINE  +REC1/sgcsprod/onlinelog/group_1.277.700253009

         2          3         ONLINE  +DAT1/sgcsprod/onlinelog/group_3.289.700253235

         2          3         ONLINE  +REC1/sgcsprod/onlinelog/group_3.279.700253235

         2          4         ONLINE  +DAT1/sgcsprod/onlinelog/group_4.290.700253237

         2          4         ONLINE  +REC1/sgcsprod/onlinelog/group_4.280.700253239

 16 rows selected.

SQL> select inst_id,group#,thread#,sequence#,bytes,members,status from gv$log;

    INST_ID     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS STATUS

———- ———- ———- ———- ———- ———- —————-

         1          1          1         99  104857600          2 INACTIVE

         1          2          1        100  104857600          2 CURRENT 

         1          3          2        113  104857600          2 CURRENT <–

         1          4          2        112  104857600          2 INACTIVE

         2          1          1         99  104857600          2 INACTIVE

         2          2          1        100  104857600          2 CURRENT

         2          3          2        113  104857600          2 CURRENT

         2          4          2        112  104857600          2 INACTIVE

– Redo group 1and 2 are assigned to instance 1, Redo group 3 and 4 are assigned to instance 2

– Redo group 2 is active on instance 1 and instance 1 acts as recovery instance once instance 2 is down, therefore Redo group 3 is active on instance 1

– Redo group 3 is active on instance 2 and instance  acts as recovery instance once instance 2 is down, therefore Redo group 1 is active on instance 2

2. Add log groups for thread 1 and thread 2 with two members, one is created on ‘+DAT1’ Diskgroup, anoth 

alter database add logfile thread 1 group 5 (‘+DAT1′,’+REC1’) size 100M;

alter database add logfile thread 1 group 6 (‘+DAT1′,’+REC1’) size 100M;

alter database add logfile thread 2 group 7 (‘+DAT1′,’+REC1’) size 100M;

alter database add logfile thread 2 group 8 (‘+DAT1′,’+REC1’) size 100M;

 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: