–开启归档
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG ‘DEST = /dm8/data/arch, TYPE = local, FILE_SIZE = 1024, SPACE_LIMIT = 2048’;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

–全备数据库
checkpoint(100);
backup database full backupset ‘/dm8/backup/full01’;

cd /dm8/data/DM01
mv MAIN.DBF MAIN.DBF_bak
删除数据库文件后，发现只能到 mount状态

–还原数据库
systemctl stop DmServicedw.service
cd /home/dmdba/dmdbms/bin
./dmrman
restore database ‘/dm8/data/DM01/dm.ini’ from backupset ‘/dm8/backup/full01’;
–恢复数据库到指定的时间点2022-10-13 10:21:29
RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ WITH ARCHIVEDIR’/dm8/data/arch’ UNTIL TIME’2022-10-18 17:21:29’;

–更新数据库魔数值：
RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ UPDATE DB_MAGIC;

–启动数据库：
systemctl start DmServicedw