偶然在網上看到介紹如何增大ORACLE REDO LOG的SIZE
select * from v$log
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
FIRST_CHANGE# FIRST_TIME
alter database drop logfile G:\oracle\oradata\orcl\redo
如果沒有狀態為INACTIVE的
alter system switch logfile;
ALTER SYSTEM CHECKPOINT;
切換完了
select * from v$log;
alter database add logfile group
From:http://tw.wingwit.com/Article/program/Oracle/201311/17453.html