在目的机器上oradim -new -sid lei
建立bdump 和udump
注册表添加键oracle_sid ,并修改其值为lei
copy 源机器的full database 备份/archive备份/archive备份之后的归档日志到目的机器的相同目录下
copy 源机器的控制文件自动备份到C:from14下
restore spfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'
restore controlfile from 'C:from14O1_MF_S_764118213_793FY5QG_.BKP'
alter database mount;
此时,请保证源机器的full database 备份/archive备份在相同的目录(相同的目录是指与源端的备份时的目录同名)下
restore database;
recover database;
rman-06054 介质恢复正请求在未知的日志:线程1 seq 8 lowscn 595344
catalog archivelog 'C:from14O1_MF_1_8_793FZSGN_.ARC';
catalog archivelog 'C:from14O1_MF_1_9_793FZX0H_.ARC';
catalog archivelog 'C:from14O1_MF_1_10_793G023X_.ARC';
catalog archivelog 'C:from14O1_MF_1_11_793G024D_.ARC';
catalog archivelog 'C:from14O1_MF_1_12_793G075V_.ARC';
catalog archivelog 'C:from14O1_MF_1_13_793G076C_.ARC';
catalog archivelog 'C:from14O1_MF_1_14_793G0CVC_.ARC';
alter database open resetlogs;
[@more@]