课程第11次（2018-06-12星期二）

botang

关于普通的restore point：

1. select * from v$restore_point;
   
2. 
   
3. create restore point rsp1 ;
   
4. 
   
5. create restore point rsp2 as of scn 1050000;

复制代码

对照时间点不完全恢复的语句：

1. RMAN> run {
   
2. 2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
   
3. 3> set until time '2018-06-12:20:04:50';
   
4. 4> restore database;
   
5. 5> recover database;
   
6. 6> }
   
7. 
   

复制代码

对照日志断点的不完全恢复的语句：

1. RMAN> run {
   
2. 2> set until sequence   5  thread  1;
   
3. 3> restore database;
   
4. 4> recover database;
   
5. 5> }
   

复制代码

书上有错：

1. [oracle@station86 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 12 20:57:17 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017, not open)
   
8. 
   
9. RMAN> list incarnation of database;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. 
    
13. List of Database Incarnations
    
14. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    
15. ------- ------- -------- ---------------- --- ---------- ----------
    
16. 1       1       ORCL     1359978017       PARENT  1          13-AUG-09
    
17. 2       2       ORCL     1359978017       PARENT  754488     22-NOV-13
    
18. 3       3       ORCL     1359978017       ORPHAN  1055998    12-JUN-18
    
19. 4       4       ORCL     1359978017       PARENT  1055998    12-JUN-18
    
20. 5       5       ORCL     1359978017       CURRENT 1058023    12-JUN-18
    
21. 
    
22. RMAN> reset database to incarnation 4;
    
23. 
    
24. database reset to incarnation 4
    
25. 
    
26. RMAN> list incarnation of database;
    
27. 
    
28. 
    
29. List of Database Incarnations
    
30. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    
31. ------- ------- -------- ---------------- --- ---------- ----------
    
32. 1       1       ORCL     1359978017       PARENT  1          13-AUG-09
    
33. 2       2       ORCL     1359978017       PARENT  754488     22-NOV-13
    
34. 3       3       ORCL     1359978017       ORPHAN  1055998    12-JUN-18
    
35. 4       4       ORCL     1359978017       CURRENT 1055998    12-JUN-18
    
36. 5       5       ORCL     1359978017       ORPHAN  1058023    12-JUN-18
    
37. 
    
38. RMAN> flashback database to sequence 5 thread 1 ;
    
39. 
    
40. Starting flashback at 12-JUN-18
    
41. allocated channel: ORA_DISK_1
    
42. channel ORA_DISK_1: SID=68 device type=DISK
    
43. allocated channel: ORA_DISK_2
    
44. channel ORA_DISK_2: SID=130 device type=DISK
    
45. allocated channel: ORA_DISK_3
    
46. channel ORA_DISK_3: SID=194 device type=DISK
    
47. allocated channel: ORA_DISK_4
    
48. channel ORA_DISK_4: SID=6 device type=DISK
    
49. allocated channel: ORA_DISK_5
    
50. channel ORA_DISK_5: SID=70 device type=DISK
    
51. allocated channel: ORA_DISK_6
    
52. channel ORA_DISK_6: SID=131 device type=DISK
    
53. allocated channel: ORA_DISK_7
    
54. channel ORA_DISK_7: SID=195 device type=DISK
    
55. allocated channel: ORA_DISK_8
    
56. channel ORA_DISK_8: SID=7 device type=DISK
    
57. 
    
58. 
    
59. starting media recovery
    
60. 
    
61. archived log for thread 1 with sequence 1 is already on disk as file +FRA/orcl/archivelog/2018_06_12/thread_1_seq_1.308.978640963
    
62. archived log for thread 1 with sequence 2 is already on disk as file +FRA/orcl/archivelog/2018_06_12/thread_1_seq_2.309.978640963
    
63. archived log for thread 1 with sequence 3 is already on disk as file +FRA/orcl/archivelog/2018_06_12/thread_1_seq_3.310.978640973
    
64. archived log for thread 1 with sequence 4 is already on disk as file +FRA/orcl/archivelog/2018_06_12/thread_1_seq_4.311.978640975
    
65. archived log for thread 1 with sequence 5 is already on disk as file +FRA/orcl/archivelog/2018_06_12/thread_1_seq_5.316.978641659
    
66. media recovery complete, elapsed time: 00:00:05
    
67. Finished flashback at 12-JUN-18
    
68. 
    
69. RMAN> list incarnation of database;
    
70. 
    
71. 
    
72. List of Database Incarnations
    
73. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    
74. ------- ------- -------- ---------------- --- ---------- ----------
    
75. 1       1       ORCL     1359978017       PARENT  1          13-AUG-09
    
76. 2       2       ORCL     1359978017       PARENT  754488     22-NOV-13
    
77. 3       3       ORCL     1359978017       ORPHAN  1055998    12-JUN-18
    
78. 4       4       ORCL     1359978017       CURRENT 1055998    12-JUN-18
    
79. 5       5       ORCL     1359978017       ORPHAN  1058023    12-JUN-18
    
80. 
    
81. RMAN> alter database open resetlogs;
    
82. 
    
83. database opened
    
84. 
    
85. RMAN> list incarnation of database;
    
86. 
    
87. 
    
88. List of Database Incarnations
    
89. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    
90. ------- ------- -------- ---------------- --- ---------- ----------
    
91. 1       1       ORCL     1359978017       PARENT  1          13-AUG-09
    
92. 2       2       ORCL     1359978017       PARENT  754488     22-NOV-13
    
93. 3       3       ORCL     1359978017       ORPHAN  1055998    12-JUN-18
    
94. 4       4       ORCL     1359978017       PARENT  1055998    12-JUN-18
    
95. 5       5       ORCL     1359978017       ORPHAN  1058023    12-JUN-18
    
96. 6       6       ORCL     1359978017       CURRENT 1058028    12-JUN-18
    
97. 
    
98. RMAN>
    

复制代码