Oracle 增加日志文件大小

最新推荐文章于 2024-07-25 09:13:26 发布

sxj1069425501

最新推荐文章于 2024-07-25 09:13:26 发布

阅读量1.4k

点赞数

分类专栏： ORACLE技术类文章标签： oracle dba 数据库

本文链接：https://blog.csdn.net/songxuejuan/article/details/24016279

版权

ORACLE技术类专栏收录该内容

16 篇文章 0 订阅

订阅专栏

########################################################
alter database add logfile group 4 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_4_96wzryyq_.log' size 100m;
alter database add logfile group 5 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_5_96wzryyq_.log' size 100m;
alter database add logfile group 6 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_6_96wzrzlg_.log' size 100m;

alter system archive log current;
alter system archive log current;
alter system archive log current;

select group#,thread#,members,archived,status from v$log;

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_1_96wzryyq_.log
rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_2_96wzryyq_.log
rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_3_96wzryyq_.log
rm /opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_1_96wzrz9q_.log
rm /opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_2_96wzrz9q_.log
rm /opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_3_96wzrz9q_.log
########################################################################################

alter database add logfile group 1 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_1_96wzryyq_.log' size 100m;
alter database add logfile group 2 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_2_96wzryyq_.log' size 100m;
alter database add logfile group 3 '/opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_3_96wzryyq_.log' size 100m;

alter database add logfile member '/opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_1_96wzrz9q_.log
' to group 1;
alter database add logfile member '/opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_2_96wzrz9q_.log
' to group 2;
alter database add logfile member '/opt/app/oracle/flash_recovery_area/KLDB/onlinelog/o1_mf_3_96wzrz9q_.log
' to group 3;

alter system archive log current;
alter system archive log current;
alter system archive log current;

select group#,thread#,members,archived,status from v$log;

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

rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_4_96wzryyq_.log
rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_5_96wzryyq_.log
rm /opt/app/oracle/oradata/KLDB/onlinelog/o1_mf_6_96wzryyq_.log