Oracle 增加日志文件大小

来源：互联网发布：淘宝服务市场哪个好用编辑：程序博客网时间：2024/05/20 22:35

########################################################
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

0 0