课程第16次（2018-11-15星期四）

botang

日志切换也有增量检查点：

1. Archived Log entry 124 added for thread 1 sequence 132 ID 0x501b221c dest 1:
   
2. 
   
3. 
   
4. 
   
5. 
   
6. Thu Nov 15 19:44:12 2018
   
7. Thread 1 cannot allocate new log, sequence 134
   
8. Checkpoint not complete
   
9.   Current log# 1 seq# 133 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
   
10.   Current log# 1 seq# 133 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
    
11. Thu Nov 15 19:44:13 2018
    
12. Completed checkpoint up to RBA [0x85.2.10], SCN: 2503762
    
13. Completed checkpoint up to RBA [0x84.2.10], SCN: 2503734
    
14. Thread 1 cannot allocate new log, sequence 134
    
15. Private strand flush not complete
    
16.   Current log# 1 seq# 133 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
    
17.   Current log# 1 seq# 133 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
    
18. Beginning log switch checkpoint up to RBA [0x86.2.10], SCN: 2503855
    
19. Thread 1 advanced to log sequence 134 (LGWR switch)
    
20.   Current log# 2 seq# 134 mem# 0: +DATA/orcl/onlinelog/group_2.262.816169639
    
21.   Current log# 2 seq# 134 mem# 1: +FRA/orcl/onlinelog/group_2.258.816169639
    
22. Thu Nov 15 19:44:13 2018
    
23. Archived Log entry 125 added for thread 1 sequence 133 ID 0x501b221c dest 1:
    
24. Thu Nov 15 19:44:57 2018
    

复制代码

1. select d.RESETLOGS_CHANGE#,
   
2.             d.CHECKPOINT_CHANGE#,
   
3.             d.CURRENT_SCN
   
4.     from v_$database  d;
   
5.    
   
6.     select name , checkpoint_change#
   
7.      from v_$datafile df;
   
8.      
   
9.      alter system checkpoint;
   
10.      
    
11.      alter system switch logfile;
    
12.      
    
13.      alter tablespace example offline;
    
14.      
    
15.      alter tablespace example online;
    
16.      
    
17.      select  log_mode from v$database;
    
18.      
    
19.      alter tablespace users begin backup;
    
20.      
    
21.      
    
22.      alter tablespace users end backup;
    
23.      
    
24.      
    
25.      

复制代码

1. select  * from v$thread;
   
2. 
   
3. select  * from v$log;
   
4. 
   
5. alter system switch logfile;
   
6. 
   
7. alter system checkpoint;
   
8. 
   
9. alter database add logfile group 4 size 52428800 ;
   
10. 
    
11. select  * from v$logfile;
    
12. 
    
13. alter database add logfile member '+fra'  to group  2;
    
14. 
    
15. alter database drop logfile member '+FRA/orcl/onlinelog/group_2.301.992295853';
    
16. 
    

复制代码

上完1Z0-052第1章（14/40），1Z0-053第1章（15/40）