第12和第13次：2015-01-24上午和下午

botang

1. select  * from v$log;
   
2. 
   
3. select  * from v$logfile;
   
4. 
   
5. alter database add logfile member '/u01/app/oracle/oradata/rcat/redo01b.log' to group 1;
   
6. 
   
7. alter database add logfile member '/u01/app/oracle/oradata/rcat/redo02b.log' to group 2;
   
8. 
   
9. alter database add logfile member '/u01/app/oracle/oradata/rcat/redo03b.log' to group 3;
   
10. 
    
11. alter system switch logfile;
    
12. 
    
13. 
    
14. alter database drop logfile member '/u01/app/oracle/oradata/rcat/redo01.log' ;
    
15. 
    
16. alter database add logfile member '/u01/app/oracle/oradata/rcat/redo01.log' to group 1;

复制代码