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
升级会员 