课程第34次（2017-01-06星期五）

botang

上完1Z0-053第4章（RMAN备份的各种选现，加密备份）
（052共19章，053共21章，063多租户共9章，49-20）

[oracle@station90 orclwallet]$ ls
ewallet.p12
[oracle@station90 orclwallet]$ pwd
/u01/app/oracle/orclwallet
[oracle@station90 orclwallet]$

/u01/app/oracle/product/11.2.0/grid/network/admin/sqlnet.ora：

1. ENCRYPTION_WALLET_LOCATION=
   
2. (SOURCE=(METHOD=FILE)(METHOD_DATA=
   
3. (DIRECTORY=/u01/app/oracle/orclwallet/)))
   

复制代码

1. [oracle@station90 admin]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jan 10 16:47:43 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> show all;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. RMAN configuration parameters for database with db_unique_name ORCL are:
    
13. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    
14. CONFIGURE BACKUP OPTIMIZATION ON;
    
15. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
16. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
    
17. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
18. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
19. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
20. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
21. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
    
22. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
    
23. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
    
24. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
25. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
26. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
27. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
    
28. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    

复制代码

CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

1. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
   
2. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
   
3. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
   
4. 
   
5. RMAN>
   

复制代码