课程第8/9/10次（2017-07-15星期六晚上和2017-07-17星期一和2017-07-19星期三）

botang

上完1Z0-052第1章
1Z0-052共19章（上完3章），1Z0-053共21章（上完0章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的3章

1. select  * from v$transaction;
   
2.    
   
3.     select  p.spid
   
4.        from v$session s, v$process p
   
5.        where s.paddr=p.addr
   
6.         and s.terminal='pts/2';

复制代码

1. select d.RESETLOGS_CHANGE#,
   
2.            d.CHECKPOINT_CHANGE#,
   
3.            d.CURRENT_SCN
   
4.   from v_$database d;
   
5.   
   
6.   select  * from
   
7.   v$database_incarnation;
   
8.   
   
9.   select  * from v$log;
   
10.   
    
11.   ---1129742
    
12.   
    
13.   select d.RESETLOGS_CHANGE#,
    
14.            d.CHECKPOINT_CHANGE#,
    
15.            d.CURRENT_SCN
    
16.   from v_$database d;
    
17.   
    
18.   select  * from v$datafile;
    
19.   ----
    
20.   select  * from v$log;
    
21.   ---
    
22.   alter system switch logfile;
    
23.   ----

复制代码

检查点查看：

1. incremental checkpoint up to RBA [0x1b.5ff.0], current log tail at RBA [0x1b.759.0]
   
2. Sat Jul 15 20:49:38 2017
   
3. ALTER SYSTEM SET fast_start_mttr_target=3601 SCOPE=BOTH;
   
4. Sat Jul 15 20:59:13 2017
   
5. MTTR advisory was temporarily turned off because FAST_START_MTTR_TARGET was altered.
   
6. ALTER SYSTEM SET fast_start_mttr_target=30 SCOPE=BOTH;
   
7. 
   
8. 
   
9. 
   
10. 
    
11. 
    
12. 
    
13. Sat Jul 15 20:59:24 2017
    
14. Incremental checkpoint up to RBA [0x1b.b5d.0], current log tail at RBA [0x1b.d0f.0]
    
15. 11322309
    
16. 
    
17. 
    
18. 
    
19. 
    
20. 11299999Sat Jul 15 21:16:53 2017
    
21. MTTR advisory was temporarily turned off because FAST_START_MTTR_TARGET was altered.
    
22. ALTER SYSTEM SET fast_start_mttr_target=1 SCOPE=BOTH;
    
23. 
    
24. 
    
25. 
    
26. 
    
27. 
    
28. Sat Jul 15 21:17:11 2017
    
29. FAST_START_MTTR_TARGET 1 is set too low, using minimum achievable MTTR 13 instead.
    
30. Sat Jul 15 21:23:02 2017
    
31. Beginning log switch checkpoint up to RBA [0x1c.2.10], SCN: 1136595
    
32. Thread 1 advanced to log sequence 28 (LGWR switch)
    
33.   Current log# 1 seq# 28 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
    
34.   Current log# 1 seq# 28 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
    
35. Sat Jul 15 21:23:03 2017
    
36. Archived Log entry 19 added for thread 1 sequence 27 ID 0x501b221c dest 1:
    
37. Sat Jul 15 21:28:14 2017
    
38. Completed checkpoint up to RBA [0x1c.2.10], SCN: 1136595
    
39. Sat Jul 15 21:30:30 2017
    
40. Incremental checkpoint up to RBA [0x1c.984.0], current log tail at RBA [0x1c.bbb.0]
    
41. 
    
42. 
    
43. 
    
44. 
    
45. 
    
46. Sat Jul 15 21:36:36 2017
    
47. Thread 1 cannot allocate new log, sequence 29
    
48. Private strand flush not complete
    
49.   Current log# 1 seq# 28 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
    
50.   Current log# 1 seq# 28 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
    
51. Beginning log switch checkpoint up to RBA [0x1d.2.10], SCN: 1137462
    
52. Thread 1 advanced to log sequence 29 (LGWR switch)
    
53.   Current log# 2 seq# 29 mem# 0: +DATA/orcl/onlinelog/group_2.262.816169639
    
54.   Current log# 2 seq# 29 mem# 1: +FRA/orcl/onlinelog/group_2.258.816169639
    
55. Sat Jul 15 21:36:37 2017
    
56. Archived Log entry 20 added for thread 1 sequence 28 ID 0x501b221c dest 1:
    
57. Sat Jul 15 21:41:12 2017
    
58. Completed checkpoint up to RBA [0x1d.2.10], SCN: 1137462
    
59. 
    

复制代码

1. alter system checkpoint;

复制代码

1. Sat Jul 15 21:36:36 2017
   
2. Thread 1 cannot allocate new log, sequence 29
   
3. Private strand flush not complete
   
4.   Current log# 1 seq# 28 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
   
5.   Current log# 1 seq# 28 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
   
6. Beginning log switch checkpoint up to RBA [0x1d.2.10], SCN: 1137462
   
7. Thread 1 advanced to log sequence 29 (LGWR switch)
   
8.   Current log# 2 seq# 29 mem# 0: +DATA/orcl/onlinelog/group_2.262.816169639
   
9.   Current log# 2 seq# 29 mem# 1: +FRA/orcl/onlinelog/group_2.258.816169639
   
10. Sat Jul 15 21:36:37 2017
    
11. Archived Log entry 20 added for thread 1 sequence 28 ID 0x501b221c dest 1:
    
12. Sat Jul 15 21:41:12 2017
    
13. Completed checkpoint up to RBA [0x1d.2.10], SCN: 1137462
    
14. Sat Jul 15 21:45:20 2017
    
15. Thread 1 cannot allocate new log, sequence 30
    
16. Private strand flush not complete
    
17.   Current log# 2 seq# 29 mem# 0: +DATA/orcl/onlinelog/group_2.262.816169639
    
18.   Current log# 2 seq# 29 mem# 1: +FRA/orcl/onlinelog/group_2.258.816169639
    
19. Beginning log switch checkpoint up to RBA [0x1e.2.10], SCN: 1137808
    
20. Thread 1 advanced to log sequence 30 (LGWR switch)
    
21.   Current log# 3 seq# 30 mem# 0: +DATA/orcl/onlinelog/group_3.263.816169641
    
22.   Current log# 3 seq# 30 mem# 1: +FRA/orcl/onlinelog/group_3.259.816169641
    
23. Sat Jul 15 21:45:20 2017
    
24. Archived Log entry 21 added for thread 1 sequence 29 ID 0x501b221c dest 1:
    
25. Sat Jul 15 21:45:40 2017
    
26. Thread 1 cannot allocate new log, sequence 31
    
27. Private strand flush not complete
    
28.   Current log# 3 seq# 30 mem# 0: +DATA/orcl/onlinelog/group_3.263.816169641
    
29.   Current log# 3 seq# 30 mem# 1: +FRA/orcl/onlinelog/group_3.259.816169641
    
30. Beginning log switch checkpoint up to RBA [0x1f.2.10], SCN: 1137817
    
31. Thread 1 advanced to log sequence 31 (LGWR switch)
    
32.   Current log# 1 seq# 31 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
    
33.   Current log# 1 seq# 31 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
    
34. Sat Jul 15 21:45:40 2017
    
35. Archived Log entry 22 added for thread 1 sequence 30 ID 0x501b221c dest 1:
    
36. Sat Jul 15 21:46:37 2017
    
37. Beginning global checkpoint up to RBA [0x1f.13.10], SCN: 1137847
    
38. Completed checkpoint up to RBA [0x1f.13.10], SCN: 1137847
    
39. Completed checkpoint up to RBA [0x1f.2.10], SCN: 1137817
    
40. Completed checkpoint up to RBA [0x1e.2.10], SCN: 1137808
    

复制代码

1. select  * from v$datafile;
   
2. 
   
3. select * from v$backup;
   
4. 
   
5. alter tablespace system begin backup;
   
6. 
   
7. alter system checkpoint;
   
8. 热备份时数据文件文件头被锁了：
   
9. 
   
10. alter tablespace system end backup;
    
11. 
    
12. ----
    
13. 同时有记录特殊的日志（块变化日志）
    
14. 
    
15. select  * from v$datafile;
    
16. 
    
17. alter tablespace   users offline ;
    
18. 
    
19. alter tablespace  example read only;
    
20. 
    
21. ---------
    
22. alter tablespace   users online ;
    
23. 
    
24. alter tablespace example read write ;
    
25. 
    
26. alter tablespace   users offline ;
    
27. 
    
28. 
    
29. alter tablespace  example read only;

复制代码

bclresult-1a.zip (42.45 KB, 下载次数: 515)

2017-7-20 09:56 上传

点击文件名下载附件 bclresult-1b.zip (45.83 KB, 下载次数: 474)

2017-7-20 09:56 上传

点击文件名下载附件 bclresult-1c.zip (35 KB, 下载次数: 443)

2017-7-20 09:56 上传

点击文件名下载附件 bclresult-1d.zip (42.51 KB, 下载次数: 463)

2017-7-20 09:56 上传

点击文件名下载附件 bclresult-3.zip (39.1 KB, 下载次数: 474)

2017-7-20 09:56 上传

点击文件名下载附件 bclresult-4.zip (38.73 KB, 下载次数: 475)

2017-7-20 09:56 上传

点击文件名下载附件