在一次培训中进行数据库相关热备恢复,正常情况下按照老师的步骤可能是没有问题的,但是往往出问题的时候更多我们预知不到的,这个时候对数据库排查显得尤为重要。
在进行数据库恢复演练前进数据库的热备:backup database;
1)在后面进行相关增量备份:
SQL> backup database increment with backupdir '/dm8/backup/full' to incrbak3 backupset '/dm8/backup/incr/incrbak03';
backup database increment with backupdir '/dm8/backup/full' to incrbak3 backupset '/dm8/backup/incr/incrbak03';
[-8116]:检查点LSN小于基备份集END_LSN.
已用时间: 00:00:01.817. 执行号:0.
2)对于此错误,理解为里面执行,可能是备份的增量太少导致,索引执行相关检查点操作:
alter system switch logfile;
再次执行相关增量备份,仍然报错;
3)而此时继续按照原计划在数据库上删除数据库相关,main.dbf文件,验证数据库恢复
4)通过dmrman进行恢复
RMAN> recover database '/dm8/data/dmtest/dm.ini' with archivedir '/dm8/arch';
recover database '/dm8/data/dmtest/dm.ini' with archivedir '/dm8/arch';
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[297787], file_lsn[297787]
[611]:恢复操作未完成
RMAN> restore database '/dm8/data/dmtest/dm.ini' from backupset '/dm8/data/dmtest/bak/DB_dmtest_FULL_20220505_080315_951399';
restore database '/dm8/data/dmtest/dm.ini' from backupset '/dm8/data/dmtest/bak/DB_dmtest_FULL_20220505_080315_951399';
[Percent:0.00%][Speed:0.00M/s][Cost:00:00:01][Remaining:00:00:00]Normal of FAST