Oracle冷备份的不完全恢复

核心提示： 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

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;