使用dmrestore执行并行映射文件还原
对于并行备份产生的备份文件，系统支持利用还原工具对数据库进行并行还原。与并行备份一样，并行还原需要用户指定并行映射文件的存储位置。由于并行备份可能是增量备份，而备份的基础备份也有可能是并行备份，因此执行并行还原需要指定一个映射文件存放的目录，用于还原的并行备份的映射文件都存放在该目录下。并行还原能提高还原性能，使得数据服务迅速还原。需要说明的是，备份时的映射文件内容应与还原时映射文件内容保持一致，但这不是必需的，系统在还原前，会对用户设置的映射文件内容进行校验，判断映射文件内容是否与备份时映射文件内容兼容，保证系统能正确还原数据库。
创建并行映射文件
[dmdba@shard1 backup]$ vi bak.parallel [DMHR,USERS]=/dm_home/dmdba/dmdbms/backup/backup1 [FG_PERSON]=/dm_home/dmdba/dmdbms/backup/backup2 [default]=/dm_home/dmdba/dmdbms/backup/backup3
创建数据库的备份文件
SQL> backup database full to para_bak bakfile '/dm_home/dmdba/dmdbms/backup/parallel.bak' parallel '/dm_home/dmdba/dmdbms/backup/bak.parallel'; executed successfully used time: 00:00:12.628. Execute id is 164. [dmdba@shard1 backup]$ ls -lrt -rw-r--r-- 1 dmdba dinstall 146 8月 4 11:50 bak.parallel drwxr-xr-x 2 dmdba dinstall 47 8月 4 12:10 backup3 drwxr-xr-x 2 dmdba dinstall 47 8月 4 12:10 backup2 drwxr-xr-x 2 dmdba dinstall 47 8月 4 12:10 backup1 -rw-r--r-- 1 dmdba dinstall 33554432 8月 4 12:10 parallel.bak [dmdba@shard1 backup]$ cd backup1 [dmdba@shard1 backup1]$ ls -lrt 总用量 1512 -rw-r--r-- 1 dmdba dinstall 33554432 8月 4 12:10 DB_jydm_20200804121005000554_1.bak [dmdba@shard1 backup1]$ cd .. [dmdba@shard1 backup]$ cd backup2 [dmdba@shard1 backup2]$ ls -lrt 总用量 28 -rw-r--r-- 1 dmdba dinstall 33554432 8月 4 12:10 DB_jydm_20200804121005000554_1.bak [dmdba@shard1 backup2]$ cd .. [dmdba@shard1 backup]$ cd backup3 [dmdba@shard1 backup3]$ ls -lrt 总用量 390420 -rw-r--r-- 1 dmdba dinstall 402653184 8月 4 12:10 DB_jydm_20200804121005000554_1.bak
使用并行备份文件来还原数据库，并行映射文件为/dm_home/dmdba/dmdbms/backup/bak.parallel
[root@shard1 oracle]# service DmServicejydm stop Redirecting to /bin/systemctl stop DmServicejydm.service [dmdba@shard1 backup]$ dmrestore ini_path=/dm_home/dmdba/dmdbms/data/jydm/dm.ini file=/dm_home/dmdba/dmdbms/backup/parallel.bak parallel_dir=/dm_home/dmdba/dmdbms/backup/bak.parallel restore V7.1.6.46-Build(2018.02.08-89107)ENT file dm.key not found, use default license!backup sig: BA backup tool version: 12595 backup db name: jydm backup db magic: -848310636 backup pemnt magic: 1250320462 backup name: PARA_BAK backup type: full backup level: online backup range: database backup description: compressed level: 0 encrypt_type: 0 encrypt_id: 2052 rac node: 0 page check: 0 rlog encrypt: 0 external cipher id: 0 external hash id: 0 length in char: 0 use new hash: 1 backup time: 2020-08-04 12:10:05 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 mpp_timestamp: 1596514204 crc_check: TRUE parallel type: 1 parallel info len: 1536 backup db fil num: 9 archive flag: 1 backup with log: Yes before backup LSN: 32598802 after backup LSN: 32598813 $bak_seq |$file_path |$size(K) |$used(K) 1|/dm_home/dmdba/dmdbms/backup/parallel.bak | 32768.00| 47.50 $file_seq |$type|$ts_name |$state |$size(K) |$seq_in_bak |$off_in_bak(B) |$len_in_bak(B) |$file_path |$mirror_path 1|DBF |SYSTEM |ONLINE | 23552| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/SYSTEM.DBF | 2|DBF |ROLL |ONLINE | 229376| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/ROLL.DBF | 3|DBF |MAIN |ONLINE | 305152| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/MAIN.DBF | 4|DBF |BOOKSHOP |ONLINE | 153600| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/BOOKSHOP.DBF | 5|DBF |DMHR |ONLINE | 131072| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/DMHR.DBF | 6|DBF |USERS |ONLINE | 51200| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/users01.dbf | 7|DBF |SYSAUX |ONLINE | 179200| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/SYSAWR.DBF | 8|DBF |FG_PERSON |ONLINE | 131072| 1| 0| 0|/dm_home/dmdba/dmdbms/data/jydm/FG_PERSON.DBF | 9|LOG |ARCHLOG |ONLINE | 0| 1| 44544| 4096| | backup sig: BA backup tool version: 12595 backup db name: jydm backup db magic: -848310636 backup pemnt magic: 1250320462 backup name: PARA_BAK backup type: full backup level: online backup range: database backup description: compressed level: 0 encrypt_type: 0 encrypt_id: 2052 rac node: 0 page check: 0 rlog encrypt: 0 external cipher id: 0 external hash id: 0 length in char: 0 use new hash: 1 backup time: 2020-08-04 12:10:05 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 mpp_timestamp: 1596514204 crc_check: TRUE parallel type: 2 parallel info len: 0 backup db fil num: 2 archive flag: 1 backup with log: Yes before backup LSN: 32598802 after backup LSN: 0 $bak_seq |$file_path |$size(K) |$used(K) 1|/dm_home/dmdba/dmdbms/backup/backup1/DB_jydm_20200804121005000554_1.bak| 32768.00| 1510.00 $file_seq |$type|$ts_name |$state |$size(K) |$seq_in_bak |$off_in_bak(B) |$len_in_bak(B) |$file_path |$mirror_path 1|DBF |DMHR |ONLINE | 131072| 1| 14336| 425984|/dm_home/dmdba/dmdbms/data/jydm/DMHR.DBF | 2|DBF |USERS |ONLINE | 51200| 1| 440320| 1105920|/dm_home/dmdba/dmdbms/data/jydm/users01.dbf | backup sig: BA backup tool version: 12595 backup db name: jydm backup db magic: -848310636 backup pemnt magic: 1250320462 backup name: PARA_BAK backup type: full backup level: online backup range: database backup description: compressed level: 0 encrypt_type: 0 encrypt_id: 2052 rac node: 0 page check: 0 rlog encrypt: 0 external cipher id: 0 external hash id: 0 length in char: 0 use new hash: 1 backup time: 2020-08-04 12:10:05 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 mpp_timestamp: 1596514204 crc_check: TRUE parallel type: 2 parallel info len: 0 backup db fil num: 1 archive flag: 1 backup with log: Yes before backup LSN: 32598802 after backup LSN: 0 $bak_seq |$file_path |$size(K) |$used(K) 1|/dm_home/dmdba/dmdbms/backup/backup2/DB_jydm_20200804121005000554_1.bak| 32768.00| 26.00 $file_seq |$type|$ts_name |$state |$size(K) |$seq_in_bak |$off_in_bak(B) |$len_in_bak(B) |$file_path |$mirror_path 1|DBF |FG_PERSON |ONLINE | 131072| 1| 10240| 16384|/dm_home/dmdba/dmdbms/data/jydm/FG_PERSON.DBF | backup sig: BA backup tool version: 12595 backup db name: jydm backup db magic: -848310636 backup pemnt magic: 1250320462 backup name: PARA_BAK backup type: full backup level: online backup range: database backup description: compressed level: 0 encrypt_type: 0 encrypt_id: 2052 rac node: 0 page check: 0 rlog encrypt: 0 external cipher id: 0 external hash id: 0 length in char: 0 use new hash: 1 backup time: 2020-08-04 12:10:05 page size: 8 KB extent size: 16 case sensitive: 1 log page size: 512 B charset: 0 data version: 0x7000A sys version: V7.1.6.46-Build(2018.02.08-89107)ENT enable policy: 0 mpp_timestamp: 1596514204 crc_check: TRUE parallel type: 2 parallel info len: 0 backup db fil num: 5 archive flag: 1 backup with log: Yes before backup LSN: 32598802 after backup LSN: 0 $bak_seq |$file_path |$size(K) |$used(K) 1|/dm_home/dmdba/dmdbms/backup/backup3/DB_jydm_20200804121005000554_1.bak| 393216.00| 390418.00 $file_seq |$type|$ts_name |$state |$size(K) |$seq_in_bak |$off_in_bak(B) |$len_in_bak(B) |$file_path |$mirror_path 1|DBF |SYSTEM |ONLINE | 23552| 1| 26624| 6766592|/dm_home/dmdba/dmdbms/data/jydm/SYSTEM.DBF | 2|DBF |ROLL |ONLINE | 229376| 1| 6793216| 10887168|/dm_home/dmdba/dmdbms/data/jydm/ROLL.DBF | 3|DBF |MAIN |ONLINE | 305152| 1| 17680384| 270917632|/dm_home/dmdba/dmdbms/data/jydm/MAIN.DBF | 4|DBF |BOOKSHOP |ONLINE | 153600| 1| 288598016| 933888|/dm_home/dmdba/dmdbms/data/jydm/BOOKSHOP.DBF | 5|DBF |SYSAUX |ONLINE | 179200| 1| 289531904| 110256128|/dm_home/dmdba/dmdbms/data/jydm/SYSAWR.DBF | Continue?[Y/N]:Y restore bak_file: /dm_home/dmdba/dmdbms/backup/parallel.bak ... start restore database... start restore database... start restore database... start restore file: /dm_home/dmdba/dmdbms/data/jydm/FG_PERSON.DBF(FG_PERSON), pages: 2 start restore file: /dm_home/dmdba/dmdbms/data/jydm/DMHR.DBF(DMHR), pages: 52 start restore file: /dm_home/dmdba/dmdbms/data/jydm/SYSTEM.DBF(SYSTEM), pages: 826 end restore file: /dm_home/dmdba/dmdbms/data/jydm/FG_PERSON.DBF(FG_PERSON) end restore database data files. end restore file: /dm_home/dmdba/dmdbms/data/jydm/DMHR.DBF(DMHR) end restore file: /dm_home/dmdba/dmdbms/data/jydm/SYSTEM.DBF(SYSTEM) start restore file: /dm_home/dmdba/dmdbms/data/jydm/users01.dbf(USERS), pages: 135 start restore file: /dm_home/dmdba/dmdbms/data/jydm/ROLL.DBF(ROLL), pages: 1329 end restore file: /dm_home/dmdba/dmdbms/data/jydm/ROLL.DBF(ROLL) end restore file: /dm_home/dmdba/dmdbms/data/jydm/users01.dbf(USERS) start restore file: /dm_home/dmdba/dmdbms/data/jydm/MAIN.DBF(MAIN), pages: 33071 end restore database data files. end restore file: /dm_home/dmdba/dmdbms/data/jydm/MAIN.DBF(MAIN) start restore file: /dm_home/dmdba/dmdbms/data/jydm/BOOKSHOP.DBF(BOOKSHOP), pages: 114 end restore file: /dm_home/dmdba/dmdbms/data/jydm/BOOKSHOP.DBF(BOOKSHOP) start restore file: /dm_home/dmdba/dmdbms/data/jydm/SYSAWR.DBF(SYSAUX), pages: 13459 end restore file: /dm_home/dmdba/dmdbms/data/jydm/SYSAWR.DBF(SYSAUX) end restore database data files. redo tmp arch file: /dm_home/dmdba/dmdbms/backup/RES_TMP_ARCH_20200804121936840_0.log, rpages: 16 Apply archive log LSN from 32598814 to 32598813, time used:0.000s. restore finished, code = 0! restore successfully! restore time used: 9800.081(ms)
启动数据库
[root@shard1 oracle]# service DmServicejydm start Redirecting to /bin/systemctl start DmServicejydm.service SQL> select * from t1; LINEID C1 C2 ---------- ----------- ----------- 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 6 rows got used time: 0.427(ms). Execute id is 101.