oracle非归档的异机恢复,ORACLE10G非归档模式下RMAN异机迁库，

ORACLE10G非归档模式下RMAN异机迁库，

环境信息：

源库

目标库

操作系统

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恢复思路步骤：

初始化数据库，安装相同环境；

恢复参数文件；

恢复控制文件；

启动数据库到MOUNT状态，利用控制文件进行数据恢复；

restore database;

alter database open ressetlogs;

验证结果

具体恢复步骤：

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;

ps:

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;

http://www.dengb.com/oracle/1388137.htmlwww.dengb.comtruehttp://www.dengb.com/oracle/1388137.htmlTechArticleORACLE10G非归档模式下RMAN异机迁库， 环境信息： 源库 目标库 操作系统 WIN7 WIN SVR 2012 R2 IP x.x.x.216 x.x.x.112 数据库版本 10.2.0.4.0 - 64bi 10.2.0.4....