源库 | 目标库 | |
---|---|---|
操作系统 | win7 | win svr 2012 r2 |
ip | x.x.x.216 | x.x.x.112 |
数据库版本 | 10.2.0.4.0 - 64bi | 10.2.0.4.0 - 64bi |
存储方式 | 单实例 | 单实例 |
oracle_home | d:\oracle\product\10.2.0\db_1 | d:\oracle\product\10.2.0\db_1 |
oracle_sid | orcl | orcl |
验证结果
rman target / sql'alter system switch logfile'; sql'alter system checkpoint'; shutdown immediate; startup mount;
sqlplus / as sysdba select dbid from v$database;
run{ allocate channel d1 type disk; allocate channel d2 type disk; backup as compressed backupset database; release channel d1; release channel d2; report obsolete; crosscheck backup; delete noprompt expired backup; delete noprompt obsolete; }
backup spfile; backup current controlfile;
db_name=orcl java_pool_size=4194304 large_pool_size=4194304 shared_pool_size=96468992
startup pfile='d:\oracle\product\10.2.0\db_1\database\fakespfileorcl.ora' nomount;
set dbid=1526707455;
restore spfile from 'd:\oracle\product\10.2.0\flash_recovery_area\orcl\backupset\2019_01_30\o1_mf_nnsnf_tag20190130t171134_g52tl81y_.bkp';
shutdown immediate; startup nomount;
restore controlfile from 'd:\oracle\product\10.2.0\flash_recovery_area\orcl\backupset\2019_01_30\o1_mf_ncnnf_tag20190130t171148_g52tlns2_.bkp';
shutdown immediate; startup mount;
report schema;
run{ set newname for datafile 8 to 'd:\oracledata1\info_lob'; restore database; switch datafile all; }
alter database open resetlogs;
select sid,serial# ,context,sofar,totalwork,round(sofar/totalwork*100,2) "_%" from v$session_longops where opname like 'rman%' and sofar<>totalwork and totalwork<>0;
如对本文有疑问, 点击进行留言回复!!
【Oracle】Oracle11.2.0.4迁移到oracle12.2.0.1-原服务器上新装12c+expdp
荐 Oracle Data Guard(三)Oracle Data Guard补充技术
Windows10安装Oracle19c数据库详细记录(图文详解)
Oracle用decode函数或CASE-WHEN实现自定义排序
Oracle利用errorstack追踪tomcat报错ORA-00903 无效表名的问题
网友评论