Oracle 11g RAC 添加刪除日志組(修改日志組大小)
1.查看日志文件位置
col status for a10
col type for a10
col member for a50
select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_REC
---------- ---------- ---------- -------------------------------------------------- ------
2 ONLINE +DATA/prod/onlinelog/group_2.262.951055519 NO
2 ONLINE +FRC/prod/onlinelog/group_2.258.951055519 YES
1 ONLINE +DATA/prod/onlinelog/group_1.261.951055517 NO
1 ONLINE +FRC/prod/onlinelog/group_1.257.951055517 YES
3 ONLINE +DATA/prod/onlinelog/group_3.265.951055699 NO
3 ONLINE +FRC/prod/onlinelog/group_3.259.951055699 YES
4 ONLINE +DATA/prod/onlinelog/group_4