一次ogg的恢复实战记录

–获取当前scn号

select current_scn from v$database;
33467391237

–备份数据

expdp vbs5/vbs5 directory=DATA_BAK_DIR dumpfile=hwc_%U.dmpd parallel=8 FLASHBACK_SCN=33467391237 logfile=$SYSDATE.log schemas=vbs5 parfile=hwc.par

–压缩文件

gzip -f hwc_*.dmpd

–数据恢复

impdp vbs5/vbs5 directory=backup dumpfile=hwc_%U.dmpd parallel=4 table_exists_action=replace

–由于trail日志缺失了很多，所以重新指定ogg的开始文件和rba

alter replicat rqirui01, extseqno 37081,extrba 0

–启动

start * aftercsn 33467391237