修改之前先备份一下,防止出现意外create pfile='/home/oracle/0144CISD.ora' from spfileselect 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;
oracle++v$log,修改日志组大小 v$log
最新推荐文章于 2021-04-14 13:06:54 发布