添加Redo log Member/Group

		
添加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');
 
						
		
	

上一个：如何重新配置redo log的位置
下一个：oracle-----熟悉基本使用