第24/25/26次：2015-11-27星期五，2015-11-30星期一和2015-12-04星期五

botang

实验8a，8b
实验9a，9b，9c，9d
实验10a，10b，10c，10d

8c_ASM.sql:

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

复制代码

asm.rcv:

1. run {
   
2. allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
   
3. backup as copy datafile 1  ;
   
4. release channel c1;
   
5. allocate channel c2 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
   
6. backup as copy datafile 2;
   
7. release channel c2;
   
8. allocate channel c3 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
   
9. backup as copy datafile 3;
   
10. release channel c3;
    
11. allocate channel c4 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
    
12. backup as copy datafile  4;
    
13. release channel c4;
    
14. allocate channel c5 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
    
15. backup as copy datafile 5;
    
16. release channel c5;
    
17. }
    

复制代码