由 webmaster 发布于: 2001-03-02 21:16

ALTER DATABASE [DATABASE] ADD LOGFILE [GROUP integer] filespec [, [GROUP integer] filespec] ...]

You specify the name and location of the members with the file specification . The value of the GROUP parameter can be chosen for each redo log file group.If you omit this parameter , the oracle server generates its value automantically.

由 webmaster 发布于: 2001-03-02 21:18

eg.

ALTER DATABASE ADD LOGFILE ('/DISK3/log3a.rdo','/DISK4/log3b.rdo') size 1M;