本篇文章为大家展示了DM7 RAC数据库怎样恢复成单机数据库，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

DM7 RAC数据库恢复成单机数据库
1) 启动RMAN备份数据库，保证服务器处于脱机状态。

RMAN>backupdatabase'/dm7/data/rac0_config/dm.ini'fullbackupset'/dm7/backup/db_rac_full_bak_recover_dbmagic';backupdatabase'/dm7/data/rac0_config/dm.ini'fullbackupset'/dm7/backup/db_rac_full_bak_recover_dbmagic';filedm.keynotfound,usedefaultlicense!checkingiftheRACdatabaseundersystempath[+DMDATA/data/rac]isrunning....EP[0]ischecking....EP[1]ischecking....EP[0]max_lsn:76986EP[0]adjustcur_lsnfrom[76986]to[77001]BACKUPDATABASE[rac],execute......CMDCHECKLSN......BACKUPDATABASE[rac],collectdbf......CMDCHECK......DBFBACKUPSUBS......total1packagesprocessed...total2packagesprocessed...total3packagesprocessed...total4packagesprocessed...total5packagesprocessed...DBFBACKUPMAIN......BACKUPSET[/dm7/backup/db_rac_full_bak_recover_dbmagic]END,CODE[0]......METAGENERATING......total9packagesprocessed...total9packagesprocessed!CMDEND.CODE:[0]backupsuccessfully!timeused:3887.714(ms)RMAN>showbackupset'/dm7/backup/db_rac_full_bak_recover_dbmagic';showbackupset'/dm7/backup/db_rac_full_bak_recover_dbmagic';systempath:+DMDATA/data/racdbmagic:-1632052820permanentmagic:450923536racnode:2pagecheck:0rlogencrypt:0externalcipher[id/name]:0/externalhash[id/name]:0/lengthinchar:0usenewhash:1pagesize:8KBextentsize:16casesensitive:1logpagesize:512Bunicode_flag/charset:0dataversion:0x7000Asysversion:V7.1.6.46-Build(2018.02.08-89107)ENTenablepolicy:0archiveflag:1blank_pad_mode:0crc_check:TRUEbackupsetsig:BAbackupsetversion:4009databasename:racbackupname:DB_FULL_rac_20200616_154323_000689backupsetdescription:backupsetID:1145407476parentbackupsetID:-1METAfilesize:74240compressedlevel:0encrypttype:0parallelnum:1backuprange:databasempp_timestamp:1592293401ddl_clone:FALSEmpp_flag:FALSEbackuplevel:offlinebackuptype:fullwithoutlog:FALSESTART_LSN:76987START_SEQ:309END_LSN:77001END_SEQ:308baseSTART_LSN:-1baseEND_LSN:-1basename:basebackupset:backuptime:2020-06-1615:43:25mintrxstartlsn:76987minexecver:0x0701060Cpkgsize:0x02000000RACEP:0RACstatus:OKRACbeginlsn:76987RACbeginseq:309RACendlsn:77001RACendseq:308RACbasebeginlsn:-1RACbasebeginseq:-1RACbaseendlsn:-1RACbaseendseq:-1RACEP:1RACstatus:OKRACbeginlsn:77002RACbeginseq:308RACendlsn:77001RACendseq:307RACbasebeginlsn:-1RACbasebeginseq:-1RACbaseendlsn:-1RACbaseendseq:-1backupsetdirectory:/dm7/backup/db_rac_full_bak_recover_dbmagicbackupsetname:db_rac_full_bak_recover_dbmagicbackupdatafilenum:5backuppiecenum:1$file_seq|$size(KB)|$pos_desc|$content_type0|26103|db_rac_full_bak_recover_dbmagic.bak|DATA$file_seq|$group_id|$group_name|$file_id|$file_path|$mirror_path|$file_len1|0|SYSTEM|0|+DMDATA/data/rac/system.dbf||1342177282|1|ROLL|0|+DMDATA/data/rac/roll.dbf||1342177283|4|MAIN|0|+DMDATA/data/rac/main.dbf||1342177284|5|TS_FOR_DBF|0|+DMDATA/data/rac/ts_for_dbf_01.dbf||1342177285|5|TS_FOR_DBF|1|+DMDATA/data/rac/ts_for_dbf_02.dbf||134217728$file_seq|$file_path|$file_len|$begin_lsn|$begin_seqno|$begin_rpag_off|$end_lsn|$end_seqno|$create_time|$close_timeshowbackupsetssuccessfully.timeused:10.655(ms)

2) 准备目标库，可以使用备份库，也可以重新生成库。这里是在别一台服务器上创建新库，重新生成库操作如下：

[dmdba@dmks~]$dminitpath=/dm_home/dmdbms/datadb_name=dameng_for_recoverauto_overwrite=1port_num=5336initdbV7.1.6.46-Build(2018.02.08-89107)ENTdbversion:0x7000afiledm.keynotfound,usedefaultlicense!Licensewillexpirein14day(s)on2020-06-30logfilepath:/dm_home/dmdbms/data/dameng_for_recover/dameng_for_recover01.loglogfilepath:/dm_home/dmdbms/data/dameng_for_recover/dameng_for_recover02.logwritetodir[/dm_home/dmdbms/data/dameng_for_recover].createdmdatabasesuccess.2020-06-1616:03:18[root@dmksroot]#./dm_service_installer.sh-i/dm_home/dmdbms/data/dameng_for_recover/dm.ini-pdmrc-tdmserverMovetheservicescriptfile(/dm_home/dmdbms/bin/DmServicedmrcto/etc/rc.d/init.d/DmServicedmrc)Finishedtocreatetheservice(DmServicedmrc)[root@dmksroot]#serviceDmServicedmrcstartStartingDmServicedmrc:[OK][dmdba@dmks~]$disqlSYSDBA/SYSDBA@localhost:5336Server[localhost:5336]:modeisnormal,stateisopenloginusedtime:10.727(ms)disqlV7.1.6.46-Build(2018.02.08-89107)ENTConnectedto:DM7.1.6.46SQL>selectpermanent_magic;LINEIDPERMANENT_MAGIC-------------------------1-1238913195usedtime:0.793(ms).Executeidis809.SQL>selectdb_magicfromv$rlog;LINEIDDB_MAGIC---------------------11319824724usedtime:0.984(ms).Executeidis810.

3)将备份集和归档日志文件复制到目标库所在主机上

[dmdba@dmrac1 backup]$ scp -r db_rac_full_bak_recover_dbmagic dmdba@10.10.10.187:/dm_home/dmdbms/backup/
The authenticity of host '10.10.10.187 (10.10.10.187)' can't be established.
RSA key fingerprint is 34:9a:d7:67:6d:be:20:45:21:ce:96:82:23:e5:e9:11.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.10.10.187' (RSA) to the list of known hosts.
dmdba@10.10.10.187's password:
db_rac_full_bak_recover_dbmagic.meta 100% 73KB 72.5KB/s 00:00
db_rac_full_bak_recover_dbmagic.bak 100% 25MB 25.5MB/s 00:00

[dmdba@dmrac1 data]$ scp -r local_arch dmdba@10.10.10.187:/dm_home/dmdbms/backup/
dmdba@10.10.10.187's password:
ARCHIVE_LOCAL1_20200528171255857_0.log 100% 157KB 156.5KB/s 00:00
[dmdba@dmrac1 data]$ scp -r rac0_arch dmdba@10.10.10.187:/dm_home/dmdbms/backup/
dmdba@10.10.10.187's password:
ARCHIVE_LOCAL1_20200615164953273_0.log 100% 160KB 160.0KB/s 00:00
ARCHIVE_LOCAL1_20200615165648166_0.log 100% 157KB 157.0KB/s 00:00
ARCHIVE_LOCAL1_20200528202150715_0.log 100% 277KB 277.0KB/s 00:00
ARCHIVE_LOCAL1_20200608151836879_0.log 100% 158KB 157.5KB/s 00:00
ARCHIVE_LOCAL1_20200609150852829_0.log 100% 157KB 157.0KB/s 00:00
ARCHIVE_LOCAL1_20200608152638617_0.log 100% 159KB 158.5KB/s 00:00
ARCHIVE_LOCAL1_20200609170732487_0.log 100% 161KB 160.5KB/s 00:00
ARCHIVE_LOCAL1_20200615172117341_0.log 100% 159KB 158.5KB/s 00:00
ARCHIVE_LOCAL1_20200615171042444_0.log 100% 159KB 159.0KB/s 00:00
ARCHIVE_LOCAL1_20200605154214367_0.log 100% 157KB 157.0KB/s 00:00
[dmdba@dmrac1 data]$ scp -r rac1_arch dmdba@10.10.10.187:/dm_home/dmdbms/backup/
dmdba@10.10.10.187's password:
ARCH_REMOTE1_20200608152641970_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200609170737070_1.log 100% 159KB 159.0KB/s 00:00
ARCH_REMOTE1_20200609150857056_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200615172121038_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200608151838201_1.log 100% 5632 5.5KB/s 00:00
ARCH_REMOTE1_20200528202146001_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200615164957743_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200605154211189_1.log 100% 159KB 159.0KB/s 00:00
ARCH_REMOTE1_20200615165652504_1.log 100% 158KB 158.0KB/s 00:00
ARCH_REMOTE1_20200615171046600_1.log 100% 158KB 158.0KB/s 00:00
[dmdba@dmrac1 data]$

4)检验备份

RMAN>checkbackupset'/dm_home/dmdbms/backup/db_rac_full_bak_recover_dbmagic';checkbackupset'/dm_home/dmdbms/backup/db_rac_full_bak_recover_dbmagic';CMDEND.CODE:[0]checkbackupsetsuccessfully.timeused:5.877(ms)

5)还原数据库

RMAN>restoredatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'frombackupset'/dm_home/dmdbms/backup/db_rac_full_bak_recover_dbmagic';restoredatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'frombackupset'/dm_home/dmdbms/backup/db_rac_full_bak_recover_dbmagic';filedm.keynotfound,usedefaultlicense!checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[4].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[3].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[2].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[1].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[0].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning,writedmrmaninfo.RESTOREDATABASECHECK......RESTOREDATABASE,dbfcollect......RESTOREDATABASE,dbfrefresh......RESTOREBACKUPSET[/dm_home/dmdbms/backup/db_rac_full_bak_recover_dbmagic]START......total5packagesprocessed...RESTOREDATABASE,UPDATEctlfile......RESTOREDATABASE,REBUILDkeyfile......RESTOREDATABASE,CHECKdbinfo......RESTOREDATABASE,UPDATEdbinfo......total7packagesprocessed!CMDEND.CODE:[0]restoresuccessfully.timeused:16226.253(ms)

6)恢复数据库

RMAN>recoverdatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'updatedb_magic;recoverdatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'updatedb_magic;checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[4].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[3].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[2].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[1].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[0].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning,writedmrmaninfo.EP[0]max_lsn:76986[-8308]:forbidupdatingdatabasemagic,needredolog

这里使用update db_magic选项出错了，提示需要重做日志文件。下面去掉update db_magic选项，因为每次还原恢复时也是一定会更新db_magic值。

RMAN>recoverdatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'witharchivedir'/dm_home/dmdbms/backup/rac0_arch','/dm_home/dmdbms/backup/rac1_arch';recoverdatabase'/dm_home/dmdbms/data/dameng_for_recover/dm.ini'witharchivedir'/dm_home/dmdbms/backup/rac0_arch','/dm_home/dmdbms/backup/rac1_arch';checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[4].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[3].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[2].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[1].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning...[0].checkingifthedatabaseundersystempath[/dm_home/dmdbms/data/dameng_for_recover]isrunning,writedmrmaninfo.EP[0]max_lsn:76986min_ckpt_lsn=TheRACrecovertotalredo0ptxEP(0)slotctlpage(1,0,16)trxid=9986EP(1)slotctlpage(1,0,17)trxid=8457EP[0]RecoverLSNfrom76987to77001.EP[1]RecoverLSNfrom77002to77001.Recoverfromarchivelogfinished,timeused:0.006s.recoversuccessfully!timeused:7027.075(ms)

7）检查数据，查询表t1的数据可以验证数据恢复成功

[dmdba@dmks~]$disqlSYSDBA/SYSDBA@localhost:5336Server[localhost:5336]:modeisnormal,stateisopenloginusedtime:10.727(ms)disqlV7.1.6.46-Build(2018.02.08-89107)ENTConnectedto:DM7.1.6.46SQL>desct1;LINEIDNAMETYPE$NULLABLE---------------------------------1IDINTEGERY2NAMEVARCHAR(20)Yusedtime:20.311(ms).Executeidis3.SQL>select*fromt1;LINEIDIDNAME-------------------------11jy22hyusedtime:1.138(ms).Executeidis4.

8）检查db_magic，还原恢复后db_magic从-1632052820变成了1009602608，

SQL>selectpermanent_magic;LINEIDPERMANENT_MAGIC-------------------------1450923536usedtime:1.042(ms).Executeidis5.SQL>selectdb_magicfromv$rlog;LINEIDDB_MAGIC---------------------11009602608usedtime:1.332(ms).Executeidis6.

上述内容就是DM7 RAC数据库怎样恢复成单机数据库，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注亿速云行业资讯频道。