Oracle 11G RMAN 单实例异机恢复

大佬教程收集整理的这篇文章主要介绍了Oracle 11G RMAN 单实例异机恢复，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

@H_403_1@ 数据备份当然是为数据恢复准备，新环境的Oracle@H_403_1@一直在进行备份@H_403_1@，但都没有测试验证备份的有效性，所以本次测试的重要性@R_886_9772@了！以下为WIN@H_403_1@平台下RMAN@H_403_1@异机恢复实例。

	@H_403_1@源库	@H_403_1@目标库
@H_403_1@操作系统	WIN SVR 2008 R2	WIN SVR 2008 R2
@H_403_1@主机名	Ora	ORATEST
IP	192.168.18.20	192.168.18.25
@H_403_1@数据库版本	11.2.0.1.0	11.2.0.1.0
@H_403_1@存储方式	@H_403_1@单实例	@H_403_1@单实例
OracLE_HOME	D:\app\administrator\product\11.2.0\dbhome_1	D:\app\administrator\product\11.2.0\dbhome_1
@R_944_3528@	HWPROD	HWPROD

@H_403_1@源库备份操作：

@H_403_1@相关备份配置及脚本如下：

RMAN> show all;

db_unique_name @H_403_1@为 HWPROD @H_403_1@的数据库的 RMAN @H_403_1@配置参数为:

CONfigURE RETENTION POliCY TO RECOVERYWINDOW OF 3 DAYS; #@H_403_1@保留备份为3@H_403_1@天

CONfigURE BACKUP OPTIMIZATION OFF; #default

CONfigURE DEFAulT DEVICE TYPE TO disK; #default

CONfigURE CONTROLFILE autoBACKUP ON; #@H_403_1@需要打开自动备份

CONfigURE CONTROLFILE autoBACKUP FORMAT FORDEVICE TYPE disK TO 'e:\data_BACkup\

ctl_%F.bak'; #@H_403_1@指定备份控制文件及参数文件备份路径格式

CONfigURE DEVICE TYPE disK ParaLLEliSM 1BACKUP TYPE TO BACKUPSET; # default

CONfigURE DATAFILE BACKUP copIES FOR DEVICETYPE disK TO 1; # default

CONfigURE ARCHIVELOG BACKUP copIES FORDEVICE TYPE disK TO 1; # default

CONfigURE MAXSETSIZE TO UNliMITED; #default

CONfigURE ENCRYPTION FOR DATABASE OFF; #default

CONfigURE ENCRYPTION ALGORITHM 'AES128'; #default

CONfigURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAulT' OPTIMIZE FOR LOA

D TRUE ; # default

CONfigURE ARCHIVELOG deletION POliCY TONONE; # default

CONfigURE SNAPSHOT CONTROLFILE name TO'D:\APP\adminISTRATOR\PRODUCT\11.2.0\DBHO

@H_786_0@mE_1\DATABASE\SNCFHWPROD.oRA'; # default

full_BACkup.sql

run{

allocate chAnnel d1 type disk;

allocate chAnnel d2 type disk;

BACkup as compressed BACkupset fulldatabase format 'e:\data_BACkup\full_%d_%s_%p_%u_%t.bak';

sql 'alter system archive logcurrent';

BACkup archivelog all format'e:\data_BACkup\log_%d_%s_%p_%u_%t.bak' delete all input;

release chAnnel d1;

release chAnnel d2;

report obsolete;

@R_489_3653@ BACkup;

delete noprompt expired BACkup;

delete noprompt obsolete;

}

full_BACkup.bat

set @R_944_3528@=hwprod

set d=%date:~,4%%date:~5,2%%date:~8,2%

echo=>e:\RMAN_script\log\full_BACkup_%d%.log

RMAN target /cmdfile=e:\RMAN_script\full_BACkup.sqlmsglog=e:\RMAN_script\log\full_BACkup_%d%.log

RMAN@H_403_1@恢复思路步骤：

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

• @H_403_1@恢复参数文件；

• @H_403_1@恢复控制文件；

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

• @H_403_1@查看归档日志备份sequence@H_403_1@；

• Restore �Crecover―alter database open ressetlogs;

• @H_403_1@验证；

• @H_403_1@设置监听

1、@H_403_1@系统安装完成后，安装OracLE@H_403_1@软件，选择只安装软件，并安装与源库相同路径，然后把相关备份文件拷贝到原备份路径，为避免不必要的麻烦，建议设置与源库一致。

2@H_403_1@、建立相关的密码文件，服务，监听器，否则无法连接DB

C:\Users\administrator>D:

D:\>cd D:\app\administrator\product\11.2.0\dbhome_1\BIN

D:\app\administrator\product\11.2.0\dbhome_1\BIN>orapwd file=D:\app\administrato

r\product\11.2.0\dbhome_1\database\pwdhwprod.ora password=Oracle entrIEs=5;

D:\app\administrator\product\11.2.0\dbhome_1\BIN>oradim -new -sID HWPROD -startm

ode m

@H_403_1@实例已创建。

D:\app\administrator\product\11.2.0\dbhome_1\BIN>set @R_944_3528@=HWPROD

D:\app\administrator\product\11.2.0\dbhome_1\BIN>

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s2.51cto.com/wyfs02/M01/92/BF/wKioL1kCqc7QOc1BAABHhlprgvs295.png-wh_500x0-wm_3-wmp_4-s_401558243.png">

D:\app\administrator\product\11.2.0\dbhome_1\BIN>sqlplus/ as sysdba

sql*Plus: Release 11.2.0.1.0 Production on @H_403_1@星期五 4@H_403_1@月 21 14:19:482017

copyright (C) 1982,2010,Oracle. All rights reserved.

@H_403_1@已连接到空闲例程。

sql>

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s4.51cto.com/wyfs02/M00/92/BF/wKioL1kCqhnStZLCAAAw976cjSY886.png-wh_500x0-wm_3-wmp_4-s_4034308860.png">

@H_403_1@此时可以连接到DB@H_403_1@了。

3@H_403_1@、手动建立一个pfile@H_403_1@文件，放到D:\app\administrator\product\11.2.0\dbhome_1\database@H_403_1@目录下，inithwprod.ora@H_403_1@内容如下：

db_name=HWPROD

java_pool_size=4194304

large_pool_size=4194304

shared_pool_size=96468992

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s4.51cto.com/wyfs02/M02/92/C0/wKiom1kCqlPzsnnhAAAochqfGro724.png-wh_500x0-wm_3-wmp_4-s_3779173267.png">

@H_403_1@以此pfile@H_403_1@启动数据库到nomount@H_403_1@状态：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s2.51cto.com/wyfs02/M01/92/BF/wKioL1kCqqWCHAsNAABGZ5PeOje703.png-wh_500x0-wm_3-wmp_4-s_2114927293.png">

sql> startuppfile='D:\app\administrator\product\11.2.0\dbhome_1\database\inithw

prod.ora' nomount;

OracLE @H_403_1@例程已经启动。

@R_215_10586@l System Global Area 162873344 bytes

Fixed Size 2173800 bytes

Variable Size 104858776 bytes

Database Buffers 50331648 bytes

Redo Buffers 5509120 bytes

4@H_403_1@、切换到RMAN@H_403_1@下，并SETDBID=3279461817@H_403_1@（源库DBID@H_403_1@），恢复spfile@H_403_1@文件：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" style="float:none;" src="https://s4.51cto.com/wyfs02/M01/92/C0/wKiom1kCqteRcIgHAABW61dRT94467.png-wh_500x0-wm_3-wmp_4-s_3933041186.png">

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" style="float:none;" src="https://s4.51cto.com/wyfs02/M02/92/BF/wKioL1kCqtfDWV4hAABUz4YCS2Y719.png-wh_500x0-wm_3-wmp_4-s_1433334819.png">

Restore SPfile@H_403_1@文件，找到源spfile@H_403_1@备份相关文件进行恢复：

RMAN> restore spfile from'e:\data_BACkup\CTL_C-3279461817-20170427-00';

@H_403_1@启动 restore @H_403_1@于 27-4@H_403_1@月 -17

@H_403_1@使用目标数据库控制文件替代恢复目录

@H_403_1@分配的通道: ORA_disK_1

@H_403_1@通道 ORA_disK_1: SID=135 @H_403_1@设备类型=disK

@H_403_1@通道 ORA_disK_1: @H_403_1@正在从 autoBACKUP e:\data_BACkup\CTL_C-3279461817-20170427-00

@H_403_1@还原 spfile

@H_403_1@通道 ORA_disK_1: @H_403_1@从 autoBACKUP @H_403_1@还原 SPfile @H_403_1@已完成

@H_403_1@完成 restore @H_403_1@于 27-4@H_403_1@月 -17

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s4.51cto.com/wyfs02/M02/92/C0/wKiom1kCqvrhWyTWAABb39lEZYE664.png-wh_500x0-wm_3-wmp_4-s_2514688228.png">

5@H_403_1@、SPfile@H_403_1@恢复完成，关闭数据库，用刚恢复的spfile@H_403_1@启动数据库到nomount@H_403_1@状态(@H_403_1@注意需要创建flash_recovery_area@H_403_1@、ORADATA@H_403_1@目录，否则会报错ORA-01263: name given for file desTination directory is invalID @H_403_1@，同时需注意修改还原过来的SPfile@H_403_1@文件，这里应该注意，源库可能空间较大，关于sga,pga@H_403_1@等酌情根据目标库修改)@H_403_1@，否则会报OSD-00026@H_403_1@超出内存等错误，不能正常nomount@H_403_1@。

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s4.51cto.com/wyfs02/M00/92/BF/wKioL1kCqxvBCO2QAABEkpuc8xs350.png-wh_500x0-wm_3-wmp_4-s_3659926920.png">

@H_403_1@建立相关目录：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s2.51cto.com/wyfs02/M01/92/BF/wKioL1kCq0iDxfTIAACM8_VbfkI826.png-wh_500x0-wm_3-wmp_4-s_4066059722.png">

@H_403_1@再启动：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s1.51cto.com/wyfs02/M00/92/C0/wKiom1kCq3DDUTWAAABD4fwyHYg998.png-wh_500x0-wm_3-wmp_4-s_2592954858.png">

6@H_403_1@、restore@H_403_1@恢复CONTROLFILE@H_403_1@：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s3.51cto.com/wyfs02/M02/92/C0/wKiom1kCq4Wj_WGUAABXIUQXNqs921.png-wh_500x0-wm_3-wmp_4-s_3863175389.png">

RMAN> restore CONTROLFILE from'E:\data_BACkup\CTL_C-3279461817-20170427-01';

@H_403_1@接下来把数据库修改为MOUNT@H_403_1@状态：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s5.51cto.com/wyfs02/M01/92/C0/wKiom1kCq7iiIH_kAABUjj7gB08950.png-wh_500x0-wm_3-wmp_4-s_1841598009.png">

7@H_403_1@、查看归档日志备份的状态，其最大sequence@H_403_1@为18437

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s3.51cto.com/wyfs02/M01/92/BF/wKioL1kCq9iD2_ZfAAByIFANEqg849.png-wh_500x0-wm_3-wmp_4-s_737526331.png">

RMAN> List BACkup of archivelog all;

8@H_403_1@、进行数据文件恢复：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s3.51cto.com/wyfs02/M00/92/C0/wKiom1kCq_-yIw2SAABhdEBsLc4501.png-wh_500x0-wm_3-wmp_4-s_2353016148.png">

RMAN> run {

2> set until sequence 18437;

3> restore database;

4> }

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s1.51cto.com/wyfs02/M02/92/C0/wKiom1kCrCvjWLAZAABkEfhAIx0638.png-wh_500x0-wm_3-wmp_4-s_769031644.png">

RMAN> run {

2> set until sequence 18437;

3> recover database;

4> }

9@H_403_1@、resetlogs @H_403_1@打开数据库：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s3.51cto.com/wyfs02/M00/92/BF/wKioL1kCrEvg7uDAAABilW97oUs894.png-wh_500x0-wm_3-wmp_4-s_2642198968.png">

RMAN> alter database open resetlogs;

10@H_403_1@、查看数据库状态：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s1.51cto.com/wyfs02/M01/92/BF/wKioL1kCrG6A8jsfAAAn1Dw1hOQ985.png-wh_500x0-wm_3-wmp_4-s_3311322287.png">

11@H_403_1@、添加注册表SID@H_403_1@：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s2.51cto.com/wyfs02/M02/92/BF/wKioL1kCrInyb453AACszi3b0lU105.png-wh_500x0-wm_3-wmp_4-s_110264737.png">

12@H_403_1@、创建SPfile

sql>createspfilefrompfile;

13@H_403_1@、重启数据库，是否以SPfile@H_403_1@启动：

sql>SELEct decode(count(*),1,'spfile','pfile') from v$spparameter whererownum

=1 and isspecifIEd = 'TRUE';

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s5.51cto.com/wyfs02/M00/92/BF/wKioL1kCrKmTaOwvAABBARpmX7g209.png-wh_500x0-wm_3-wmp_4-s_258293320.png">

14@H_403_1@、修改listener.ora,tnsnames.ora

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s3.51cto.com/wyfs02/M02/92/C1/wKiom1kCrMGRhv7SAABW38TJ9Lo572.png-wh_500x0-wm_3-wmp_4-s_3367438873.png">

listener.ora

# listener.ora Network Configuration file:D:\app\administrator\product\11.2.0\dbhome_1\NETWORK\admin\listener.ora

# Generated by Oracle configuration tools.

SID_List_ListENER =

(SID_List =

(SID_DESC =

(GLOBAL_dbname = HWPROD)

(OracLE_HOME = D:\app\administrator\product\11.2.0\dbhome_1)

(SID_name = HWPROD)

)

)

ListENER =

(DESCRIPTION =

(ADDRESS = (PROTOCol = TCp)(HOST = ORATEST)(PORT = 1521))

)

ADR_BASE_ListENER =D:\app\administrator\product\11.2.0\dbhome_1\log

tnsnames.ora

# tnsnames.ora Network Configuration file:D:\app\administrator\product\11.2.0\dbhome_1\NETWORK\admin\tnsnames.ora

# Generated by Oracle configuration tools.

HWPROD =

(DESCRIPTION =

(ADDRESS_List =

(ADDRESS = (PROTOCol = TCp)(HOST = 192.168.18.25)(PORT = 1521))

)

(CONNECT_DATA =

(service_name = HWPROD)

)

)

@H_403_1@查看监听状态：

@H_674_286@650) this.width=650;" src="http://img.code.cc/vcimg/static/loading.png" src="https://s4.51cto.com/wyfs02/M02/92/BF/wKioL1kCrOLyBvRrAABjwHoBGzU386.png-wh_500x0-wm_3-wmp_4-s_3605661392.png">

@H_403_1@验证数据，OK！

@H_403_1@

@H_403_1@参考：http://blog.itpub.net/29119536/vIEwspace-1171894/

大佬总结

以上是大佬教程为你收集整理的Oracle 11G RMAN 单实例异机恢复全部内容，希望文章能够帮你解决Oracle 11G RMAN 单实例异机恢复所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。