Oracle冷备份的不完全恢复

核心提示： 4 2005-12-17 16:28:26 2005-12-17 16:28:26 5 2005-12-17 16:28:27 2005-12-17 16:28:27 6 2005-12-17 16:29:12 2005-12-17 16:29:12 7 2005-12-17 16:29:

4 2005-12-17 16:28:26 2005-12-17 16:28:26

5 2005-12-17 16:28:27 2005-12-17 16:28:27

6 2005-12-17 16:29:12 2005-12-17 16:29:12

7 2005-12-17 16:29:49 2005-12-17 16:29:49

8 2005-12-17 16:29:49 2005-12-17 16:29:49

9 2005-12-17 16:30:07 2005-12-17 16:30:07

10 2005-12-17 16:30:09 2005-12-17 16:30:09

11 2005-12-17 16:30:26 2005-12-17 16:30:26

12 2005-12-17 16:30:27 2005-12-17 16:30:27

13 2005-12-17 16:31:04 2005-12-17 16:31:04

14 2005-12-17 16:31:23 2005-12-17 16:31:23

15 2005-12-17 16:31:42 2005-12-17 16:31:42

16 2005-12-17 16:31:56 2005-12-17 16:31:56

17 2005-12-17 16:33:58 2005-12-17 16:33:58

18 2005-12-17 16:34:05 2005-12-17 16:34:05

19 2005-12-17 16:34:10 2005-12-17 16:34:10

20 2005-12-17 16:34:17 2005-12-17 16:34:17

产生scn的历史记录是

select * from V$log_History

1 1 577296464 1 1 982616 2005-12-17 16:04:04 983547

2 2 577296471 1 2 983547 2005-12-17 16:07:44 983552

3 3 577297714 1 3 983552 2005-12-17 16:07:51 985596

4 4 577297760 1 4 985596 2005-12-17 16:28:34 985702

5 5 577297794 1 5 985702 2005-12-17 16:29:20 985822

6 6 577297813 1 6 985822 2005-12-17 16:29:54 985939

7 7 577297835 1 7 985939 2005-12-17 16:30:13 986021

8 8 577297888 1 8 986021 2005-12-17 16:30:35 986145

9 9 577297926 1 9 986145 2005-12-17 16:31:28 986266