为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
--原服务器上disql方式联机备份
SQL> backup database backupset '/dmdb8/dmdata/fuwa/bak/db_fuwa_full_bak20231019';
executed successfully
used time: 00:00:07.721. Execute id is 601.
并将备份目录db_fuwa_full_bak20231019上传到新服务器/home/dmdba目录下
--新服务器上初始化实例、校验备份文件和恢复
[dmdba@top130:~/dmdatanew]$ dminit path=/home/dmdba/dmdatanew db_name=pijiake
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire on 2024-04-17
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: /home/dmdba/dmdatanew/pijiake/pijiake01.log
log file path: /home/dmdba/dmdatanew/pijiake/pijiake02.log
write to dir [/home/dmdba/dmdatanew/pijiake].
create dm database success. 2023-10-19 03:26:05
[dmdba@top130:~/dmdatanew]$
[dmdba@top130:~/dmdatanew]$ dmrman
dmrman V8
RMAN> exit
time used: 2.590(ms)
[dmdba@top130:~/dmdatanew]$ vi /home/dmdba/dmdatanew/pijiake/dm.ini
[dmdba@top130:~/dmdatanew]$ cat /home/dmdba/dmdatanew/pijiake/dm.ini | grep PORT_NUM
PORT_NUM = 5237 #Port number on which the database server will listen
DCRS_PORT_NUM = 6236 #Port number on which the database dcrs will listen
AP_PORT_NUM = 0 #Port number on which the database ap will listen
[dmdba@top130:~/dmdatanew]$ dmrman
dmrman V8
RMAN> check backupset '/home/dmdba/db_fuwa_full_bak20231019';
check backupset '/home/dmdba/db_fuwa_full_bak20231019';
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
check backupset successfully.
time used: 308.925(ms)
RMAN> restore database '/home/dmdba/dmdatanew/pijiake/dm.ini' from backupset '/home/dmdba/db_fuwa_full_bak20231019';
restore database '/home/dmdba/dmdatanew/pijiake/dm.ini' from backupset '/home/dmdba/db_fuwa_full_bak20231019';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:03][Remaining:00:00:00]
restore successfully.
time used: 00:00:04.063
RMAN> exit
time used: 0.467(ms)
[dmdba@top130:~/dmdatanew]$ cd /dm/bin
[dmdba@top130:/dm/bin]$ ls -l | grep Dm*
[dmdba@top130:/dm/bin]$ ls -l | grep D*
[dmdba@top130:/dm/bin]$ ls -l | grep DmS*
[dmdba@top130:/dm/bin]$ ls -l | grep DmServicepijiake
-rwxr-xr-x 1 dmdba dinstall 17379 Oct 19 03:02 DmServicepijiake
[dmdba@top130:/dm/bin]$ ./DmServicepijiake start
Starting DmServicepijiake: [ FAILED ]
脱机恢复三部曲。
1.还原restore
2.恢复recover
3.update db_magic
dmrman还原数据库步骤有三个。
参考连接:https://eco.dameng.com/document/dm/zh-cn/pm/backup-restore-combat.html#3.3.5.1.2.2%20%E6%9B%B4%E6%96%B0%20DB_MAGIC