在ASM下增加一個日誌組成員

SQL> startup mount;  

ORACLE instance started.

 

Total System Global Area 1207959552 bytes

Fixed Size                  2020456 bytes

Variable Size             318770072 bytes

Database Buffers          872415232 bytes

Redo Buffers               14753792 bytes

Database mounted.

SQL> alter database add logfile member '+DATA1' to group 4;

 

Database altered.

 

SQL> alter database add logfile member '+DATA1' to group 5;

 

Database altered.

 

SQL> alter database add logfile member '+DATA1' to group 6;

 

Database altered.

                     

 

SQL> select group# ,member from v$Logfile order by group#;

 

    GROUP# MEMBER

---------- ----------------------------------------

         4 +DATA1/zhang1/onlinelog/group_4.257.8513

           44213

 

         4 +DATA/zhang1/onlinelog/group_4.264.85119

           4637

 

         5 +DATA/zhang1/onlinelog/group_5.265.85119

           4653

 

         5 +DATA1/zhang1/onlinelog/group_5.258.8513

           44239

 

    GROUP# MEMBER

---------- ----------------------------------------

 

         6 +DATA/zhang1/onlinelog/group_6.266.85119

           4693

 

         6 +DATA1/zhang1/onlinelog/group_6.259.8513

           44267

 

 

6 rows selected.