第12次活动：2017-08-26（星期六晚上7:00-10:00）

botang

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

复制代码

1. run {
   
2. set newname for datafile 1 to '/u01/app/oracle/oradata/orcl/system01.dbf';
   
3. set newname for datafile 2 to '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
   
4. set newname for datafile 3 to '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
   
5. set newname for datafile 4 to '/u01/app/oracle/oradata/orcl/users01.dbf';
   
6. set newname for datafile 5 to '/u01/app/oracle/oradata/orcl/example01.dbf';
   
7. set newname for datafile 6 to '/u01/app/oracle/oradata/orcl/tbsocp05_test.dbf';
   
8. restore database;
   
9. recover database;
   
10. 
    
11. }
    
12. switch database to copy;
    
13. 
    

复制代码

1. run{
   
2. allocate channel c1 device type disk;
   
3. allocate channel c2 device type disk;
   
4. allocate channel c3 device type disk;
   
5. allocate channel c4 device type disk;
   
6. allocate channel c5 device type disk;
   
7. allocate channel c6 device type disk;
   
8. allocate channel c7 device type disk;
   
9. allocate channel c8 device type disk;
   
10. backup as copy datafile 1 format '/u01/app/oracle/oradata/orcl/system01.dbf';
    
11. backup as copy datafile 2 format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
    
12. backup as copy datafile 3 format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
    
13. backup as copy datafile 4 format '/u01/app/oracle/oradata/orcl/users01.dbf';
    
14. backup as copy datafile 5 format '/u01/app/oracle/oradata/orcl/example01.dbf';
    
15. backup as copy datafile 6 format '/u01/app/oracle/oradata/orcl/tbsocp05_test.dbf';
    
16. 
    
17. release channel c1;
    
18. release channel c2;
    
19. release channel c3;
    
20. release channel c4;
    
21. release channel c5;
    
22. release channel c6;
    
23. release channel c7;
    
24. release channel c8;
    
25. }
    
26. 
    
27. switch database to copy;
    

复制代码