Oracle日誌組新增冗餘檔案和日誌組

kisslfcr發表於2017-09-13
rac中需要指定thread
新增日誌組RAC:
alter database add logfile thread 1 group 1('+DATA/irac/redo01_1.log','+DATA/irac/redo01_2.log') size 1024m;
alter database add logfile thread 1 group 2('+DATA/irac/redo02_1.log','+DATA/irac/redo02_2.log') size 1024m;
單例項:
alter database add logfile group 1('+DATA/irac/redo01_1.log','+DATA/irac/redo01_2.log') size 1024m;

新增日誌檔案,不需要制定size大小:
alter database add logfile member '/u01/app/oracle/oradata/XXX/redo01_b.log' to group 1;
alter database add logfile member '/u01/app/oracle/oradata/XXX/redo02_b.log' to group 2;
alter database add logfile member '/u01/app/oracle/oradata/XXX/redo03_b.log' to group 3;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29135257/viewspace-2144896/,如需轉載,請註明出處,否則將追究法律責任。

相關文章