是不是有种可能,从windows克隆到linux上?
-
Source database in Windows - DBName - ORCL (11.2.0.1)
-
Cloned database in Linux - DBName - ORCL (11.2.0.3)
-
-
Step 1 :- 从windows上创建参数文件
-
create pfile='/home/oracle/p.ora' from spfile
-
-
Step 2 :- 关闭windows上库后启动到mount
-
shut immediate
-
startup mount
-
-
Step 3 :- 执行冷备
-
rman target /
-
backup database format 'D:\BAK\full_%U';
-
backup current controlfile format 'd:\bak\control_%U';
-
-
Step 4 :- 将备份片拷贝到linux(这以后就与windows无关了)
-
-
Step 5 :- linux上启动到nomount(注意修改参数)
-
startup nomount pfile='/home/oracle/p.ora';
-
-
Step 6 :- 恢复控制文件
-
restore controlfile from '/bak/CONTROL_A7R4O1B4_1_1';
-
sql 'alter database mount';
-
-
Step 7 :- 校验过期备份
-
crosscheck backup;
-
delete expired backup;
-
-
Step 8 :- 在linux上注册备份
-
catalog backuppiece '/bak';
-
-
Step 9 :- 恢复文件到新位置
-
run {
-
set newname for database to '/u01/oradata/ORCL/datafile_%U';
-
restore database;
-
}
-
switch database to copy;
-
alter database open resetlogs upgrade; --如果同版本不需要upgrade
-
-
Step 10 :- 执行其他升级脚本
参考:
-
Clone Database from Windows To Linux (Lower patchset to Higher) using RMAN (Doc ID 2143991.1)
阅读(428) | 评论(0) | 转发(0) |