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.

ITPub博客

在ASM下增加一个日志组成员