oracle asm加redolog,在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.