首页 > 其他 > 详细

日志格式化

时间:2019-01-24 10:20:07      阅读:155      评论:0      收藏:0      [点我收藏+]

oracle数据库安装,一般需要对日志文件进行日志格式化。



SQL> select group#,status,member from v$Logfile;
+DATA/ORCL/ONLINELOG/group_3.284.979319979

#
alter database add logfile thread 1 group 21(+DATA,+DATA) size 512m;
alter database add logfile thread 1 group 22(+DATA,+DATA) size 512m;
alter database add logfile thread 1 group 23(+DATA,+DATA) size 512m;
alter database add logfile thread 1 group 24(+DATA,+DATA) size 512m;
alter database add logfile thread 1 group 25(+DATA,+DATA) size 512m;


alter database add logfile thread 2 group 31(+DATA,+DATA) size 512m;
alter database add logfile thread 2 group 32(+DATA,+DATA) size 512m;
alter database add logfile thread 2 group 33(+DATA,+DATA) size 512m;
alter database add logfile thread 2 group 34(+DATA,+DATA) size 512m;
alter database add logfile thread 2 group 35(+DATA,+DATA) size 512m;

#


alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;
alter database drop logfile group 7;


alter database drop logfile member /picclife/app/oracle/oradata/cdbdev/redo03.log;

#
 alter system archive log current;
alter system checkpoint;
#RAC
alter system checkpoint global;
/opt/oracle/oradata/filenet/redo03.log alter database add logfile thread 1 group 21(/picclife/app/oracle/oradata/cdbdev/redo21.log) size 512m; alter database add logfile thread 1 group 22(/picclife/app/oracle/oradata/cdbdev/redo22.log) size 512m; alter database add logfile thread 1 group 23(/picclife/app/oracle/oradata/cdbdev/redo23.log) size 512m; alter database add logfile thread 1 group 24(/picclife/app/oracle/oradata/cdbdev/redo24.log) size 512m; alter database add logfile thread 1 group 25(/picclife/app/oracle/oradata/cdbdev/redo25.log) size 512m; alter database add logfile thread 1 group 26(/picclife/app/oracle/oradata/cdbdev/redo26.log) size 512m; -- alter database drop logfile group 4; alter database drop logfile group 5; alter database drop logfile group 6; alter database drop logfile group 7;
查询当前环境日志组状态
select group#,THREAD#,sequence#,bytes/1024/1024,status from v$log;

    GROUP#    THREAD#  SEQUENCE# BYTES/1024/1024 STATUS
---------- ---------- ---------- --------------- --------------------
        71          1     247102            1024 INACTIVE
        72          1     247103            1024 INACTIVE
        73          1     247104            1024 INACTIVE
        74          1     247105            1024 CURRENT
        75          1     247101            1024 INACTIVE
        81          2     257860            1024 CURRENT
        82          2     257856            1024 INACTIVE
        83          2     257857            1024 INACTIVE
        84          2     257858            1024 INACTIVE
        85          2     257859            1024 INACTIVE

10 rows selected.

 

日志格式化

原文:https://www.cnblogs.com/lvcha001/p/10312695.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!