【rac】实验三：增加日志组成员

最新推荐文章于 2023-08-14 12:36:34 发布
最新推荐文章于 2023-08-14 12:36:34 发布
阅读量335 收藏
点赞数

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

[oracle@rac1 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 29 19:21:59 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>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          1 INACTIVE                 50

         2          1          1 INACTIVE                 50

         3          2          1 INACTIVE                 50

         4          2          1 INACTIVE                 50

         5          1          1 CURRENT                  50

         6          1          1 INACTIVE                 50

         7          2          1 CURRENT                  50

         8          2          1 INACTIVE                 50

 

8 rows selected.

 

SYS@RACDB1>col  member for a45;

SYS@RACDB1>select group#,member,status from v$logfile;

 

    GROUP# MEMBER                                        STATUS

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

         1 +DATA/racdb/onlinelog/group_1.267.926536571

         2 +DATA/racdb/onlinelog/group_2.262.926536585

         3 +DATA/racdb/onlinelog/group_3.266.926536603

         4 +DATA/racdb/onlinelog/group_4.261.926536613

         5 +DATA/racdb/onlinelog/group_5.272.926535655

         6 +DATA/racdb/onlinelog/group_6.269.926535221

         7 +DATA/racdb/onlinelog/group_7.270.926535251

         8 +DATA/racdb/onlinelog/group_8.271.926535323

 

8 rows selected.

 

2. 增加日志组成员

——查看日志位置：

[grid@rac1 ~]$ asmcmd

ASMCMD> ls

DATA/

FRA/

OCR/

ASMCMD> cd data

ASMCMD> ls

RACDB/

ASMCMD> cd racdb

ASMCMD> ls

CONTROLFILE/

DATAFILE/

ONLINELOG/

PARAMETERFILE/

TEMPFILE/

spfileRACDB.ora

ASMCMD> cd onlinelog

ASMCMD> ls

group_1.267.926536571

group_2.262.926536585

group_3.266.926536603

group_4.261.926536613

group_5.272.926535655

group_6.269.926535221

group_7.270.926535251

group_8.271.926535323

ASMCMD>

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo01_a.log' to group 1;

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo02_a.log' to group 2;

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo03_a.log' to group 3; 

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo04_a.log' to group 4; 

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo05_a.log' to group 5; 

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo06_a.log' to group 6;  

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo07_a.log' to group 7;

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+data/racdb/onlinelog/redo08_a.log' to group 8;

 

Database altered.

 

SYS@RACDB1>alter database add logfile member '+fra/racdb/onlinelog/redo01_b.log' to group 1;

alter database add logfile member '+fra/racdb/onlinelog/redo02_b.log' to group 2;

alter database add logfile member '+fra/racdb/onlinelog/redo03_b.log' to group 3;

alter database add logfile member '+fra/racdb/onlinelog/redo04_b.log' to group 4;

alter database add logfile member '+fra/racdb/onlinelog/redo05_b.log' to group 5;

alter database add logfile member '+fra/racdb/onlinelog/redo06_b.log' to group 6;

alter database add logfile member '+fra/racdb/onlinelog/redo07_b.log' to group 7;

alter database add logfile member '+fra/racdb/onlinelog/redo08_b.log' to group 8;

 

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

——查看日志组成员：

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          3 INACTIVE                 50

         2          1          3 INACTIVE                 50

         3          2          3 INACTIVE                 50

         4          2          3 INACTIVE                 50

         5          1          3 CURRENT                  50

         6          1          3 INACTIVE                 50

         7          2          3 CURRENT                  50

         8          2          3 INACTIVE                 50

 

8 rows selected.

 

SYS@RACDB1>select GROUP#,MEMBER,STATUS from v$logfile;

 

    GROUP# MEMBER                                        STATUS

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

         1 +DATA/racdb/onlinelog/group_1.267.926536571

         2 +DATA/racdb/onlinelog/group_2.262.926536585

         3 +DATA/racdb/onlinelog/group_3.266.926536603

         4 +DATA/racdb/onlinelog/group_4.261.926536613

         1 +DATA/racdb/onlinelog/redo01_a.log            INVALID

         2 +DATA/racdb/onlinelog/redo02_a.log            INVALID

         3 +DATA/racdb/onlinelog/redo03_a.log            INVALID

         4 +DATA/racdb/onlinelog/redo04_a.log            INVALID

         5 +DATA/racdb/onlinelog/group_5.272.926535655

         6 +DATA/racdb/onlinelog/group_6.269.926535221

         7 +DATA/racdb/onlinelog/group_7.270.926535251

 

    GROUP# MEMBER                                        STATUS

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

         8 +DATA/racdb/onlinelog/group_8.271.926535323

         5 +DATA/racdb/onlinelog/redo05_a.log            INVALID

         6 +DATA/racdb/onlinelog/redo06_a.log            INVALID

         7 +DATA/racdb/onlinelog/redo07_a.log            INVALID

         8 +DATA/racdb/onlinelog/redo08_a.log            INVALID

         1 +FRA/racdb/onlinelog/redo01_b.log             INVALID

         2 +FRA/racdb/onlinelog/redo02_b.log             INVALID

         3 +FRA/racdb/onlinelog/redo03_b.log             INVALID

         4 +FRA/racdb/onlinelog/redo04_b.log             INVALID

         5 +FRA/racdb/onlinelog/redo05_b.log             INVALID

         6 +FRA/racdb/onlinelog/redo06_b.log             INVALID

 

    GROUP# MEMBER                                        STATUS

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

         7 +FRA/racdb/onlinelog/redo07_b.log             INVALID

         8 +FRA/racdb/onlinelog/redo08_b.log             INVALID

 

24 rows selected.

 

3. 删除日志组成员
3.1. 什么情况无法删除日志成员
有以下两种情况无法删除：
1) 状态为 CURRENT 的日志组成员；
2) 日志组成员的状态为 INVALID 的。
3.2. 查看日志组成员状态

SYS@RACDB1>select GROUP#,MEMBER,STATUS from v$logfile order by 2;

 

    GROUP# MEMBER                                        STATUS

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

         1 +DATA/racdb/onlinelog/group_1.267.926536571

         2 +DATA/racdb/onlinelog/group_2.262.926536585

         3 +DATA/racdb/onlinelog/group_3.266.926536603

         4 +DATA/racdb/onlinelog/group_4.261.926536613

         5 +DATA/racdb/onlinelog/group_5.272.926535655

         6 +DATA/racdb/onlinelog/group_6.269.926535221

         7 +DATA/racdb/onlinelog/group_7.270.926535251

         8 +DATA/racdb/onlinelog/group_8.271.926535323

         1 +DATA/racdb/onlinelog/redo01_a.log            INVALID

         2 +DATA/racdb/onlinelog/redo02_a.log            INVALID

         3 +DATA/racdb/onlinelog/redo03_a.log            INVALID

 

    GROUP# MEMBER                                        STATUS

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

         4 +DATA/racdb/onlinelog/redo04_a.log            INVALID

         5 +DATA/racdb/onlinelog/redo05_a.log            INVALID

         6 +DATA/racdb/onlinelog/redo06_a.log            INVALID

         7 +DATA/racdb/onlinelog/redo07_a.log            INVALID

         8 +DATA/racdb/onlinelog/redo08_a.log            INVALID

         1 +FRA/racdb/onlinelog/redo01_b.log             INVALID

         2 +FRA/racdb/onlinelog/redo02_b.log             INVALID

         3 +FRA/racdb/onlinelog/redo03_b.log             INVALID

         4 +FRA/racdb/onlinelog/redo04_b.log             INVALID

         5 +FRA/racdb/onlinelog/redo05_b.log             INVALID

         6 +FRA/racdb/onlinelog/redo06_b.log             INVALID

 

    GROUP# MEMBER                                        STATUS

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

         7 +FRA/racdb/onlinelog/redo07_b.log             INVALID

         8 +FRA/racdb/onlinelog/redo08_b.log             INVALID

 

24 rows selected.

 

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          3 INACTIVE                 50

         2          1          3 INACTIVE                 50

         3          2          3 INACTIVE                 50

         4          2          3 INACTIVE                 50

         5          1          3 CURRENT                  50

         6          1          3 INACTIVE                 50

         7          2          3 CURRENT                  50

         8          2          3 INACTIVE                 50

 

8 rows selected.

3.3. 切换日志组
通过切换日志组使日志成员的状态为空（也就是有效），每个节点有几组日志， 就切换几次即可
1) 一节点切换 4 次

SYS@RACDB1>alter system switch logfile;

 

System altered.

 

SYS@RACDB1>/

 

System altered.

 

SYS@RACDB1>/

 

System altered.

 

SYS@RACDB1>/

 

System altered.

 

2) 二节点切换 4 次

SYS@RACDB2>alter system switch logfile;

 

System altered.

 

SYS@RACDB2>/

 

System altered.

 

SYS@RACDB2>/

 

System altered.

 

SYS@RACDB2>/

 

System altered.

 

3) 查看切换后日志组成员的状态

SYS@RACDB1>select GROUP#,MEMBER,STATUS from v$logfile order by 2;

 

    GROUP# MEMBER                                        STATUS

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

         1 +DATA/racdb/onlinelog/group_1.267.926536571

         2 +DATA/racdb/onlinelog/group_2.262.926536585

         3 +DATA/racdb/onlinelog/group_3.266.926536603

         4 +DATA/racdb/onlinelog/group_4.261.926536613

         5 +DATA/racdb/onlinelog/group_5.272.926535655

         6 +DATA/racdb/onlinelog/group_6.269.926535221

         7 +DATA/racdb/onlinelog/group_7.270.926535251

         8 +DATA/racdb/onlinelog/group_8.271.926535323

         1 +DATA/racdb/onlinelog/redo01_a.log

         2 +DATA/racdb/onlinelog/redo02_a.log

         3 +DATA/racdb/onlinelog/redo03_a.log

 

    GROUP# MEMBER                                        STATUS

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

         4 +DATA/racdb/onlinelog/redo04_a.log

         5 +DATA/racdb/onlinelog/redo05_a.log

         6 +DATA/racdb/onlinelog/redo06_a.log

         7 +DATA/racdb/onlinelog/redo07_a.log

         8 +DATA/racdb/onlinelog/redo08_a.log

         1 +FRA/racdb/onlinelog/redo01_b.log

         2 +FRA/racdb/onlinelog/redo02_b.log

         3 +FRA/racdb/onlinelog/redo03_b.log

         4 +FRA/racdb/onlinelog/redo04_b.log

         5 +FRA/racdb/onlinelog/redo05_b.log

         6 +FRA/racdb/onlinelog/redo06_b.log

 

    GROUP# MEMBER                                        STATUS

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

         7 +FRA/racdb/onlinelog/redo07_b.log

         8 +FRA/racdb/onlinelog/redo08_b.log

 

24 rows selected.

 

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          3 INACTIVE                 50

         2          1          3 INACTIVE                 50

         3          2          3 INACTIVE                 50

         4          2          3 INACTIVE                 50

         5          1          3 CURRENT                  50

         6          1          3 INACTIVE                 50

         7          2          3 CURRENT                  50

         8          2          3 INACTIVE                 50

 

8 rows selected.

 

3.4. 删除非 CURRENT 状态的日志组成员
1) 通过前面的查询我们知道，日志组 5 和 7 的状态为 CURRENT

SYS@RACDB1> alter database drop logfile member '+DATA/racdb/onlinelog/group_1.267.926536571';   

 alter database drop logfile member '+DATA/racdb/onlinelog/group_2.262.926536585';    

 alter database drop logfile member '+DATA/racdb/onlinelog/group_3.266.926536603';    

 

Database altered.

 

SYS@RACDB1> alter database drop logfile member '+DATA/racdb/onlinelog/group_4.261.926536613';    

 alter database drop logfile member '+DATA/racdb/onlinelog/group_6.269.926535221';    

 

Database altered.

 

SYS@RACDB1> alter database drop logfile member '+DATA/racdb/onlinelog/group_8.271.926535323';   

                                                                                     

 

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

SYS@RACDB1>

Database altered.

 

——查看日志状态：

SYS@RACDB1>select GROUP#,MEMBER,STATUS from v$logfile order by 2;

 

    GROUP# MEMBER                                        STATUS

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

         5 +DATA/racdb/onlinelog/group_5.272.926535655

         7 +DATA/racdb/onlinelog/group_7.270.926535251

         1 +DATA/racdb/onlinelog/redo01_a.log

         2 +DATA/racdb/onlinelog/redo02_a.log

         3 +DATA/racdb/onlinelog/redo03_a.log

         4 +DATA/racdb/onlinelog/redo04_a.log

         5 +DATA/racdb/onlinelog/redo05_a.log

         6 +DATA/racdb/onlinelog/redo06_a.log

         7 +DATA/racdb/onlinelog/redo07_a.log

         8 +DATA/racdb/onlinelog/redo08_a.log

         1 +FRA/racdb/onlinelog/redo01_b.log

 

    GROUP# MEMBER                                        STATUS

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

         2 +FRA/racdb/onlinelog/redo02_b.log

         3 +FRA/racdb/onlinelog/redo03_b.log

         4 +FRA/racdb/onlinelog/redo04_b.log

         5 +FRA/racdb/onlinelog/redo05_b.log

         6 +FRA/racdb/onlinelog/redo06_b.log

         7 +FRA/racdb/onlinelog/redo07_b.log

         8 +FRA/racdb/onlinelog/redo08_b.log

 

18 rows selected.

 

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          2 INACTIVE                 50

         2          1          2 INACTIVE                 50

         3          2          2 INACTIVE                 50

         4          2          2 INACTIVE                 50

         5          1          3 CURRENT                  50

         6          1          2 INACTIVE                 50

         7          2          3 CURRENT                  50

         8          2          2 INACTIVE                 50

 

8 rows selected.

 

2) 切换日志组
——节点一切换 1 次

SYS@RACDB1>alter system switch logfile;

 

System altered.

——节点二切换 1 次

SYS@RACDB2>alter system switch logfile;

 

System altered.

 

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          2 INACTIVE                 50

         2          1          2 INACTIVE                 50

         3          2          2 INACTIVE                 50

         4          2          2 INACTIVE                 50

         5          1          3 ACTIVE                   50

         6          1          2 CURRENT                  50

         7          2          3 INACTIVE                 50

         8          2          2 CURRENT                  50

 

8 rows selected.

 

——节点一进行归档：

SYS@RACDB1>alter system checkpoint;

 

System altered.

 

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          2 INACTIVE                 50

         2          1          2 INACTIVE                 50

         3          2          2 INACTIVE                 50

         4          2          2 INACTIVE                 50

         5          1          3 INACTIVE                 50

         6          1          2 CURRENT                  50

         7          2          3 INACTIVE                 50

         8          2          2 CURRENT                  50

 

8 rows selected.

 

3）最后删除 5号日志组和7号日志组的成员

SYS@RACDB1> alter database drop logfile member '+DATA/racdb/onlinelog/group_5.272.926535655';  

 alter database drop logfile member '+DATA/racdb/onlinelog/group_7.270.926535251'; 

 

Database altered.

 

SYS@RACDB1>

Database altered.

4) 验证

SYS@RACDB1>select group#,thread#,members,status,bytes/1024/1024 size_m from v$log;

 

    GROUP#    THREAD#    MEMBERS STATUS               SIZE_M

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

         1          1          2 INACTIVE                 50

         2          1          2 INACTIVE                 50

         3          2          2 INACTIVE                 50

         4          2          2 INACTIVE                 50

         5          1          2 INACTIVE                 50

         6          1          2 CURRENT                  50

         7          2          2 INACTIVE                 50

         8          2          2 CURRENT                  50

 

8 rows selected.

 

SYS@RACDB1>select GROUP#,MEMBER,STATUS from v$logfile order by 2;

 

    GROUP# MEMBER                                        STATUS

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

         1 +DATA/racdb/onlinelog/redo01_a.log

         2 +DATA/racdb/onlinelog/redo02_a.log

         3 +DATA/racdb/onlinelog/redo03_a.log

         4 +DATA/racdb/onlinelog/redo04_a.log

         5 +DATA/racdb/onlinelog/redo05_a.log

         6 +DATA/racdb/onlinelog/redo06_a.log

         7 +DATA/racdb/onlinelog/redo07_a.log

         8 +DATA/racdb/onlinelog/redo08_a.log

         1 +FRA/racdb/onlinelog/redo01_b.log

         2 +FRA/racdb/onlinelog/redo02_b.log

         3 +FRA/racdb/onlinelog/redo03_b.log

 

    GROUP# MEMBER                                        STATUS

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

         4 +FRA/racdb/onlinelog/redo04_b.log

         5 +FRA/racdb/onlinelog/redo05_b.log

         6 +FRA/racdb/onlinelog/redo06_b.log

         7 +FRA/racdb/onlinelog/redo07_b.log

         8 +FRA/racdb/onlinelog/redo08_b.log

 

16 rows selected.

 


来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31397003/viewspace-2128193/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31397003/viewspace-2128193/

congjiu2607
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RAC 增加日志文件.txt
04-12
oracle rac增加日志文件
oracle rac添加日志组,【rac】实验四：增加日志组
weixin_39587029的博客
04-04 747
1.准备工作1.1.查看日志组基本情况[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production onSat Oct 29 18:46:28 2016Copyright (c) 1982, 2013, Oracle.All rights reserved.Connected to:Oracle Databa...
【rac】实验四：增加日志组
congjiu2607的博客
11-09 188
1. 准备工作 1.1. 查看日志组基本情况 [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 P...
oracle rac 添加日志,【ORACLE RAC】日志组管理
weixin_35098081的博客
04-06 645
************************************************************************ ****原文： blog.csdn.net/clark_xu 徐长亮的专栏 ************************************************************************ rac需要至少需要四个日志组，分...
Oracle 11g rac asm 添加删除日志组（修改日志组大小）
viviliving的专栏
01-19 584
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 ---------- ---------- ------...
ORACLE 11G RAC 增加日志组及增大日志文件
qq961573863的博客
06-16 1494
1、查看目前日志组和日志文件情况 SQL> select * from v$logfile order by 1; GROUP# STATUS TYPE MEMBER IS_ 1 ONLINE +FRA/stone/onlinelog/group_1.257.884819615 YES 1 ONLINE +DATA/stone/on
oracle RAC集群开启归档日志.docx
09-23
Oracle RAC 集群开启归档日志 Oracle RAC 集群开启归档日志是指在 Oracle RAC 集群环境中启用归档日志功能，以便提高数据库的可靠性和可维护性。为了实现这一功能，需要修改集群参数文件，重启数据库。 在开启归档...
RAC_Demo:RAC的基本使用和项目实践
05-01
RAC_Demo // 为了实现高聚合，低耦合的编程思想而封装的扩展类 // 例如在响应事件处理业务逻辑的时候用到的action、delegate、KVO、callback等都可以通过RAC来处理. // Signal信号是数据流,类似水龙头,数据都是线性...
oracle RAC集群修改归档日志路径.docx
09-23
oracle RAC集群修改归档日志路径，更改完成后续重启服务
RAC_Networking:AFN+RAC封装的网络请求类
05-02
在iOS开发中，网络请求是应用与服务器交互的基础，`RAC_Networking`是一个基于`AFNetworking`和`ReactiveCocoa (RAC)`框架封装的网络请求库。这个库的目标是提供一种更加简洁、易用且反应式的网络请求方式，通过结合...
Oracle 增加重做日志组、组成员
最新发布
dale
08-14 1097
Oracle 增加重做日志组、组成员
kafka日志清理配置
wangzhicheng2013的专栏
09-14 930
server.properties log.cleanup.policy=delete #清理日志 log.retention.hours=1 #日志保留1h，1h后删除日志 log.segment.bytes=104857600 #日志的segment保留100M log.retention.check.interval.ms=30000 #5分钟检测日志情况
『ORACLE』RAC—增删日志组成员（11g）
OFF-LINE
05-17 498
SYS@RACDB1 rac1>select group#,member,status from v$logfile order by 2; GROUP#   MEMBER                                                                           STATUS ---------- ---------------
添加日志组成员oracle,增加日志组和日志成员。
weixin_33531560的博客
04-02 297
近日，测试库里频繁出现Thread 1 cannot allocate new log, sequence 298Private strand flush not complete报警。在网络上走马观花的看了看，似乎是日志组数量和容量太小。遂准备增加和改变其容量。1、增加日志组：alter database add logfile group 4 '/oradata/oracle/oradata/...
oracle rac添加日志组,『ORACLE』RAC—增删日志组成员
weixin_32546235的博客
04-04 274
[emailprotected] rac1>select group#,member,status from v$logfile order by 2;GROUP# MEMBER STATUS---------- -------------...
oracle添加删除重做日志成员
龙神add-走向数据架构师的路
07-10 938
1.添加新的重做日志成员的语法: alter database [数据库] add logfile member ['文件名' [reuse][,'文件名'] [reuse]].. to {group 正整数} 2.添加日志成员的实例: SQL> alter database add logfile member   2  '/oradata/law/law/redo01a.log't
oracle如何增加日志组,Oracle增加日志组，日志成员的一些命令
weixin_29935511的博客
04-10 3781
Oracle 增加日志组，日志成员的一些命令2012-05-14 13:421、增加日志组： alter database add logfile group 4Oracle 增加日志组，日志成员的一些命令2012-05-14 13:421、增加日志组：alter database add logfile group 4 '/oradata/oracle/oradata/oracle_sid/re...
RAC 中日志组的添加、删除、和修改
热门推荐
瀚宇的技术之路
02-26 1万+
策略：每个组的日志大小默认是50M每个，如果写入或者更新很频繁的库，建议改大日志文件的大小。 每个日志组最好要有两个以上的成员。 ---------- select * from v$log ; select * from v$logfile ; -------- ------ ---删除日志组： alter database drop logfile group 19; alt
oracle rac添加日志组,Oracle配置多路复用在线日志组的方法
weixin_31951365的博客
04-04 281
发布时间：2016-08-08 10:00:17目的：添加多路复用在线日志组1.添加成员至4号在线日志组alter database add logfile member '/arp/oraarp/oradata/arpdb/redo041.log' to group 4;2.查看在线日志组日志位置column MEMBER format a20;set linesize 200;SQL> ...
Oracle 19C RAC on linux 7.6
02-06
Oracle 19C RAC on linux 7.6

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值