oracle rac添加日志组,【rac】实验四：增加日志组

1.准备工作1.1.查看日志组基本情况

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on

Sat Oct 29 18:46:28 2016

Copyright (c) 1982, 2013, Oracle.All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition

Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application

Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing

options

SYS@RACDB1>

SYS@RACDB1>select

group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

GROUP#THREAD#MEMBERS STATUSSIZE_M

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

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

112 CURRENT50

212 INACTIVE50

322 INACTIVE50

422 CURRENT50

1.2.查看日志成员路径

SYS@RACDB1>col member for a50

SYS@RACDB1>select group#,member from

v$logfile order by 1;

GROUP# MEMBER

----------

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

1 +FRA/racdb/onlinelog/group_1.257.926529029

1 +DATA/racdb/onlinelog/group_1.261.926529029

2 +FRA/racdb/onlinelog/group_