课程第50/51/52次（2018-10-26星期五、2018-10-29星期一和2018-11-02星期五）

botang

1. [oracle@station11 ~]$ srvctl stop instance -db racdb -node station12  -force
   
2. [oracle@station11 ~]$ srvctl status database -db racdb
   
3. Instance RACDB_2 is running on node station11
   
4. Instance RACDB_1 is not running on node station12
   
5. [oracle@station11 ~]$ srvctl convert database -h
   
6. 
   
7. Convert RAC One Node database to RAC database having one instance.
   
8. 
   
9. Usage: srvctl convert database -db <db_unique_name> -dbtype RAC [-node <node>]
   
10.     -db <db_unique_name>           Unique name of database to convert
    
11.     -dbtype <type>                 Type of database to which to convert: RAC
    
12.     -node <node>                   Candidate server for administrator-managed RAC database to run on
    
13.     -help                          Print usage
    
14. 
    
15. Convert RAC database having one instance to RAC One Node database.
    
16. 
    
17. Usage: srvctl convert database -db <db_unique_name> -dbtype RACONENODE [-instance <inst_name>] [-timeout <timeout>]
    
18.     -db <db_unique_name>           Unique name of database to convert
    
19.     -dbtype <type>                 Type of database to which to convert: RACONENODE
    
20.     -instance <inst_name>          Instance name prefix; required for administrator-managed RAC One Node database
    
21.     -timeout <timeout>             Online relocation timeout in minutes
    
22.     -help                          Print usage
    

复制代码

12c OCMDataguard：

1. DGMGRL> edit database 'prod5h1' set property TransportLagThreshold=30;
   
2. Property "transportlagthreshold" updated
   
3. DGMGRL> edit database 'prod5h2' set property TransportLagThreshold=30;
   
4. Property "transportlagthreshold" updated
   
5. DGMGRL> edit database 'prod5h1' set property ApplyLagThreshold=45;
   
6. Property "applylagthreshold" updated
   
7. DGMGRL> edit database 'prod5h2' set property ApplyLagThreshold=45;
   
8. Property "applylagthreshold" updated
   

复制代码

12c MAA环境（可以在16G内存的笔记本环境中实现）：