RMAN 备份异机恢复 并创建新DBID解析.docx
- 文档编号:11568855
- 上传时间:2023-03-19
- 格式:DOCX
- 页数:18
- 大小:20.54KB
RMAN 备份异机恢复 并创建新DBID解析.docx
《RMAN 备份异机恢复 并创建新DBID解析.docx》由会员分享,可在线阅读,更多相关《RMAN 备份异机恢复 并创建新DBID解析.docx(18页珍藏版)》请在冰豆网上搜索。
RMAN备份异机恢复并创建新DBID解析
RMAN备份异机恢复并创建新DBID
分类:
OracleBackup&RecoveryOracleRMAN2011-03-1119:
055532人阅读评论
(1)收藏举报
测试平台信息:
Oracle:
11gR2
操作系统:
Redhat5.5
TargetDB:
dave
几点说明:
(1)RMAN异机恢复的时候,db_name必须相同。
如果说要想改成其他的实例名,可以在恢复成功后,用nid命令修改。
实例名的信息会记录到控制文件里,所以如果在恢复的时候,如果实例名不一致,恢复的时候会报错。
(2)如果恢复的路径和源库不一致,就需要在restore时用set命令指定新位置。
并且使用switchdatafileall将信息更新的到控制文件。
在做duplicate的时候,RMAN会自动根据pfile中的log_file_name_convert和db_file_name_convert来进行set的转换。
手工restore时,只能只只能使用set命令。
(3)异机恢复对相同目录和不同目录都做了说明。
(4)最后测试了NID修改DBID和DBNAME.
一.Target库准备工作:
1.查询DBID
SQL>selectname,dbidfromv$database;
NAMEDBID
-------------------
DAVE808234286
2.备份DB
关于RMAN的shell备份脚本,参考:
Nocatalog下的RMAN增量备份shell脚本
在这里我用0级和1级备份了下DB。
[oracle@qs-dmm-rh1backup]$ls
arch_0pm6qt8q_1_1_20110309dave_lev0_0jm6qt77_1_1_20110309dave_lev1_0um6qtcq_1_1_20110309
arch_0qm6qt8q_1_1_20110309dave_lev0_0km6qt77_1_1_20110309dave_lev1_0vm6qtcq_1_1_20110309
arch_13m6qtda_1_1_20110309dave_lev0_0lm6qt77_1_1_20110309dave_lev1_11m6qtd7_1_1_20110309
arch_14m6qtda_1_1_20110309dave_lev0_0nm6qt7c_1_1_20110309dave_spfile_16m6qtde_1_1_20110309
ctl_file_15m6qtdc_1_1_20110309dave_lev1_0tm6qtcq_1_1_20110309
二.Auxiliary库准备工作:
1.创建口令文件
[oracle@qs-dmm-rh2trace]$orapwdfile=?
/dbs/orapwdavepassword=oracle
2.创建相关的目录
[oracle@qs-dmm-rh2u01]$mkdiroradata
[oracle@qs-dmm-rh2oradata]$pwd
/u01/oradata
3.创建初始化参数
将Target库的pfile文件copy过来。
也可以使用RMAN从我们Target库的备份集中恢复,因为我们之前备份过spfile。
不过使用RMAN,DB要先启动到nomout状态。
这个可以用默认的init.ora来启动。
[oracle@qs-dmm-rh2backup]$exportORACLE_SID=dave
[oracle@qs-dmm-rh2backup]$rmantarget/
RecoveryManager:
Release11.2.0.1.0-ProductiononFriMar1115:
11:
312011
Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
DAVE(notmounted)
RMAN>restorespfiletopfile'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initdave2.ora'from'/u01/backup/dave_spfile_16m6qtde_1_1_20110309';
Startingrestoreat11-MAR-11
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=19devicetype=DISK
channelORA_DISK_1:
restoringspfilefromAUTOBACKUP/u01/backup/dave_spfile_16m6qtde_1_1_20110309
channelORA_DISK_1:
SPFILErestorefromAUTOBACKUPcomplete
Finishedrestoreat11-MAR-11
如果修改数据文件保存的位置,那么要修改控制文件的相关的参数:
*.control_files='/u01/oradata/control01.ctl','/u01/oradata/control02.ctl','/u01/oradata/control03.ctl'
*.db_name='dave'
4.将用pfile将Auxiliary库启动到nomout状态
SQL>startupnomountpfile=?
/dbs/initdave.ora
5.恢复控制文件
[oracle@qs-dmm-rh2dbs]$exportORACLE_SID=dave
[oracle@qs-dmm-rh2dbs]$rmantarget/
RecoveryManager:
Release11.2.0.1.0-ProductiononFriMar1115:
25:
552011
Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
DAVE(notmounted)
RMAN>restorecontrolfilefrom'/u01/backup/ctl_file_15m6qtdc_1_1_20110309';
Startingrestoreat11-MAR-11
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=20devicetype=DISK
channelORA_DISK_1:
restoringcontrolfile
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
01
outputfilename=/u01/oradata/control01.ctl
outputfilename=/u01/oradata/control02.ctl
outputfilename=/u01/oradata/control03.ctl
Finishedrestoreat11-MAR-11
restore的时候需要控制文件,控制文件恢复的位置,是我们在pfile中的control_files参数控制的。
6.将DB启动到mout状态
RMAN>alterdatabasemount;
databasemounted
releasedchannel:
ORA_DISK_1
7.restore数据库
7.1恢复目录不同的情况:
因为我们的路径不同,所以我们需要使用set命令转换一下路径。
到Target库查询一下:
SQL>selectfile_id,file_namefromdba_data_files;
FILE_IDFILE_NAME
-----------------------------------------------------
4/u01/app/oracle/oradata/dave/users01.dbf
3/u01/app/oracle/oradata/dave/undotbs01.dbf
2/u01/app/oracle/oradata/dave/sysaux01.dbf
1/u01/app/oracle/oradata/dave/system01.dbf
SQL>selectfile_id,file_namefromdba_temp_files;
FILE_IDFILE_NAME
----------------------------------------------------
1/u01/app/oracle/oradata/dave/temp01.dbf
注意,restore的时候不会对temp表空间进行restore。
所以等restore之后,我们需要手工创建temp表空间。
RMAN>run
2>{
setnewnamefordatafile1to"/u01/oradata/system01.dbf";
3>4>setnewnamefordatafile2to"/u01/oradata/sysaux01.dbf";
5>setnewnamefordatafile3to"/u01/oradata/undotbs01.dbf";
6>setnewnamefordatafile4to"/u01/oradata/users01.dbf";
7>restoredatabase;
8>switchdatafileall;
9>}
对switchdatafileall的说明:
--对于nocatalog模式下,rman备份的信息是保存在控制文件里的,包括文件的路径信息。
这里的switchdatafileall的作用,就是更新控制文件里的信息。
executingcommand:
SETNEWNAME
releasedchannel:
ORA_DISK_1
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
Startingrestoreat11-MAR-11
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
SID=20devicetype=DISK
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
channelORA_DISK_1:
restoringdatafile00003to/u01/oradata/undotbs01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev0_0lm6qt77_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev0_0lm6qt77_1_1_20110309tag=DAVE_LEV0
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
03
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
channelORA_DISK_1:
restoringdatafile00004to/u01/oradata/users01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev0_0nm6qt7c_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev0_0nm6qt7c_1_1_20110309tag=DAVE_LEV0
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
01
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
channelORA_DISK_1:
restoringdatafile00002to/u01/oradata/sysaux01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev0_0km6qt77_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev0_0km6qt77_1_1_20110309tag=DAVE_LEV0
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
15
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
channelORA_DISK_1:
restoringdatafile00001to/u01/oradata/system01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev0_0jm6qt77_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev0_0jm6qt77_1_1_20110309tag=DAVE_LEV0
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
25
Finishedrestoreat11-MAR-11
datafile1switchedtodatafilecopy
inputdatafilecopyRECID=5STAMP=745522150filename=/u01/oradata/system01.dbf
datafile2switchedtodatafilecopy
inputdatafilecopyRECID=6STAMP=745522150filename=/u01/oradata/sysaux01.dbf
datafile3switchedtodatafilecopy
inputdatafilecopyRECID=7STAMP=745522150filename=/u01/oradata/undotbs01.dbf
datafile4switchedtodatafilecopy
inputdatafilecopyRECID=8STAMP=745522150filename=/u01/oradata/users01.dbf
7.2恢复目录相同
这种情况比较简单,直接:
RMAN>restoredatabase;
8.recoverDB
RMAN>recoverdatabase;
Startingrecoverat11-MAR-11
usingchannelORA_DISK_1
channelORA_DISK_1:
startingincrementaldatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
destinationforrestoreofdatafile00001:
/u01/oradata/system01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev1_0tm6qtcq_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev1_0tm6qtcq_1_1_20110309tag=DAVE_LEV1
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
01
channelORA_DISK_1:
startingincrementaldatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
destinationforrestoreofdatafile00002:
/u01/oradata/sysaux01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev1_0um6qtcq_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev1_0um6qtcq_1_1_20110309tag=DAVE_LEV1
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
02
channelORA_DISK_1:
startingincrementaldatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
destinationforrestoreofdatafile00003:
/u01/oradata/undotbs01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev1_0vm6qtcq_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev1_0vm6qtcq_1_1_20110309tag=DAVE_LEV1
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
01
channelORA_DISK_1:
startingincrementaldatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
destinationforrestoreofdatafile00004:
/u01/oradata/users01.dbf
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/dave_lev1_11m6qtd7_1_1_20110309
channelORA_DISK_1:
piecehandle=/u01/backup/dave_lev1_11m6qtd7_1_1_20110309tag=DAVE_LEV1
channelORA_DISK_1:
restoredbackuppiece1
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
00:
01
startingmediarecovery
channelORA_DISK_1:
startingarchivedlogrestoretodefaultdestination
channelORA_DISK_1:
restoringarchivedlog
archivedlogthread=1sequence=7
channelORA_DISK_1:
readingfrombackuppiece/u01/backup/arch_13m6qtda_1_1_2
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- RMAN 备份异机恢复 并创建新DBID解析 备份 恢复 创建 DBID 解析