SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 11 ('+data/ccptdb/onlinelog/redo11a.log','+data/ccptdb/onlinelog/redo11b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 12 ('+data/ccptdb/onlinelog/redo12a.log','+data/ccptdb/onlinelog/redo12b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 13 ('+data/ccptdb/onlinelog/redo13a.log','+data/ccptdb/onlinelog/redo13b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 14 ('+data/ccptdb/onlinelog/redo14a.log','+data/ccptdb/onlinelog/redo14b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 1 group 15 ('+data/ccptdb/onlinelog/redo15a.log','+data/ccptdb/onlinelog/redo15b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 21 ('+data/ccptdb/onlinelog/redo21a.log','+data/ccptdb/onlinelog/redo21b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 22 ('+data/ccptdb/onlinelog/redo22a.log','+data/ccptdb/onlinelog/redo22b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 23 ('+data/ccptdb/onlinelog/redo23a.log','+data/ccptdb/onlinelog/redo23b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 24 ('+data/ccptdb/onlinelog/redo24a.log','+data/ccptdb/onlinelog/redo24b.log') SIZE 50M;
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 group 25 ('+data/ccptdb/onlinelog/redo25a.log','+data/ccptdb/onlinelog/redo25b.log') SIZE 50M;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25198367/viewspace-689553/ ,如需转载,请注明出处,否则将追究法律责任。