源库:Red Hat Enterprise Linux Server release 5.5 (Tikanga) 64bit + ORACLE V11.2.0.4.0 + DG + RAC目标库:Red Hat Enterprise Linux Server rele ...
源库:Red Hat Enterprise Linux Server release 5.5 (Tikanga) 64bit + ORACLE V11.2.0.4.0 + DG + RAC
目标库:Red Hat Enterprise Linux Server release 5.8 (Catthage) 64bit + ORACLE V11.2.0.4.0
1、在目标库,安装好相同版本的oracle数据库,创建同名实例orcl;
数据库实例默认安装路径为:
/u01/app/oracle/oradata/orcl/…
2、查询源库数据文件路径;
Select * from dba_data_files;
如下图所示:数据文件路径为+DATA/standby/datafile/…
3、拷贝源库rman备份文件:
查看源rman备份脚本,内容如下:
run {allocate channel t1 type disk;sql 'alter system archive log current';backup as compressed backupset database format='/mnt/rmanbackup/backup/db_%U';backup current controlfile format='/mnt/rmanbackup/backup/ctl_%U';crosscheck backupset;crosscheck archivelog all;delete expired backup;delete noprompt obsolete;delete archivelog all completed before 'sysdate-60';delete archivelog until time 'sysdate-60';delete backupset completed before 'sysdate-1';release channel t1;}
原标题:异机rman数据不完全恢复
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。