Enlarge redo log files
1. create new log files
su - orabp1sqlplus /nolog
SQL>connect / as sysdba
alter database add logfile group 21 ('/oracle/BP1/origlogA/log_g21_m1.dbf', '/oracle/BP1/mirrlogA/log_g21_m2.dbf') size 500M;
alter database add logfile group 23 ('/oracle/BP1/origlogA/log_g23_m1.dbf', '/oracle/BP1/mirrlogA/log_g23_m2.dbf') size 500M;
alter database add logfile group 22 ('/oracle/BP1/origlogB/log_g22_m1.dbf', '/oracle/BP1/mirrlogB/log_g22_m2.dbf') size 500M;
alter database add logfile group 24 ('/oracle/BP1/origlogB/log_g24_m1.dbf', '/oracle/BP1/mirrlogB/log_g24_m2.dbf') size 500M;
2.Initiate a log switch beforehand alter system switch logfile;
3.delete old redo log files
alter database drop logfile group 11;
alter database drop logfile group 12;
alter database drop logfile group 13;
alter database drop logfile group 14;
沒有留言:
張貼留言