溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
修改之前先備份一下，防止出現意外
create pfile='/home/oracle/0144CISD.ora' from spfile
select group#,thread#,bytes/1024/1024,status from v$log;
alter database add logfile thread 1 group 11 '+DATA' size 1G;
alter database add logfile thread 1 group 12 '+DATA' size 1G;
alter database add logfile thread 1 group 13 '+DATA' size 1G;
alter database add logfile thread 1 group 14 '+DATA' size 1G;
alter database add logfile thread 1 group 15 '+DATA' size 1G;
alter database add logfile thread 2 group 16 '+DATA' size 1G;
alter database add logfile thread 2 group 17 '+DATA' size 1G;
alter database add logfile thread 2 group 18 '+DATA' size 1G;
alter database add logfile thread 2 group 19 '+DATA' size 1G;
alter database add logfile thread 2 group 20 '+DATA' size 1G;
alter system switch logfile;
alter database drop logfile group 1;
alter database drop logfile group 2;
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 group 8;
alter database drop logfile group 9;
alter database drop logfile group 10;
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
