[dmdba@enmoedu1 ~]$ console
最后点确定;
日志如下:
RESTORE DATABASE ‘/opt/dm8/data/PROED/dm.ini‘ tablespace "MAIN" FROM BACKUPSET ‘/opt/dm8/backup/db_full_bak_03‘ DEVICE TYPE disk;
RESTORE TABLESPACE[MAIN] IN DB[/opt/dm8/data/PROED/dm.ini] CHECK......
Database mode = 0, oguid = 0
EP[0]‘s cur_lsn[54308]
RESTORE TABLESPACE[MAIN] IN DB[/opt/dm8/data/PROED/dm.ini],dbf collect......
RESTORE TABLESPACE[MAIN] IN DB[/opt/dm8/data/PROED/dm.ini],ts status and dbf refresh ......
RESTORE BACKUPSET [/opt/dm8/backup/db_full_bak_03] START......
total 0 packages processed...
RESTORE TABLESPACE[MAIN] IN DB[/opt/dm8/data/PROED/dm.ini],UPDATE ctl file......
CMD END.CODE:[0]
restore successfully.
time used: 618.599(ms)
2020-12-06 12:39:09 [com.dameng.console.service.BackupRestoreService]
[INFO] drman_execute_sql:CONFIGURE DEFAULT TRACE LEVEL 1;
RECOVER DATABASE ‘/opt/dm8/data/PROED/dm.ini‘ TABLESPACE MAIN WITH ARCHIVEDIR ‘/opt/dm8/arch‘;
2020-12-06 12:39:09 [com.dameng.console.service.BackupRestoreService]
[INFO] use_ap:1; ap_port:-1
configure default trace successfully!
time used: 0.137(ms)
RECOVER DATABASE ‘/opt/dm8/data/PROED/dm.ini‘ TABLESPACE MAIN WITH ARCHIVEDIR ‘/opt/dm8/arch‘;
Database mode = 0, oguid = 0
[WARN]tablespace MAIN is corrupted(state: 2), restore or drop please.
EP[0]‘s cur_lsn[54308]
RECOVER TABLESPACE[MAIN] IN DB[/opt/dm8/data/PROED/dm.ini] CHECK......
EP[0]‘s cur_lsn[54308]
EP:0 total 1 pkgs applied, percent: 12%
EP:0 total 2 pkgs applied, percent: 25%
EP:0 total 3 pkgs applied, percent: 37%
EP:0 total 4 pkgs applied, percent: 50%
EP:0 total 5 pkgs applied, percent: 62%
EP:0 total 6 pkgs applied, percent: 75%
EP:0 total 7 pkgs applied, percent: 87%
EP:0 total 8 pkgs applied, percent: 100%
Recover from archive log finished, time used:0.046s.
CMD END.CODE:[0]
recover successfully.
time used: 598.645(ms)
[dmdba@enmoedu1 ~]$ DmServiceENMO start
Starting DmServiceENMO: [ OK ]
[dmdba@enmoedu1 ~]$ DmServiceENMO status
DmServiceENMO (pid 10048) is running.
[dmdba@enmoedu1 ~]$ disql sysdba/EnmoEdu123@ENMO
服务器[192.168.6.110:5252]:处于普通打开状态
登录使用时间: 3.633(毫秒)
disql V8
SQL> host ls /opt/dm8/data/PROED/MAIN.DBF
/opt/dm8/data/PROED/MAIN.DBF
原文:https://blog.51cto.com/11177763/2565299