[Oracle]Oracle冷备份的不完全恢复

产生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

10 10 577298076 1 10 986266 2005-12-17 16:32:05 986803

11 11 577298200 1 11 986803 2005-12-17 16:34:36 987235

12 12 577298250 1 12 987235 2005-12-17 16:36:40 987465

13 13 577298299 1 13 987465 2005-12-17 16:37:30 987584

14 14 577298317 1 14 987584 2005-12-17 16:38:18 987673

15 15 577298507 1 15 987673 2005-12-17 16:38:37 988309

16 16 577298512 1 16 988309 2005-12-17 16:41:46 988312

17 17 577298515 1 17 988312 2005-12-17 16:41:52 988317

18 18 577298516 1 18 988317 2005-12-17 16:41:55 988320

19 19 577298518 1 19 988320 2005-12-17 16:41:56 988323

20 20 577298528 1 20 988323 2005-12-17 16:41:58 988328

21 21 577298563 1 21 988328 2005-12-17 16:42:08 988445

此时

select checkpoint_change#,archive_change# ,controlfile_change# from v$database;

1 987945 987670 987945

shutdown immediate ;

再次完全冷备份当前的数据文件、控制文件、日志文件,归档日志文件（没有归档日志文件恢复就成了空话）（当不完全恢复不成功或反复使用时使用，这点很重要，在实际你的生产运行数据库恢复时也是要这样。）

恢复：三种方法

基于时间

(alter database ) recover database (automatic) until time ‘2005-12-16 11:09:01’;

(alter database ) recover database (automatic) until time ‘2005-12-16 11:09:01’ using backup controlfile;

基于变更

(alter database ) recover database until change 985822;

(alter database ) recover database until change 985822using backup controlfile;

基于撤销

(alter database ) recover database until cancel ;

(alter database ) recover database until cancel until change 985822using backup