课程第28次（2016-12-23星期五）

botang

12c CLOUDCONTROL和12c OCP环境安装（除了最后allroot.sh外其他完毕）

决定能不能做磁带机多份数备份的参数：

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> show parameter tape
   
4. 
   
5. NAME                                     TYPE         VALUE
   
6. ------------------------------------ ----------- ------------------------------
   
7. backup_tape_io_slaves                     boolean         TRUE
   
8. tape_asynch_io                             boolean         TRUE
   

复制代码

以上参数也决定了磁带机异步IO，配置好后IO都显示在：v$backup_async_io里。


rman多份数备份：

1. RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO  2;
   
2. 
   
3. new RMAN configuration parameters:
   
4. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
   
5. new RMAN configuration parameters are successfully stored
   
6. 
   
7. RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 2;
   
8. 
   
9. new RMAN configuration parameters:
   
10. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    
11. new RMAN configuration parameters are successfully stored
    

复制代码

rman多备份片备份：

1. RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
   
2. 
   
3. old RMAN configuration parameters:
   
4. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
   
5. new RMAN configuration parameters:
   
6. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
   
7. new RMAN configuration parameters are successfully stored
   
8. 
   
9. RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
   
10. 
    
11. old RMAN configuration parameters:
    
12. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
13. new RMAN configuration parameters:
    
14. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
15. new RMAN configuration parameters are successfully stored
    
16. 
    
17. RMAN> CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
18. 
    
19. old RMAN configuration parameters:
    
20. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
21. new RMAN configuration parameters:
    
22. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
23. new RMAN configuration parameters are successfully stored
    
24. 
    
25. RMAN> CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
26. 
    
27. old RMAN configuration parameters:
    
28. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
29. new RMAN configuration parameters:
    
30. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
31. new RMAN configuration parameters are successfully stored
    
32. 
    
33. RMAN> CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
34. 
    
35. old RMAN configuration parameters:
    
36. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
37. new RMAN configuration parameters:
    
38. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
39. new RMAN configuration parameters are successfully stored
    
40. 
    
41. RMAN> CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
42. 
    
43. old RMAN configuration parameters:
    
44. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
45. new RMAN configuration parameters:
    
46. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
47. new RMAN configuration parameters are successfully stored
    
48. 
    
49. RMAN> CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
50. 
    
51. old RMAN configuration parameters:
    
52. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
53. new RMAN configuration parameters:
    
54. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
55. new RMAN configuration parameters are successfully stored
    
56. 
    
57. RMAN> CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' maxpiecesize 60M;
    
58. 
    
59. old RMAN configuration parameters:
    
60. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
61. new RMAN configuration parameters:
    
62. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)' MAXPIECESIZE 60 M;
    
63. new RMAN configuration parameters are successfully stored
    
64. 
    

复制代码