ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 11g RAC add logfile

Oracle 11g RAC add logfile

原创 Linux操作系统 作者:golden_zhou 时间:2011-03-15 11:02:40 0 删除 编辑

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博客 ” ,链接:http://blog.itpub.net/25198367/viewspace-689553/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    300946