log添加 oracle redo_添加Redo log Member/Group-Oracle

添加Redo log Member/Group

1.添加redo log groups

a: ALTER DATABASE ADD LOGFILE

(‘/oracle/dbs/log1c.rdo’,’/oracle/dbs/log2c.rdo’) SIZE 100M;

b:ALTER DATABASE  ADD LOGFILE GROUP 10 (‘/oracle/dbs/log1c.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 100M BLOCKSIZE 512;  ———–个人建议使用这个sql 语句

2.添加redo log member

a:ALTER DATABASE ADD LOGFILE MEMBER ‘/oracle/dbs/log2b.rdo’ TO GROUP 2 ；—————-个人建议使用这个sql语句

b:ALTER DATABASE ADD LOGFILE MEMBER ‘/oracle/dbs/log2c.rdo’ TO (‘/oracle/dbs/log2a.rdo’, ‘/oracle/dbs/log2b.rdo’);