第26次：2015-03-26星期四

botang

1. select  * from v$log;
   
2. 
   
3. select * from v$logfile;
   
4. 
   
5. select  * from v$controlfile;
   
6. 
   
7. select  * from v$datafile;
   
8. 
   
9. alter database drop logfile group 2;
   
10. 
    
11. alter database add logfile group 1 '/u01/app/oracle/oradata/orcl/redo01.log' size 50M;
    
12. 
    
13. alter database drop logfile group 3;
    
14. 
    
15. alter database add logfile group 2 '/u01/app/oracle/oradata/orcl/redo02.log' size 50M;
    
16. 
    
17. alter system switch logfile;
    
18. 
    
19. alter system checkpoint;
    
20. 
    
21. alter database drop logfile group 4;
    
22. 
    
23. alter database add logfile group 3 '/u01/app/oracle/oradata/orcl/redo03.log' size 50M;

复制代码