首页 > 其他 > 详细

DM8备份恢复

时间:2020-12-17 00:26:47      阅读:38      评论:0      收藏:0      [点我收藏+]
1、做一个完整备份,使能够恢复到任意一个时刻。
将备份存放到/opt/dm8/backup目录
alter database mount;
alter database archivelog;
alter database add archivelog ‘DEST=/opt/dm8/arch,TYPE=LOCAL,FILE_SIZE=200,SPACE_LIMIT=1024‘;
ALTER DATABASE OPEN;
BACKUP DATABASE BACKUPSET ‘/opt/dm8/backup/full_database_bak_02‘;
2、将main.dbf文件删除,利用以上的备份恢复。
cd /opt/dm8/data/PROED/
rm MAIN.DBF
DmServiceENMO stop
DmServiceENMO status

[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

DM8备份恢复

原文:https://blog.51cto.com/11177763/2565299

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!