课程第5/6次

botang

2019-05-15  2019-05-20

1. select  d.RESETLOGS_CHANGE#,
   
2.         d.CHECKPOINT_CHANGE#,
   
3.         d.CURRENT_SCN
   
4. from v_$database  d;
   
5. 
   
6. 
   
7. select  d.CHECKPOINT_CHANGE#, d.NAME
   
8.   from v_$datafile d;
   
9.   
   
10.   
    
11. select  * from v$log;

复制代码

完全检查点：

1. alter system checkpoint;

复制代码

1. Thread 1 cannot allocate new log, sequence 18
   
2. Private strand flush not complete
   
3.   Current log# 2 seq# 17 mem# 0: +DATA/orcl/onlinelog/group_2.262.1008007573
   
4.   Current log# 2 seq# 17 mem# 1: +FRA/orcl/onlinelog/group_2.258.1008007573
   
5. Beginning log switch checkpoint up to RBA [0x12.2.10], SCN: 1068598
   
6. Thread 1 advanced to log sequence 18 (LGWR switch)
   
7.   Current log# 3 seq# 18 mem# 0: +DATA/orcl/onlinelog/group_3.263.1008007575
   
8.   Current log# 3 seq# 18 mem# 1: +FRA/orcl/onlinelog/group_3.259.1008007577
   
9. Thu May 16 04:54:40 2019
   
10. Completed checkpoint up to RBA [0x12.2.10], SCN: 1068598
    
11. Thu May 16 05:00:33 2019
    
12. Thread 1 cannot allocate new log, sequence 19
    
13. Private strand flush not complete
    
14.   Current log# 3 seq# 18 mem# 0: +DATA/orcl/onlinelog/group_3.263.1008007575
    
15.   Current log# 3 seq# 18 mem# 1: +FRA/orcl/onlinelog/group_3.259.1008007577
    
16. Beginning log switch checkpoint up to RBA [0x13.2.10], SCN: 1069527
    
17. Thread 1 advanced to log sequence 19 (LGWR switch)
    
18.   Current log# 1 seq# 19 mem# 0: +DATA/orcl/onlinelog/group_1.261.1008007569
    
19.   Current log# 1 seq# 19 mem# 1: +FRA/orcl/onlinelog/group_1.257.1008007571
    
20. Thu May 16 05:05:45 2019
    
21. Completed checkpoint up to RBA [0x13.2.10], SCN: 1069527
    
22. Thu May 16 05:09:27 2019
    
23. Incremental checkpoint up to RBA [0x13.c86.0], current log tail at RBA [0x13.1141.0]
    
24. 
    
25. 
    
26. 
    
27. Thu May 16 05:39:32 2019
    
28. Incremental checkpoint up to RBA [0x13.1e9b.0], current log tail at RBA [0x13.2416.0]
    
29. Thu May 16 06:09:37 2019
    
30. Incremental checkpoint up to RBA [0x13.3aa5.0], current log tail at RBA [0x13.401b.0]
    
31. Thu May 16 06:26:10 2019
    
32. Beginning global checkpoint up to RBA [0x13.48a7.10], SCN: 1075074
    
33. Completed checkpoint up to RBA [0x13.48a7.10], SCN: 1075074
    

复制代码

部分检查点，又称表空间级检查点：

1. alter tablespace users offline;

复制代码

1. 
   
2. select  d.CHECKPOINT_CHANGE#, d.NAME
   
3.   from v_$datafile d;

复制代码

	CHECKPOINT_CHANGE#	NAME
1	1075074	+DATA/orcl/datafile/system.256.1008007421
2	1075074	+DATA/orcl/datafile/sysaux.257.1008007423
3	1075074	+DATA/orcl/datafile/undotbs1.258.1008007423
4	1075281	+DATA/orcl/datafile/users.259.1008007423
5	1075074	+DATA/orcl/datafile/example.265.1008007585

1. alter system checkpoint;
   

复制代码

1. 
   
2. select  d.CHECKPOINT_CHANGE#, d.NAME
   
3.   from v_$datafile d;
   
4.   

复制代码

	CHECKPOINT_CHANGE#	NAME
1	1075492	+DATA/orcl/datafile/system.256.1008007421
2	1075492	+DATA/orcl/datafile/sysaux.257.1008007423
3	1075492	+DATA/orcl/datafile/undotbs1.258.1008007423
4	1075281	+DATA/orcl/datafile/users.259.1008007423
5	1075492	+DATA/orcl/datafile/example.265.1008007585

1. alter tablespace users online;

复制代码

	CHECKPOINT_CHANGE#	NAME
1	1075492	+DATA/orcl/datafile/system.256.1008007421
2	1075492	+DATA/orcl/datafile/sysaux.257.1008007423
3	1075492	+DATA/orcl/datafile/undotbs1.258.1008007423
4	1075684	+DATA/orcl/datafile/users.259.1008007423
5	1075492	+DATA/orcl/datafile/example.265.1008007585

热备份的查询：

1. select * from v$log;
   
2. 
   
3. alter system switch logfile;
   
4. 
   
5. alter system checkpoint;
   
6. 
   
7. select * from v$datafile;
   
8. 
   
9. select  open_mode from v$database;
   
10. 
    
11. select * from v$backup;

复制代码

1. select * from v$backup;
   
2. 
   
3. select  log_mode from v$database;
   
4. 
   
5. select  * from v$datafile;
   
6. 
   
7. alter tablespace users read only;
   
8. 
   
9. alter system checkpoint;
   
10. 
    
11. alter tablespace users read write;

复制代码