1，首先开启归档
disql执行
alter database mount;
alter database add archivelog ‘dest = /dm8/arch, type = local, file_size = 64, space_limit = 2048’;
alter database archivelog;
alter database open;
2，确认归档已打开
select arch_mode from v$database;
3，对数据库进行全备
backup database full to “DB_DAMENG_FULL” backupset ‘/dm8/bak/’;

4，数据库故障后停止
./DmServicePROD stop
5，基于时间点恢复数据库
RESTORE DATABASE ‘/dm8/data/DAMENG/dm.ini’ FROM BACKUPSET ‘/dm8/bak’;
RECOVER DATABASE ‘/dm8/data/DAMENG/dm.ini’ WITH ARCHIVEDIR ‘/dm8/arch’ UNTIL TIME ‘2022-12-22 15:58:51’;
recover database’/dm8/data/DAMENG/dm.ini’ update db_magic;

6，还原数据库后重启数据库
./DmServicePROD start