课程第12次（2018-06-14星期四）

botang

保障闪回还原点：




如果磁带机没有被oracle certified的话，会报告以下错误（注意：磁带机linux都认识---已经驱动）：

1. RMAN> backup tablespace users;
   
2. 
   
3. Starting backup at 2018-06-14:20:28:16
   
4. RMAN-00571: ===========================================================
   
5. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
6. RMAN-00571: ===========================================================
   
7. RMAN-03002: failure of backup command at 06/14/2018 20:28:16
   
8. ORA-19554: error allocating device, device type: SBT_TAPE, device name:
   
9. ORA-27211: Failed to load Media Management Library
   
10. Additional information: 2
    

复制代码

装Oracle Secure Backup，配置RMAN：

1. RMAN> show all;
   
2. 
   
3. RMAN configuration parameters for database with db_unique_name ORCL are:
   
4. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
   
5. CONFIGURE BACKUP OPTIMIZATION ON;
   
6. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
   
7. CONFIGURE CONTROLFILE AUTOBACKUP ON;
   
8. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
   
9. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
   
10. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
11. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
12. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
13. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
14. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
15. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
16. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
17. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station86)';
    
18. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
19. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
20. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
21. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
22. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
23. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
24. 
    
25. RMAN>
    

复制代码

chenmd

唐老师之前由于出差不知道怎么推环境，能否指导一下呢

chenmd

chenmd 发表于 2018-6-17 08:39
唐老师之前由于出差不知道怎么推环境，能否指导一下呢

571的那个环境

botang

chenmd 发表于 2018-6-17 08:39
571的那个环境

参考一下：https://www.botangdb.com/mytrain/201608/00000010.html
中的OCP部分。