环境信息: 源库 目标库 操作系统 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
源库 | 目标库 | |
---|---|---|
操作系统 | 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:oracleproduct10.2.0db_1 | D:oracleproduct10.2.0db_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:oracleproduct10.2.0db_1databaseFAKESPFILEORCL.ORA' nomount;
set dbid=1526707455;
restore spfile from 'D:oracleproduct10.2.0flash_recovery_areaORCLBACKUPSET2019_01_30O1_MF_NNSNF_TAG20190130T171134_G52TL81Y_.BKP';
shutdown immediate;
startup nomount;
restore controlfile from 'D:oracleproduct10.2.0flash_recovery_areaORCLBACKUPSET2019_01_30O1_MF_NCNNF_TAG20190130T171148_G52TLNS2_.BKP';
shutdown immediate;
startup mount;
report schema;
run{
set newname for datafile 8 to 'D:ORACLEDATA1INFO_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;
--结束END--
本文标题: ORACLE10G非归档模式下RMAN异机迁库
本文链接: https://www.lsjlt.com/news/3587.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0